Esc

↑↓ move↵ openIndex · Pagefind

How to build a construction cash flow projection: from the cost curve to the month you're lowest

A job's cash flow projection moves every dollar of billing and cost to the month it's actually paid. Spread cost by month, bill it, delay the receipts by the owner's payment terms and retainage, time each kind of cost by its own terms, then run the cumulative total to find the peak cash need. Here is each step and a worked eight-month example.

Charley Forey5 min readCash flowFinanceBilling
On this page
  1. Step 1: Gather the inputs
  2. Step 2: Spread cost by month
  3. Step 3: Bill it
  4. Step 4: Move billings to the month you’re paid
  5. Step 5: Time cash out by type of cost
  6. Step 6: Run the cumulative total
  7. Step 7: Test the terms, then keep it current
  8. Worked example: a six-month, $1.2 million job
  9. Common mistakes
  10. How os.construction handles it
  11. FAQ

To build a construction cash flow projection, spread the job’s cost by month, bill it, then move every dollar to the month it’s actually paid: owner receipts after the payment lag and less retainage, payroll in the month, suppliers on their terms, and subs under their terms or pay-when-paid. Run cash in minus cash out as a cumulative total; the lowest point is the job’s peak cash need.

Profit tells you what a job will earn; cash flow tells you when. The guide to getting paid in construction explains where the gap comes from. This post is the build. The free cash flow projection template does the same steps in Excel (download the .xlsx), and the cash flow S-curve calculator stacks several jobs.

Step 1: Gather the inputs

You need the contract value, the estimated cost (so the margin), the duration, and the payment terms on both sides:

  • Owner side: billing cycle, how long after billing you’re paid, retainage rate, and when retainage is released. These are in the prime contract; see how to read construction contract payment terms.
  • Cost side: how cost splits between self-performed labor, material and subcontracts, your supplier terms, the retainage you hold on subs, and whether your subcontracts are pay-when-paid.

Step 2: Spread cost by month

Use a cost-loaded schedule if you have one. If not, spread cost along an S-curve: light at mobilization, heavy through the middle, tapering through finishes and closeout. The monthly percentages must add to 100%.

Step 3: Bill it

Most jobs bill progress monthly against the schedule of values. For a projection, the simplest assumption is that billing follows cost at the contract’s margin: billing = cost ÷ (1 − margin). If you plan to bill differently, for example front-loaded mobilization, model it.

Step 4: Move billings to the month you’re paid

Shift each month’s billing by the owner’s payment lag, and take off retainage. Put the retainage release in its own month, usually some time after completion, once closeout conditions are met. This is cash in.

Step 5: Time cash out by type of cost

  • Payroll: in the month the work is done.
  • Material: on supplier terms, for example the month after delivery.
  • Subcontractors: on their terms, less the retainage you hold. Under pay-when-paid, they’re paid after you are, so their timing follows the owner’s.
  • Sub retainage: released when the owner releases yours, if your subcontracts tie them together.

Step 6: Run the cumulative total

Net cash each month is cash in minus cash out. The running total is the job’s cash position. Its lowest point is the peak cash need: the amount of working capital or credit line the job needs. At the end it should equal the job’s profit.

Step 7: Test the terms, then keep it current

Change one term at a time: a longer owner lag, higher retainage, subs on fixed terms. That shows what each term is worth, which is useful at contract negotiation. Once the job starts, replace projected months with actual receipts and payments every month after billing.

Worked example: a six-month, $1.2 million job

Illustrative numbersA made-up job with simple terms, chosen so the arithmetic is easy to follow.

Inputs

  • Contract $1,200,000; cost $1,080,000; margin $120,000 (10%).
  • Cost curve over six months: 10%, 15%, 25%, 25%, 15%, 10%.
  • Cost split: labor 30%, material 20%, subcontracts 50%.
  • Owner pays one month after each billing and holds 10% retainage, released in month 8.
  • Labor paid in the month; material paid the following month; subs paid when the GC is paid (pay-when-paid), less 10% retainage released in month 8.

Cost and billing

Month Cost Billing (cost ÷ 0.9) Labor Material Subs
1 $108,000 $120,000 $32,400 $21,600 $54,000
2 $162,000 $180,000 $48,600 $32,400 $81,000
3 $270,000 $300,000 $81,000 $54,000 $135,000
4 $270,000 $300,000 $81,000 $54,000 $135,000
5 $162,000 $180,000 $48,600 $32,400 $81,000
6 $108,000 $120,000 $32,400 $21,600 $54,000
Total $1,080,000 $1,200,000 $324,000 $216,000 $540,000

Cash by month

Cash in is last month’s billing × 90%. Subs paid is last month’s sub cost × 90%. Material paid is last month’s material.

Month Cash in Labor paid Material paid Subs paid Net Cumulative
1 $0 $32,400 $0 $0 −$32,400 −$32,400
2 $108,000 $48,600 $21,600 $48,600 −$10,800 −$43,200
3 $162,000 $81,000 $32,400 $72,900 −$24,300 −$67,500
4 $270,000 $81,000 $54,000 $121,500 +$13,500 −$54,000
5 $270,000 $48,600 $54,000 $121,500 +$45,900 −$8,100
6 $162,000 $32,400 $32,400 $72,900 +$24,300 +$16,200
7 $108,000 $21,600 $48,600 +$37,800 +$54,000
8 $120,000 retainage $54,000 retainage +$66,000 +$120,000

