Cash flow forecasts
Cash Flow Forecasts
A cash flow forecast is a financial planning document that estimates all expected cash inflows and cash outflows over a future period — typically presented month by month. Unlike the profit and loss account, which is based on the accruals principle, a cash flow forecast is concerned solely with when cash is expected to move into and out of the business. It enables managers to anticipate cash shortfalls before they occur and to plan the appropriate response — whether that is arranging additional finance, accelerating debtor collection, or deferring capital expenditure.
Structure of a cash flow forecast
A standard cash flow forecast has three sections:
- Cash inflows: all expected receipts — cash from sales (or debtor collections), loans received, proceeds from asset sales, equity injected by owners. Note: sales on credit appear as inflows only in the month the customer is expected to pay, not the month of the sale.
- Cash outflows: all expected payments — supplier payments, wages, rent, loan repayments, interest, tax, capital expenditure. Sales on credit to the business appear as outflows when the invoice falls due, not when the goods arrive.
- Net cash flow and closing balance: net cash flow = total inflows minus total outflows for the month. Closing balance = opening balance plus net cash flow. The closing balance of one month becomes the opening balance of the next.
A negative closing balance indicates that the business has more cash going out than coming in plus its opening balance — it is in deficit and will need to draw on an overdraft or arrange alternative finance. This is a warning signal the forecast is specifically designed to reveal in advance.
Interpreting a cash flow forecast
When reading a cash flow forecast, four questions guide interpretation:
- Are there any months with a negative closing balance? If so, by how much, and for how long?
- What is the trend — is the cash position improving or deteriorating over the period?
- Which inflow or outflow is driving the problem — is it a one-off event (e.g. a large capital purchase) or a structural imbalance (outflows consistently exceed inflows)?
- What action can management take to address the forecast deficit — can inflows be accelerated, outflows deferred, or external finance arranged?
Northmoor Joinery Ltd is a bespoke kitchen manufacturer. The following cash flow forecast covers the six months from January to June. All figures in £000.
| Item | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Cash inflows | ||||||
| Cash sales receipts | 42 | 38 | 55 | 74 | 88 | 96 |
| Debtor collections | 31 | 29 | 27 | 40 | 58 | 71 |
| Loan received | 0 | 0 | 80 | 0 | 0 | 0 |
| Total inflows | 73 | 67 | 162 | 114 | 146 | 167 |
| Cash outflows | ||||||
| Materials and supplies | 28 | 24 | 31 | 42 | 54 | 62 |
| Wages and salaries | 35 | 35 | 35 | 35 | 38 | 38 |
| Rent and overheads | 12 | 12 | 12 | 12 | 12 | 12 |
| Capital expenditure | 0 | 0 | 95 | 0 | 0 | 0 |
| Loan repayment | 0 | 0 | 0 | 8 | 8 | 8 |
| Total outflows | 75 | 71 | 173 | 97 | 112 | 120 |
| Net cash flow | (2) | (4) | (11) | 17 | 34 | 47 |
| Opening balance | 8 | 6 | 2 | (9) | 8 | 42 |
| Closing balance | 6 | 2 | (9) | 8 | 42 | 89 |
Key calculations:
[ ext{March net cash flow} = £162{,}000 - £173{,}000 = -£11{,}000 ] [ ext{March closing balance} = £2{,}000 + (-£11{,}000) = -£9{,}000 ] [ ext{April opening balance} = ext{March closing balance} = -£9{,}000 ] [ ext{April closing balance} = -£9{,}000 + £17{,}000 = £8{,}000 ]Interpretation: The forecast reveals a negative closing balance of £9,000 in March — a deficit of £9,000. The primary cause is a £95,000 capital expenditure (new machinery) partly offset by a £80,000 loan in the same month. The deficit is temporary: April returns to positive territory (£8,000) as trading inflows recover and no further capital expenditure occurs. By June the closing balance has grown to £89,000, indicating a strengthening cash position over the period.
Management action: The March deficit requires either a pre-arranged overdraft facility of at least £9,000, or a rescheduling of the capital expenditure to April when the cash position can support it. The latter would be preferable as it avoids overdraft interest — the forecast gives management the advance notice needed to make this decision without crisis.
Limitations of cash flow forecasts
Cash flow forecasts are only as reliable as the assumptions on which they are based. Key limitations include:
- Forecast accuracy: sales volumes, debtor payment timing, and the cost of materials are all estimates. If customers pay later than forecast, or a major order is cancelled, the actual cash position will differ from the forecast, potentially turning a forecast surplus into a deficit.
- External unpredictability: economic shocks, exchange rate movements, supplier price changes, and competitor actions cannot be reliably foreseen and are rarely captured in a standard forecast.
- Management bias: forecasts prepared to support a loan application may be optimistic; those prepared internally may reflect assumptions shaped by prior expectations rather than objective analysis.
- Short time horizon: a six-month forecast loses reliability quickly as it extends further into the future. Events in months five and six are inherently more uncertain than those in month one.
Key Takeaways
- A cash flow forecast estimates expected cash inflows and outflows month by month; it is a planning tool, not an accounting statement.
- Net cash flow = total inflows minus total outflows; closing balance = opening balance plus net cash flow; closing balance becomes next month's opening balance.
- A negative closing balance signals a forecast cash deficit requiring management action — arranging finance, accelerating inflows, or deferring outflows.
- Interpretation requires understanding whether a deficit is temporary (one-off capital expenditure) or structural (outflows consistently exceed inflows).
- Limitations include forecast inaccuracy, external unpredictability, management bias, and declining reliability over longer time horizons.