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.
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:
Formula 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)| A | B | C | D | E | F | G | H | I | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Construction cash flow projection | |||||||||||
| 2 | Project | Riverside clinic building (sample) | Results | |||||||||
| 3 | Contract value | $6,000,000 | Total cost | $5,400,000 | ||||||||
| 4 | Gross margin | 10.0% | Cost curve total (must be 100%) | 100.0% | ||||||||
| 5 | First month of work | 3/1/2026 | Check | OK | ||||||||
| 6 | Retainage held by the owner | 10.0% | Peak cash need | $70,200 | ||||||||
| 7 | Owner pays (months after billing) | 1 | Month of peak need | Jul 2026 | ||||||||
| 8 | Retainage released (months after finish) | 2 | Months cash-negative | 7 | ||||||||
| 9 | Subcontracted share of cost | 60.0% | Financing cost (simple interest) | $2,531 | ||||||||
| 10 | Material share of cost | 15.0% | Gross profit | $600,000 | ||||||||
| 11 | Retainage you hold on subs | 10.0% | Profit after financing | $597,469 | ||||||||
| 12 | Material paid (months after delivery) | 1 | Self-performed labor and other share | 25.0% | ||||||||
| 13 | Line of credit rate (APR) | 8.0% | Months of work | 12 | ||||||||
| 14 | Cash positive for good from | Oct 2026 | ||||||||||
| 15 | Blue 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. | |||||||||||
| 16 | Month # | Month | Planned % of cost | Cumulative % | Cost incurred | Billed (gross) | Retainage held | Cash in | Self-performed paid | Cash out | Net cash | Cumulative cash |
| 17 | 1 | Mar 2026 | 2.0% | 2.0% | $108,000 | $120,000 | $12,000 | $0 | $27,000 | $27,000 | ($27,000) | ($27,000) |
| 18 | 2 | Apr 2026 | 4.0% | 6.0% | $216,000 | $240,000 | $24,000 | $108,000 | $54,000 | $128,520 | ($20,520) | ($47,520) |
| 19 | 3 | May 2026 | 6.0% | 12.0% | $324,000 | $360,000 | $36,000 | $216,000 | $81,000 | $230,040 | ($14,040) | ($61,560) |
| 20 | 4 | Jun 2026 | 8.0% | 20.0% | $432,000 | $480,000 | $48,000 | $324,000 | $108,000 | $331,560 | ($7,560) | ($69,120) |
| 21 | 5 | Jul 2026 | 10.0% | 30.0% | $540,000 | $600,000 | $60,000 | $432,000 | $135,000 | $433,080 | ($1,080) | ($70,200) |
| 22 | 6 | Aug 2026 | 12.0% | 42.0% | $648,000 | $720,000 | $72,000 | $540,000 | $162,000 | $534,600 | $5,400 | ($64,800) |
| 23 | 7 | Sep 2026 | 13.0% | 55.0% | $702,000 | $780,000 | $78,000 | $648,000 | $175,500 | $622,620 | $25,380 | ($39,420) |
| 24 | 8 | Oct 2026 | 12.0% | 67.0% | $648,000 | $720,000 | $72,000 | $702,000 | $162,000 | $646,380 | $55,620 | $16,200 |
| 25 | 9 | Nov 2026 | 11.0% | 78.0% | $594,000 | $660,000 | $66,000 | $648,000 | $148,500 | $595,620 | $52,380 | $68,580 |
| 26 | 10 | Dec 2026 | 10.0% | 88.0% | $540,000 | $600,000 | $60,000 | $594,000 | $135,000 | $544,860 | $49,140 | $117,720 |
| 27 | 11 | Jan 2027 | 7.0% | 95.0% | $378,000 | $420,000 | $42,000 | $540,000 | $94,500 | $467,100 | $72,900 | $190,620 |
| 28 | 12 | Feb 2027 | 5.0% | 100.0% | $270,000 | $300,000 | $30,000 | $378,000 | $67,500 | $328,320 | $49,680 | $240,300 |
| 29 | 13 | Mar 2027 | 100.0% | $0 | $0 | $0 | $270,000 | $0 | $186,300 | $83,700 | $324,000 | |
| 30 | 14 | Apr 2027 | 100.0% | $0 | $0 | $0 | $600,000 | $0 | $324,000 | $276,000 | $600,000 | |
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
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 # | Month | Planned % of cost | Cost incurred | Billed (gross) | Cash in | Cash out | Net cash | Cumulative cash |
|---|---|---|---|---|---|---|---|---|
| 1 | Mar 2026 | 2.0% | $108,000 | $120,000 | $0 | $27,000 | ($27,000) | ($27,000) |
| 2 | Apr 2026 | 4.0% | $216,000 | $240,000 | $108,000 | $128,520 | ($20,520) | ($47,520) |
| 3 | May 2026 | 6.0% | $324,000 | $360,000 | $216,000 | $230,040 | ($14,040) | ($61,560) |
| 4 | Jun 2026 | 8.0% | $432,000 | $480,000 | $324,000 | $331,560 | ($7,560) | ($69,120) |
| 5 | Jul 2026 | 10.0% | $540,000 | $600,000 | $432,000 | $433,080 | ($1,080) | ($70,200) |
| 6 | Aug 2026 | 12.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
Using the cash flow projection template
- Enter the contract value, margin and first month of work. Billing is assumed to follow cost, so cost and billing share one curve.
- 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.
- 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.
- 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.
- 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.
- Cost curvePlanned % of cost by month
- BillingFollows cost, less retainage
- Cash inOwner lag, retainage release
- Cash outLabor now, material on terms, subs when paid
- Cumulative cashLow point = peak need
Text version
- Cost curve: Planned % of cost by month
- Billing: Follows cost, less retainage
- Cash in: Owner lag, retainage release
- Cash out: Labor now, material on terms, subs when paid
- Cumulative cash: Low point = peak need
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.
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
- Pillar guideGetting paid in construction
- Free toolCash flow S-curve calculator
- os.constructionConstruction accounting and cash forecast
- GlossaryBacklog
- GlossaryOver billing
- GlossaryPay Application (Pay App)
- GlossaryPay-When-Paid
- GlossaryRetainage
- GlossaryRetainage receivable
- GlossaryUnder billing
- Free resourceCash flow S-curve calculator
- Free resourceRetainage calculator
- Free resourceHow to build a cash flow projection
- Free resourceHow to read contract payment terms
- TemplatePunch list template
- TemplateMeeting minutes template
- TemplateInspection checklist starter pack
- TemplateT&M ticket template
- TemplateRFI writing checklist
- TemplateDaily log checklist
- TemplateChange event log
- TemplateBack charge notice and log
- TemplateThree-week look-ahead template
- TemplateSafety observation log
- TemplateAction item tracker
- TemplateCloseout and TCO checklist
- TemplateNotice to proceed template
- TemplateJob cost report template
- TemplateConstruction schedule (Gantt) template
- TemplateChange order log template
- TemplateBid tabulation and leveling template
- TemplateBuyout log template
- TemplateASI log template
Keep exploring
Related across os.construction
- ExplainerHow retainage moves through a jobOwner to GC to subs over six pay apps: what each tier holds, a reduction at 50%, and the two releases.
- Free toolWIP schedule workbenchCSV in, WIP report out: over/under billing, margin, backlog, loss jobs.
- Free toolCash flow S-curve calculatorMonthly billings, retainage and peak cash need across a job.
- BlogOver billing vs under billing: what your WIP is telling youOver and under billing aren't good or bad on their own. They're symptoms. Here's how to read each one, the questions that separate a billing problem from an estimate problem, and the checks a surety will run before you do.
- BlogHow to read a contractor's financial statements: the lines a surety, lender or owner's rep checks firstA contractor's financial statements are read for one thing: can this company finish its work and pay its bills? Check the CPA's report level and date, then working capital, the over and under billings, retainage, the gross margin trend, leverage and the notes, and tie the balance sheet to the WIP schedule. Here is the order, with a worked balance sheet.
- PlatformCash flow forecasting (use case)How os.construction handles cash flow forecasting on one record.