---
title: "Cash flow forecasting and the link to project finance"
description: "Cost is not cash A project can be within budget and still run out of money. Cost (the EVM view) tells you what work is worth; cash flow tells you when…"
url: https://optimizeall.com/learn/project-controls-with-ai/cash-flow-and-funding
updated: 2026-10-05
---

Project Controls in the AI Era · Forecasting cost and schedule outcomes · lesson 12 of 22 · 13 min

# Cash flow forecasting and the link to project finance

## Cost is not cash

A project can be within budget and still run out of money. Cost (the EVM view) tells you what work is worth; **cash flow** tells you when money leaves and arrives. Controls teams increasingly own or contribute to cash forecasts because they have the schedule, commitments and progress data that drive them.

## From cost forecast to cash forecast

Convert time-phased cost into cash by applying payment terms and timing:

1. **Start from the time-phased ETC** by control account.
2. **Apply payment terms.** Subcontractor paid 30 or 60 days after valuation; materials paid on delivery or with deposits; staff paid monthly.
3. **Apply retention.** Many construction contracts retain a percentage (commonly around 5–10%, contract-specific) released at completion or after a defects period.
4. **Add advance payments and their recovery.** Advances received from a client are typically recovered by deduction from later payments.
5. **Model income** (for contractors) from the client's payment terms, valuation cycle and any milestone payments.
6. **Net and accumulate** to see peak funding need.

## Worked example: a contractor's cash position

*Illustrative.* A fictional contractor in Jeddah has a 6-month contract worth $6M with monthly valuations, the client paying 45 days after each valuation, 10% retention, and a 10% advance recovered pro rata. Costs are paid, on average, 30 days after incurred. The result is typically a negative cash position in early months, sometimes several hundred thousand dollars, even though the job is profitable. Knowing the **peak negative cash** tells the finance team how much working capital or credit facility is needed and when.

```
Month           1      2      3      4      5      6
Cost incurred   800   1,100  1,200  1,100   900   500   (USD 000)
Cash out        –      800   1,100  1,200  1,100   900  (+500 in M7)
Valuation      900   1,200  1,300  1,200  1,000   400
Cash in (net)  600*    –     720    960   1,040   960   (* advance received M1)
```

(Numbers simplified: cash in reflects 45-day lag approximated to the following month or later, less retention and advance recovery.) The point is the method, not the specific figures.

## Owner's perspective

For an owner or developer, the cash forecast drives funding drawdowns: equity injections, loan draws and the timing of financing costs. On project-financed assets (energy, infrastructure, PPPs), lenders require regular reporting of cost to complete and funding sufficiency, often verified by an independent engineer. If the forecast shows costs exceeding available funds, it triggers lender discussions long before money runs out.

## Key links between controls and project finance

| Controls output | Finance use |
|---|---|
| EAC and contingency position | Funding sufficiency test (are sources ≥ uses?) |
| Forecast completion date | Interest during construction, start of revenue, debt repayment timing |
| Change and claims log | Potential cost increases and contractual recoveries |
| Risk-adjusted ranges (P50/P80) | Sizing contingency and standby facilities |

The companion course *Project Finance and Financial Modelling* covers capital structure, cash-flow waterfalls and coverage ratios in depth.

## S-curves for cash

Plot cumulative cash out, cash in and net cash. The gap between the cost S-curve and the cash-out S-curve shows payment lag; the minimum point of the net cash curve shows peak funding need.

## Common mistakes

- Assuming cash equals cost in the same month.
- Ignoring retention, advances and their recovery.
- Not updating the cash forecast when the schedule slips; delays shift both costs and income.
- Forgetting taxes, duties and currency conversions in cash timing.
- Treating the finance team's cash plan and the controls team's cost plan as unrelated.

## Template: cash forecast

```
Month | Cost incurred | Payment lag | Cash out | Valuation/billing | Retention | Advance recovery | Cash in | Net | Cumulative net
```

## AI note

AI tools can learn actual payment behaviour (which clients or subcontractors pay late) from accounts data and improve cash timing predictions. Review them against contract terms and relationships before relying on them.

## Quick self-check

Ask finance and controls to compare their numbers for the next three months. Do the cash-out figures match the cost forecast shifted by payment terms? Do income assumptions match the client's actual payment behaviour? Is the peak funding need covered by available facilities with headroom? A short joint review each month, using one shared template, prevents the surprise of a profitable project that suddenly cannot pay its suppliers or has to draw on expensive short-term credit.

## Hands-on: a cash forecast in Excel