The peak cash need is $67,500, at the end of month 3. The job turns cash-positive in month 6 and ends at +$120,000, the margin, once both retainages are settled in month 8. Total cash in is $1,200,000 and total cash out $1,080,000, so the columns tie.

One term changed. If the owner pays two months after billing instead of one, and the subs, being pay-when-paid, move with it, the low point becomes $202,500 at the end of month 4: three times as deep, from one extra month of owner lag on the same job. Labor and material don’t wait for the owner, which is why the hole deepens.

Cumulative cash position by month, two owner payment termsWith the owner paying one month after billing, cumulative cash falls to minus 67,500 dollars in month 3, turns positive in month 6 and ends at 120,000 in month 8. With a two-month lag it falls to minus 202,500 in month 4, turns positive only in month 8, and also ends at 120,000.$0−67,500−202,500+120,000M1M2M3M4M5M6M7M8PAID 1 MONTH AFTER BILLINGPAID 2 MONTHS AFTER (DASHED)
Same job, same profit, different owner terms. The low point is what your working capital or credit line has to carry. Illustrative.

Common mistakes

  • Treating billing as cash. A pay app is a receivable until it’s paid, less retainage.
  • Forgetting retainage on both sides. Owner retainage delays cash in; sub retainage delays cash out.
  • Assuming pay-when-paid covers everything. Payroll and many suppliers don’t wait, and pay-when-paid clauses aren’t enforceable the same way everywhere.
  • A straight-line cost spread. Most jobs spend fastest in the middle; a flat spread understates the peak.
  • One job at a time. Several jobs hitting their low points together is what strains a credit line. Add them up.
  • Building it once. Update it monthly with actuals, or it drifts from the bank balance.

General information, not legal or financial advice. Payment terms, retainage and the enforceability of pay-when-paid and pay-if-paid clauses depend on the contract and the law where the project sits.

How os.construction handles it

In Accounting, Financial Reports include a cash forecast 13 weeks or 12 months ahead that starts from your bank balances. Inflows come from open receivables timed by each customer’s days to pay, retainage released after completion and unbilled contract value; outflows from open payables, commitments, payroll, debt and leases. Scenarios overlay changes without altering the base, and a stored snapshot reports forecast vs actual. Remaining contract and commitment value is spread evenly to completion today; cost-loaded project cash curves like the one above are planned. See Cash forecasting.

FAQ

How do you make a cash flow projection for a construction project?

Spread the job's cost by month, from the estimate or a cost-loaded schedule. Bill it each month, then move each billing to the month the owner pays it, less retainage. Time each kind of cost by its own terms: payroll in the month, suppliers on their terms, subcontractors when their terms or a pay-when-paid clause say. Cash in minus cash out, run as a cumulative total, is the job's cash position.

What is peak cash need on a construction job?

The lowest point of the job's cumulative cash position: the most of your own cash or credit line the job uses at one time. It usually falls in the first half of the job, before collections catch up with spending.

What has the biggest effect on a construction job's cash flow?

Timing terms: how long the owner takes to pay, how much retainage is held and when it's released, and how quickly you have to pay labor, suppliers and subs. Changing one term at a time in the projection shows what each is worth on that job.

How often should a cash flow projection be updated?

At least monthly, after billing and the cost review, replacing projected months with actual receipts and payments. Many contractors also keep a short-term company cash forecast by week.

Is a cash flow projection the same as a WIP schedule?

No. The WIP schedule measures earned revenue and billing position at a date; the cash flow projection is about when money actually moves. A job can be under-billed on the WIP and still cash-positive, or the reverse.

Share this article

Written by

Charley Forey

Founder of os.construction. We're building the operating system for construction. Project Financials follows job money, and company Accounting covers the books and controls. AI agents remain planned. We write about how money and data actually move on a job, and we build in public.

Apply to the founding program →Start a free trial →
Keep readingAll articles →
Billing

How to bill stored materials on a pay application, and move them to installed

Stored materials let you bill for equipment and material that is bought and delivered but not yet installed. Check the contract first, get off-site storage approved in advance, send the backup with the bill, put the amount in the stored materials column, and move it to work completed when it goes in so it is never billed twice. Here is each step with a two-month worked example.

7 min read

Cash flow

How to build a 13-week cash flow forecast for a construction company

A 13-week cash forecast lists every receipt and payment the company expects, week by week, starting from the cash actually in the bank. Date receipts by when each owner really pays, date payments by payroll, terms and pay-when-paid, set a minimum balance, and roll it forward every week against what happened. Here is each step and a worked 13-week example with a low week.

7 min read

Contracts

How to read the payment terms in a construction contract: a clause-by-clause checklist

Payment terms decide when your work turns into cash, and they're spread across the agreement, the general conditions and the supplementary conditions. Find the billing cycle, the review period, the due date, retainage, the conditions to payment, the grounds to withhold and what happens when payment is late. Here is a checklist and a worked timeline.

5 min read

Open file