What Is a Cash Flow Forecast?
A cash flow forecast projects a business's expected cash inflows and outflows over a future period, showing whether the business will have enough cash on hand to meet its obligations as they come due. Unlike the historical statement of cash flows, which reports what already happened, a forecast looks forward.
Why Cash Flow Forecasting Matters
A profitable business can still run out of cash if payments come due before collections arrive, which is exactly the gap the cash conversion cycle measures structurally. A forecast makes that gap visible in advance, at a specific point in time, rather than discovering it the week a payroll or a large supplier payment cannot be covered.
It also supports decisions that need a forward view rather than a historical one: whether the business can afford a large purchase, whether a credit line needs to be drawn, and when it might be safe to make a discretionary investment.
Building a Direct-Method Cash Flow Forecast
- Start with the current cash balance.
The known, actual starting point.
- Project cash inflows.
Expected customer collections based on outstanding receivables and their typical payment timing, plus any other known cash receipts.
- Project cash outflows.
Known payables coming due, payroll, rent, and other recurring obligations, based on actual commitments rather than budget estimates.
- Calculate the projected ending balance.
Starting balance plus inflows minus outflows, for each period in the forecast.
- Roll forward period by period.
Each period's ending balance becomes the next period's starting balance, extending the forecast out as far as needed.
EXAMPLE
Starting cash: $180,000. Expected collections this month: $310,000. Expected payments: $340,000 (payables, payroll, rent).
Projected ending balance = $180,000 + $310,000 − $340,000 = $150,000.
The business remains cash-positive, but the $30,000 net outflow this period is worth watching if the trend continues.
Short-Term vs. Long-Term Cash Flow Forecasts
- 13-week forecast:
the standard short-term horizon, detailed and built from known, specific transactions rather than estimates. Used for operational cash management and spotting near-term shortfalls.
- 12-month forecast:
a longer horizon built more from budgeted or projected figures than known transactions, since specific invoices and receipts that far out are not yet known. Used for planning, financing decisions, and board reporting.
The two serve different purposes and are typically maintained separately: the short-term forecast needs to be precise enough to act on this week, while the long-term forecast needs to be directionally right for planning purposes.
Why Forecasts Drift From Reality
A cash flow forecast is only as good as its inputs, and the payables side is often the weakest one. If the forecast assumes invoices will be processed and paid on their normal schedule, but a backlog of unprocessed invoices means payments actually cluster unpredictably instead, the forecast's outflow timing will be wrong even if the total amount is roughly right.
The same applies to collections: a forecast built on stated payment terms rather than actual customer payment behavior, reflected in days sales outstanding, will consistently overstate near-term cash availability if customers are, in practice, paying later than terms specify.
Improving Forecast Accuracy
- Use actual AP data, not budget estimates:
known invoices and their actual due dates are far more reliable than a budgeted monthly total.
- Base collections on real DSO, not stated terms:
actual customer payment behavior, not the invoice terms, predicts when cash will actually arrive.
- Update frequently:
a forecast refreshed weekly against actual results stays useful; one built once a quarter drifts quickly.
- Track forecast accuracy over time:
comparing forecasted to actual results each period reveals which assumptions are systematically wrong and need adjustment.
Frequently Asked Questions About Cash Flow Forecast
1. What is a cash flow forecast?
A cash flow forecast projects a business's expected cash inflows and outflows over a future period, showing whether it will have enough cash to meet obligations as they come due. It looks forward, unlike the historical statement of cash flows.
2. How do you build a cash flow forecast?
Start with the current cash balance, project expected collections and other inflows, project known payables and other outflows, calculate the projected ending balance for each period, and roll that balance forward as the starting point for the next period.
3. What is the difference between a 13-week and a 12-month cash flow forecast?
A 13-week forecast is short-term and built from specific known transactions, used for operational cash management. A 12-month forecast is longer-term and built more from budgeted figures, used for planning and financing decisions rather than day-to-day cash management.
4. Why do cash flow forecasts often turn out to be inaccurate?
The payables side is commonly the weakest input: if a backlog of unprocessed invoices means payments cluster unpredictably rather than following their normal schedule, forecasted outflow timing will be wrong even if the total is roughly correct.
5. How does days sales outstanding affect a cash flow forecast?
A forecast based on stated payment terms rather than actual DSO will overstate near-term cash availability whenever customers pay later than their terms specify, since real payment behavior, not the invoice terms, predicts when cash actually arrives.
6. How can a business improve cash flow forecast accuracy?
Base outflows on actual AP data and known due dates rather than budget estimates, base inflows on real DSO rather than stated terms, refresh the forecast frequently, and track forecasted versus actual results over time to identify which assumptions need correcting.
