Financial Laboratory · Cash and budgets
Cash flow forecast
Will the business have enough cash at the end of each month?
- IB 3.7 Cash flow
- SL and HL
- Layout of the guide’s financial statements
- Simulated data Example: Emberly Roasters, fictional
The layout of the guide’s cash flow forecast (figure 10, p. 63), with negative figures in brackets. The formula sheet gives no cash flow formulas; these follow from the layout.
The calculator
Example figures: Emberly Roasters, a fictional business. Simulated data.
The calculator could not start. The worked example below uses the example figures.
The figures
- Months
- 6, from January
- Opening balance
- $8,400.00
- Overdraft limit
- $20,000.00
- Inflow lines
- Cash sales: online and shop; Receipts from cafés (30 days’ credit)
- Outflow lines
- Green beans; Packaging; Wages and salaries; Rent and roaster lease; Energy; Delivery; Marketing; Loan repayments; Tax on 2025 profit; New grinder
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.
Result
These results are for the last complete figures. Correct the figure marked in the inputs to update them.
Lowest closing balance
−$25,700.00
March; beyond the overdraft limit
- Closing balance at the end
- −$13,200.00June
- Months overdrawn
- 6of 6
- Months beyond the overdraft limit
- 2Mar, Apr
- Net cash flow over the period
- −$21,600.00
- Total cash inflows
- $474,000.00
- Total cash outflows
- $495,600.00
The forecast
| All figures in $ | January | February | March | April | May | June |
|---|---|---|---|---|---|---|
| Opening balance | 8,400.00 | (6,200.00) | (14,000.00) | (25,700.00) | (24,200.00) | (19,800.00) |
| Cash inflows | ||||||
| Cash sales: online and shop | 20,500.00 | 19,500.00 | 23,000.00 | 24,500.00 | 26,000.00 | 27,500.00 |
| Receipts from cafés (30 days’ credit) | 63,000.00 | 46,000.00 | 50,500.00 | 55,000.00 | 58,000.00 | 60,500.00 |
| Total cash inflows | 83,500.00 | 65,500.00 | 73,500.00 | 79,500.00 | 84,000.00 | 88,000.00 |
| Cash outflows | ||||||
| Green beans | 36,000.00 | 31,500.00 | 34,000.00 | 35,500.00 | 37,000.00 | 38,500.00 |
| Packaging | 3,600.00 | 3,200.00 | 3,400.00 | 3,600.00 | 3,700.00 | 3,900.00 |
| Wages and salaries | 18,500.00 | 18,500.00 | 18,500.00 | 18,500.00 | 18,500.00 | 18,500.00 |
| Rent and roaster lease | 7,000.00 | 7,000.00 | 7,000.00 | 7,000.00 | 7,000.00 | 7,000.00 |
| Energy | 2,500.00 | 2,400.00 | 2,200.00 | 2,000.00 | 1,800.00 | 1,700.00 |
| Delivery | 5,200.00 | 4,300.00 | 4,700.00 | 5,000.00 | 5,200.00 | 5,400.00 |
| Marketing | 2,800.00 | 2,800.00 | 2,800.00 | 2,800.00 | 2,800.00 | 2,800.00 |
| Loan repayments | 3,600.00 | 3,600.00 | 3,600.00 | 3,600.00 | 3,600.00 | 3,600.00 |
| Tax on 2025 profit | 18,900.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| New grinder | 0.00 | 0.00 | 9,000.00 | 0.00 | 0.00 | 0.00 |
| Total cash outflows | 98,100.00 | 73,300.00 | 85,200.00 | 78,000.00 | 79,600.00 | 81,400.00 |
| Net cash flow | (14,600.00) | (7,800.00) | (11,700.00) | 1,500.00 | 4,400.00 | 6,600.00 |
| Closing balance | (6,200.00) | (14,000.00) | (25,700.00) | (24,200.00) | (19,800.00) | (13,200.00) |
| Against the overdraft limit of 20,000 | Overdrawn, within the limit | Overdrawn, within the limit | Beyond the overdraft limit | Beyond the overdraft limit | Overdrawn, within the limit | Overdrawn, within the limit |
Section 01: The formula and the working
Each formula in the guide’s words, then the working with the figures above, step by step.
Net cash flow = total cash inflows − total cash outflows
Closing balance = opening balance + net cash flow
Opening balance = the previous month’s closing balance
The first month: January’s closing balance
- Given
- Opening balance, January: $8,400.00
- Total cash inflows: $83,500.00
- Total cash outflows: $98,100.00
- Formula
- Net cash flow = total cash inflows − total cash outflows; closing balance = opening balance + net cash flow
- Substitution
- Net cash flow = $83,500.00 − $98,100.00; closing balance = $8,400.00 + (−$14,600.00)
- Working
- $83,500.00 − $98,100.00 = −$14,600.00$8,400.00 + (−$14,600.00) = −$6,200.00
- Answer
- $(6,200.00)
Negative figures are shown in brackets, as in the guide’s cash flow forecast.
- Unit
- $ in the bank at the end of January
- Interpretation
- At the end of January the account is overdrawn by $6,200.00, within the $20,000.00 limit.
- Business implication
- The business pays overdraft interest and has little room if sales fall short of the forecast.
The critical month: March’s closing balance
- Given
- Opening balance, March: −$14,000.00
- Total cash inflows: $73,500.00
- Total cash outflows: $85,200.00
- Formula
- Net cash flow = total cash inflows − total cash outflows; closing balance = opening balance + net cash flow
- Substitution
- Net cash flow = $73,500.00 − $85,200.00; closing balance = −$14,000.00 + (−$11,700.00)
- Working
- $73,500.00 − $85,200.00 = −$11,700.00−$14,000.00 + (−$11,700.00) = −$25,700.00
- Answer
- $(25,700.00)
Negative figures are shown in brackets, as in the guide’s cash flow forecast.
- Unit
- $ in the bank at the end of March
- Interpretation
- At the end of March the account is overdrawn by $25,700.00, which is $5,700.00 beyond the $20,000.00 limit.
- Business implication
- The bank need not honour payments beyond the limit: wages, rent or the supplier could go unpaid even though the business is profitable.
Section 02: The chart
Drawn from the figures above, with every value also in a table.
The chart’s figures as a table
| Month | Opening balance | Net cash flow | Closing balance | Position |
|---|---|---|---|---|
| January | 8,400.00 | (14,600.00) | (6,200.00) | Overdrawn, within the limit |
| February | (6,200.00) | (7,800.00) | (14,000.00) | Overdrawn, within the limit |
| March | (14,000.00) | (11,700.00) | (25,700.00) | Beyond the overdraft limit |
| April | (25,700.00) | 1,500.00 | (24,200.00) | Beyond the overdraft limit |
| May | (24,200.00) | 4,400.00 | (19,800.00) | Overdrawn, within the limit |
| June | (19,800.00) | 6,600.00 | (13,200.00) | Overdrawn, within the limit |
Section 03: If cash inflows fall short
The forecast again with every inflow scaled up or down, and the outflows as entered: a simple stress test.
| Inflows | Lowest balance | In | Months beyond the limit | Final balance |
|---|---|---|---|---|
| Inflows −20% | −$108,000.00 | June | 6 | −$108,000.00 |
| Inflows −10% | −$60,600.00 | June | 5 | −$60,600.00 |
| Inflows −5% | −$39,300.00 | April | 5 | −$36,900.00 |
| As forecast (the figures as entered) | −$25,700.00 | March | 2 | −$13,200.00 |
| Inflows +5% | −$14,575.00 | March | 0 | $10,500.00 |
| Inflows +10% | −$3,450.00 | March | 0 | $34,200.00 |
Reading. If cash inflows came in 10% below the forecast, the lowest balance would be −$60,600.00 in June, beyond the limit in 5 months. Sales receipts are usually the least certain line in a forecast, so this is the test that matters most.
Section 04: What it means
For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.
What the number means
The balance goes beyond the $20,000 overdraft limit in March, and is beyond it in 2 of the 6 months. The lowest closing balance is −$25,700.00 in March. The bank would not honour payments past the limit, so the forecast needs a change before March.
What to compare it with
Compare the forecast with the actual figures as each month passes: the gap is the earliest warning. Compare the lowest balance with the overdraft limit and with the largest single payment, here green beans at up to $38,500.00: a business needs a margin for error, not just a balance above zero. And compare the net cash flow with profit: a profitable business can still run short of cash.
Why benchmarks vary
How much cash is enough depends on the business. One with steady daily cash sales needs a smaller buffer than one paid in a few large, late invoices, or one whose trade is seasonal. A forecast is only as good as its estimates, especially of sales and of when customers pay, and the further ahead it looks the less reliable it becomes, so it is updated as the actual figures arrive.
What a manager might do
Options for a manager, not IB requirements; each has a cost or a risk to weigh.
- Act before March: agree a larger overdraft or a short-term loan in advance, because the bank need not honour payments beyond the limit.
- Move or spread a large one-off payment: delay a purchase to a stronger month, lease or rent instead of buying, or pay a bill in instalments.
- Bring cash in sooner: invoice promptly, chase late payers, shorten credit terms or offer a small discount for prompt payment.
- Pay out later where it costs nothing: ask suppliers for longer credit, without damaging the relationship.
- Fit the fix to the cause: an overdraft suits a short or seasonal gap, but a business losing money every month needs to improve its profit, not just its cash.
Section 05: Learn more
- Notes 3.7 Cash flow The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- Practice Closing balance in a cash flow forecast, a practice question Fresh fictional figures, checked as you answer, with the working and the usual slips. Paper 2 style, the platform’s own.
- On a case Cash flow lab (Atelier Barro) The same idea worked on a fictional case at the Finance Desk.
- Register Closing balance, worked on a case The calculation in eight parts, with the errors that cost marks.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/cash-flow-forecast/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.