Esc

↑↓ move↵ openIndex · Pagefind

A cash flow projection that finds the low point.

Spread a job’s cost along an S-curve, then move every dollar to the month it is actually paid: owner payments lag and hold retainage, subs are paid when you are, suppliers on terms. The sheet finds the peak cash need, the month it hits and what it costs to finance.

  • Free
  • No signup
  • Excel · Google Sheets · LibreOffice
The Excel file

What’s in the workbook

The download is one Excel file (70 KB) with 2 sheets: Instructions, Cash flow. The formulas are live, the inputs are marked, and it opens in Excel for Windows and Mac, Excel for the web, Google Sheets and LibreOffice. This is the Cash flow sheet with the sample data:

H18Formula in H18: =(IF(A18-$D$7<1,0,INDEX($F$17:$F$40,A18-$D$7))-IF(A18-$D$7<1,0,INDEX($G$17:$G$40,A18-$D$7)))+IF(A18=$I$13+$D$8,SUM($G$17:$G$40),0)
Cash flow projection template: preview of the “Cash flow” sheet in cash-flow-projection-template.xlsx, with the sample data
ABCDEFGHILMN
1Construction cash flow projection
2ProjectRiverside clinic building (sample)Results
3Contract value$6,000,000Total cost$5,400,000
4Gross margin10.0%Cost curve total (must be 100%)100.0%
5First month of work3/1/2026CheckOK
6Retainage held by the owner10.0%Peak cash need$70,200
7Owner pays (months after billing)1Month of peak needJul 2026
8Retainage released (months after finish)2Months cash-negative7
9Subcontracted share of cost60.0%Financing cost (simple interest)$2,531
10Material share of cost15.0%Gross profit$600,000
11Retainage you hold on subs10.0%Profit after financing$597,469
12Material paid (months after delivery)1Self-performed labor and other share25.0%
13Line of credit rate (APR)8.0%Months of work12
14Cash positive for good fromOct 2026
15Blue cells on yellow are inputs. Paste your own monthly cost curve into column C (it must add to 100%). Billing follows cost; cash in lags billing and holds retainage; subs are paid when you are paid. Sample data is illustrative.
16Month #MonthPlanned % of costCumulative %Cost incurredBilled (gross)Retainage heldCash inSelf-performed paidCash outNet cashCumulative cash
171Mar 20262.0%2.0%$108,000$120,000$12,000$0$27,000$27,000($27,000)($27,000)
182Apr 20264.0%6.0%$216,000$240,000$24,000$108,000$54,000$128,520($20,520)($47,520)
193May 20266.0%12.0%$324,000$360,000$36,000$216,000$81,000$230,040($14,040)($61,560)
204Jun 20268.0%20.0%$432,000$480,000$48,000$324,000$108,000$331,560($7,560)($69,120)
215Jul 202610.0%30.0%$540,000$600,000$60,000$432,000$135,000$433,080($1,080)($70,200)
226Aug 202612.0%42.0%$648,000$720,000$72,000$540,000$162,000$534,600$5,400($64,800)
237Sep 202613.0%55.0%$702,000$780,000$78,000$648,000$175,500$622,620$25,380($39,420)
248Oct 202612.0%67.0%$648,000$720,000$72,000$702,000$162,000$646,380$55,620$16,200
259Nov 202611.0%78.0%$594,000$660,000$66,000$648,000$148,500$595,620$52,380$68,580
2610Dec 202610.0%88.0%$540,000$600,000$60,000$594,000$135,000$544,860$49,140$117,720
2711Jan 20277.0%95.0%$378,000$420,000$42,000$540,000$94,500$467,100$72,900$190,620
2812Feb 20275.0%100.0%$270,000$300,000$30,000$378,000$67,500$328,320$49,680$240,300
2913Mar 2027100.0%$0$0$0$270,000$0$186,300$83,700$324,000
3014Apr 2027100.0%$0$0$0$600,000$0$324,000$276,000$600,000
InstructionsCash flow
Rendered from the downloadable file: same formulas, same sample numbers, same conditional formatting. Sample data is illustrative.

Sheets

Instructions
Inputs, how each cash line is timed, and the assumptions behind the model.
Cash flow
Eleven inputs, a results block with peak cash need and financing cost, a 24-month table and a chart of cumulative cost, cash received and cash position.

Built in

  • Live formulas: change an input and every total, flag and chart updates
  • Frozen header rows and columns, so labels stay put as you scroll
  • Drop-down lists and value checks on the input cells
  • Conditional formatting for flags and overruns
  • An Instructions sheet with every column defined
  • Prints landscape, one page wide, with the header row repeated
Download the .xlsx
Worked example (illustrative)

Worked example: a 12-month, $6 million job

Illustrative inputs from the sample file: a $6,000,000 contract at a 10.0% margin, 60% subcontracted and 15% material, with the owner paying a month after each pay app and holding 10.0% retainage until two months after the work ends.

The job is cash-negative for 7 months. The low point is $70,200 in Jul 2026: that is what working capital or a credit line carries. At 8.0% it costs about $2,531 in interest. Cash turns positive for good in Oct 2026, and the $600,000 of retainage comes in two months after the last billing.

Pay-when-paid keeps the hole shallow here: the subs, 60% of cost, are paid only after the owner pays. Set the sub share lower and the material share higher to model subs on fixed terms, and the low point deepens.

The formulas in the file

