ProfessionalAvailable now
Project Cash Flow
Build the project cash flow.
Project Control SuiteStep 1 of 6
This calculator is part of a paid level
Unlock this calculator with a single purchase; access stays on your account for life.
Contractors lose money on profitable projects when payment lags exceed working capital. This Professional calculator turns contract value, duration, advance and retention percentages and your certification and payment lags into a monthly picture, including the peak negative exposure the project is likely to demand.
Method and assumptions
Dated cash ledger and independent actual bridge
- Closing=opening+receipts−payments; closing variance=actual closing−forecast closing
- Homes England: monthly funding distribution, not certificate accounting standard.
- https://www.gov.uk/government/publications/completing-your-homes-england-cashflow-spreadsheet/how-to-complete-the-cashflow-spreadsheet
- All references/dates are replaceable examples; one currency and declared sources, not automatic document verification. Rows replace legacy calculations, never reprice saved results.
- Unique periods with valid sorted dates; opening may be negative. Available actuals must be a contiguous prefix; after first unavailable period no later actuals. No certificates treated as receipts, automatic credit draws or assumed post-horizon cash.
- Legacy calculation remains limited; new method definitions apply only to the new ledger.
Frequently asked questions
- Is this a real S-curve?
- No, and the tool states so. It assumes evenly linear monthly certified progress — a planning simplification, not a schedule-driven S-curve.
- What is peak negative exposure?
- The cash the contractor is expected to fund before payments catch up: monthly cost outflow multiplied by the combined certification and payment lag, less the advance payment.
- What is the cost-to-value ratio?
- The share of each certified amount that leaves as cost. You enter it from your own commercial position; the tool assumes no margin.
- Can it produce a bank-ready forecast?
- It is a preliminary planning estimate. A funding submission should be built on the actual programme and the certified payment history.
Next step and related links
Related calculators
- 13-Week Cash ForecastProject Control
- Earned ValueProject Control
- Cost-to-CompleteProject Control
Free calculators are open to everyone, and CSV export is free for everyone too. Project saving and PDF/Excel reports come with Professional, and integrated workflows with Premium.