Months in columns `C:J`; named inputs `Ret` (e.g. 10%), `Adv_pct` (e.g. 10%), `Contract` (e.g. 6,000).

```text
Row 3  Cost incurred       (from time-phased ETC)
Row 4  Cash out            D4 =C3            (30-day lag: previous month's cost)
Row 5  Valuation           (from progress forecast)
Row 6  Retention           C6 =-C5*Ret
Row 7  Advance recovery    C7 =-C5*Adv_pct   (recovers the advance pro rata to valuation)
Row 8  Net certified       C8 =C5+C6+C7
Row 9  Cash in             D9 =C8  (about 45 days: shift one or two columns per contract terms); C9 adds the advance =Contract*Adv_pct
Row 10 Net cash            =C9-C4
Row 11 Cumulative net      C11 =C10 ; D11 =C11+D10
Peak funding need          =MIN(C11:J11)
Month of peak              =INDEX(C1:J1, MATCH(MIN(C11:J11), C11:J11, 0))
```

Release retention as a positive line in the month the contract allows (often after completion or a defects period).

## Hands-on: the same model in Python

```python
import pandas as pd

cost = pd.Series([800, 1100, 1200, 1100, 900, 500], index=range(1, 7))   # USD 000, illustrative
val = pd.Series([900, 1200, 1300, 1200, 1000, 400], index=range(1, 7))
ret, adv = 0.10, 0.10
months = range(1, 10)
cash_out = cost.reindex(months, fill_value=0).shift(1, fill_value=0)      # 30-day lag
net_cert = val * (1 - ret - adv)
cash_in = net_cert.reindex(months, fill_value=0).shift(2, fill_value=0)   # ~45 days → two-month lag here
cash_in[1] += 6000 * adv                                         # advance received in M1
df = pd.DataFrame({"cash_in": cash_in, "cash_out": cash_out})
df["net"] = df.cash_in - df.cash_out
df["cumulative"] = df.net.cumsum()
print(df, "\nPeak funding need:", df.cumulative.min(), "in month", df.cumulative.idxmin())
```

The lag convention (one or two months for 45 days) is a modelling choice; state it in the assumptions. Retention release is omitted here for brevity.

## How to measure success

- Controls and finance cash forecasts for the next three months agree within an agreed tolerance.
- Peak funding need is known, dated and covered by facilities with headroom.
- The cash forecast updates automatically when the schedule forecast moves.

## Video lecture: Cash flow forecasting and the link to project finance

Lecture coming soon · 9 chapters · about 8 minutes. Read the full transcript below.

1. Profitable and still out of money
2. Why it matters
3. The concept: payment timing
4. Worked example one: a thirty-day lag
5. Worked example two: a contractor in Jeddah
6. Watch me do it: a cash forecast in Excel
7. The owner's view and the finance link
8. Common mistakes
9. Recap and try this now

## Lecture transcript

### Profitable and still out of money

Here's a situation that surprises a lot of people. A contractor wins a profitable job. Every monthly cost report shows healthy margins. And three months in, it can't pay its suppliers. How? Because cost and cash are not the same thing. The contractor pays its people and suppliers long before the client pays it. In this lecture you'll learn how to convert a time-phased cost forecast into a cash forecast by applying payment terms, retention and advance payments, how to find the peak funding need, and how controls outputs feed directly into project finance. By the end you'll be able to build a simple monthly cash forecast and explain to a finance director exactly when and how much money the project needs.

### Why it matters

Why does this matter to controls? Earned value tells you what the work is worth. Cash flow tells you when money leaves and arrives. Both matter, and the controls team is often best placed to forecast cash, because it holds the schedule, the commitments and the progress data that drive the timing. When the schedule slips, both costs and income move. When a subcontract changes payment terms, cash moves even if cost doesn't. If controls and finance work from separate plans, the first time anyone notices the gap is when the overdraft limit is hit.

### The concept: payment timing

Here's the method. Think of it like your own household budget with a salary that arrives at the end of the month but bills that come in at different times. Start from the time-phased estimate to complete by control account. Apply payment terms: a subcontractor paid thirty or sixty days after valuation, materials paid on delivery or with deposits, staff paid monthly. Apply retention: many construction contracts hold back a percentage of each payment, often around five to ten per cent, depending on the contract, released at completion or after a defects period. Add any advance payment received and model its recovery through deductions from later payments. For a contractor, model income from the client's payment terms. Then net the two, accumulate, and find the lowest point of the cumulative curve. That's your peak funding need.

### Worked example one: a thirty-day lag