Cash inCash flow · H18

=(IF(A18-$D$7<1,0,INDEX($F$17:$F$40,A18-$D$7))-IF(A18-$D$7<1,0,INDEX($G$17:$G$40,A18-$D$7)))+IF(A18=$I$13+$D$8,SUM($G$17:$G$40),0)

Billing from the owner-lag months ago, less retainage, plus the retainage release in its month.

Subs paidCash flow · K18

=IF(A18-$D$7<1,0,INDEX($E$17:$E$40,A18-$D$7))*$D$9*(1-$D$11)+IF(A18=$I$13+$D$8,SUM($E$17:$E$40)*$D$9*$D$11,0)

Sub cost from the owner-lag months ago, less the retainage you hold, plus sub retainage when yours is released.

Cumulative cashCash flow · N18

=SUM($M$17:M18)

Running total of cash in minus cash out.

Peak cash needCash flow · I6

=-MIN(0,MIN($N$17:$N$40))

The lowest cumulative cash position, shown as a positive amount.

Financing costCash flow · O18

=IF(N18<0,-N18*$D$13/12,0)

Negative cumulative cash × APR ÷ 12: simple monthly interest.

Cash flow projection template: printable version

os.construction · free template
Project
Contract value
First month of work
Prepared by

Monthly cash flow (first months of the sample)

Month #MonthPlanned % of costCost incurredBilled (gross)Cash inCash outNet cashCumulative cash
1Mar 20262.0%$108,000$120,000$0$27,000($27,000)($27,000)
2Apr 20264.0%$216,000$240,000$108,000$128,520($20,520)($47,520)
3May 20266.0%$324,000$360,000$216,000$230,040($14,040)($61,560)
4Jun 20268.0%$432,000$480,000$324,000$331,560($7,560)($69,120)
5Jul 202610.0%$540,000$600,000$432,000$433,080($1,080)($70,200)
6Aug 202612.0%$648,000$720,000$540,000$534,600$5,400($64,800)

Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/cash-flow-projection

How to use it

Using the cash flow projection template

  1. Enter the contract value, margin and first month of work. Billing is assumed to follow cost, so cost and billing share one curve.
  2. Set how cash comes in: the retainage the owner holds, how many months after each pay app the owner pays, and how long after the work ends retainage is released.
  3. Set how cash goes out: the subcontracted and material shares of cost, the retainage you hold on subs and your supplier terms. The rest is self-performed labor, paid in the month.
  4. Replace the sample S-curve with your own monthly cost from the estimate or a cost-loaded schedule. It must add to 100%; the check cell turns green.
  5. Read the peak cash need and the month it happens, then change one term at a time (owner pay days, sub terms, retainage) to see what each is worth.
How a month’s cash is builtCost curve, then Billing, then Cash in, then Cash out, then Cumulative cash.Cost curvePlanned % of cost by monthBillingFollows cost, less retainageCash inOwner lag, retainage releaseCash outLabor now, material on terms, subs when paidCumulative cashLow point = peak need
  1. Cost curvePlanned % of cost by month
  2. BillingFollows cost, less retainage
  3. Cash inOwner lag, retainage release
  4. Cash outLabor now, material on terms, subs when paid
  5. Cumulative cashLow point = peak need
How a month’s cash is built
Text version
  1. Cost curve: Planned % of cost by month
  2. Billing: Follows cost, less retainage
  3. Cash in: Owner lag, retainage release
  4. Cash out: Labor now, material on terms, subs when paid
  5. Cumulative cash: Low point = peak need
In os.construction

Do this in os.construction instead of a spreadsheet

In os.construction, Financial Reports include a job-aware cash forecast 13 weeks or 12 months ahead, starting from your bank balances: inflows from open receivables timed by each customer’s days to pay, retainage released after completion and unbilled contract value, and outflows from open payables, commitments, payroll, debt and leases, with scenarios and forecast vs actual. Remaining contract and commitment value is spread evenly to completion today; cost-loaded project cash curves like this S-curve are planned.

Try it on the sample project

Every trial workspace includes a sample project to run this workflow on. 14-day free trial. Pricing for paid plans isn't set yet.

FAQ

Questions about the cash flow projection template

How do you make a construction cash flow projection?

Spread the contract and its cost over the months of the job, usually along an S-curve or the cost-loaded schedule. Shift each billing by the owner’s payment lag and hold back retainage until it is released. Shift each cost by its payment terms: labor in the month, suppliers on terms, subs when you are paid. The running total of cash in minus cash out is the job’s cash position.

What is an S-curve in construction?

The shape of cumulative cost or progress over time on most jobs: slow at mobilization, steep through the middle as trades stack up, flattening through finishes and closeout. Plotting cumulative cost against cumulative cash received shows the gap your working capital has to fund.

What is peak cash need?

The lowest point of the job’s cumulative cash position: the most of your own cash or credit line the job uses at once. It usually comes in the first half of the job, before collections catch up with cost.

Does pay-when-paid solve cash flow?

It moves timing risk to subcontractors for the subcontracted share of cost, but self-performed labor and suppliers on fixed terms still create a gap, and enforceability of pay-when-paid and pay-if-paid clauses varies by state. This is general information, not legal advice.

Can I model several jobs together?

Use one copy per job and add the monthly net cash rows on a calendar, or use the free cash flow calculator, which stacks jobs with company overhead and a credit line to find the company-level low point.

Keep going

Open file