A simple example first. Your costs are one hundred thousand a month for four months, and you pay everyone thirty days after the cost is incurred. Month one: cost one hundred, cash out zero. Month two: cost one hundred, cash out one hundred, for month one's work. And so on, until month five, when the final hundred goes out. The cumulative cash curve is simply the cost curve shifted one month to the right. That gap is good news for the payer: it's effectively short-term credit from suppliers. And it's exactly the reverse for whoever is waiting to be paid. Now imagine the client pays you forty-five days after each valuation, minus ten per cent retention. You can see the problem forming already.

### Worked example two: a contractor in Jeddah

Now the realistic example from the lesson. A fictional contractor in Jeddah has a six-month contract worth six million dollars. Monthly valuations. The client pays forty-five days after each valuation, with ten per cent retention, and a ten per cent advance paid up front, recovered pro rata from each payment. The contractor pays its own costs about thirty days after they're incurred. Here's what happens. Month one, the advance arrives, which helps. But by months two and three, costs are running at over a million a month, and client payments for those months haven't arrived yet, reduced by retention and advance recovery when they do. The cumulative net cash position goes negative, potentially by several hundred thousand, even though the job is profitable. Knowing that low point, and when it occurs, tells finance how much working capital or credit facility is needed.

### Watch me do it: a cash forecast in Excel

Let me show you the template. Months across the top. Row one, cost incurred, from the time-phased forecast. Row two, cash out: I simply reference the previous month's cost, which models a thirty-day lag. For a sixty-day lag, I reference two columns back. Row three, valuation or billing. Row four, retention: ten per cent of each valuation, as a negative. Row five, advance recovery: the advance divided across the valuations, also negative. Row six, cash in: the net valuation received one or two months later, depending on the client's terms. Then net cash, cumulative net cash, and one final cell: MIN of the cumulative row. That's the peak funding need. I chart cumulative cost, cumulative cash out and cumulative net on one graph, and the lowest point of the net line is the number finance needs.

### The owner's view and the finance link

Now the owner's side. For an owner or developer, the cash forecast drives funding drawdowns: equity injections, loan draws and the timing of financing costs. On project-financed assets, such as energy, infrastructure and public-private partnerships, lenders require regular reporting of cost to complete and funding sufficiency, often verified by an independent engineer. So controls outputs flow straight into finance. The EAC and contingency position feed the test of whether sources still cover uses. The forecast completion date drives interest during construction, the start of revenue and the timing of debt repayment. The change and claims log shows potential cost increases. And the P50 and P80 ranges from risk analysis help size contingency and standby facilities. The companion course on project finance takes this much further.

### Common mistakes

The common mistakes. Assuming cash equals cost in the same month. Ignoring retention, advances and their recovery, which can make income look far healthier than it is. Not updating the cash forecast when the schedule slips; delays shift both costs and income, and usually push income further than costs. Forgetting taxes, duties and currency conversions in cash timing. And treating finance's cash plan and controls' cost plan as unrelated documents. On AI: tools can learn actual payment behaviour, such as which clients or subcontractors habitually pay late, from accounts data, and improve cash timing predictions. That's useful, but review predictions against the contract terms and the relationships you actually have before relying on them.

### Recap and try this now

Let's recap. A project can be within budget and still run out of money, because cost and cash move at different times. Build the cash forecast from the time-phased cost forecast by applying payment terms, retention and advance recovery. Net and accumulate, and the lowest point of the cumulative net line is your peak funding need. Keep the cash forecast linked to the schedule so slips flow through automatically, and share one template with finance. Each month, ask finance and controls to compare the next three months side by side. Your try-this-now: take a simple six-month cost profile and convert it into a cash-out profile using a thirty-day payment lag. Plot cumulative cost against cumulative cash, then add a client income row with forty-five days and ten per cent retention, and find the peak funding need.

## Key takeaways

- Cost shows value of work; cash shows timing. Profitable projects can still run out of cash.
- Convert time-phased cost to cash using payment terms, retention and advance recovery.
- Peak negative cumulative cash defines working-capital or funding need.
- EAC, forecast dates and risk ranges feed funding sufficiency and lender reporting.

## Try it

Take a simple 6-month cost profile and convert it to a cash-out profile using a 30-day payment lag; plot cumulative cost vs cumulative cash.

- [Previous: Running forecast reviews that change decisions](https://optimizeall.com/learn/project-controls-with-ai/forecast-reviews)
- [Next: Risk registers that drive action](https://optimizeall.com/learn/project-controls-with-ai/risk-registers)
- [All lessons of Project Controls in the AI Era](https://optimizeall.com/learn/project-controls-with-ai)