Financial Laboratory · Cash and budgets

Cash flow forecast

Will the business have enough cash at the end of each month?

Back to 3.7 Cash flow

  • 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.

Your forecast
Negative if the account starts overdrawn.

Inflows and outflows by month

Cash inflows and outflows by month
LineJanuaryFebruaryMarchAprilMayJuneRemove a line
Cash inflows
Cash outflows

Currency

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars.

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

Cash flow forecast, January to June. Negative figures in brackets.
All figures in $JanuaryFebruaryMarchAprilMayJune
Opening balance8,400.00(6,200.00)(14,000.00)(25,700.00)(24,200.00)(19,800.00)
Cash inflows
Cash sales: online and shop20,500.0019,500.0023,000.0024,500.0026,000.0027,500.00
Receipts from cafés (30 days’ credit)63,000.0046,000.0050,500.0055,000.0058,000.0060,500.00
Total cash inflows83,500.0065,500.0073,500.0079,500.0084,000.0088,000.00
Cash outflows
Green beans36,000.0031,500.0034,000.0035,500.0037,000.0038,500.00
Packaging3,600.003,200.003,400.003,600.003,700.003,900.00
Wages and salaries18,500.0018,500.0018,500.0018,500.0018,500.0018,500.00
Rent and roaster lease7,000.007,000.007,000.007,000.007,000.007,000.00
Energy2,500.002,400.002,200.002,000.001,800.001,700.00
Delivery5,200.004,300.004,700.005,000.005,200.005,400.00
Marketing2,800.002,800.002,800.002,800.002,800.002,800.00
Loan repayments3,600.003,600.003,600.003,600.003,600.003,600.00
Tax on 2025 profit18,900.000.000.000.000.000.00
New grinder0.000.009,000.000.000.000.00
Total cash outflows98,100.0073,300.0085,200.0078,000.0079,600.0081,400.00
Net cash flow(14,600.00)(7,800.00)(11,700.00)1,500.004,400.006,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,000Overdrawn, within the limitOverdrawn, within the limitBeyond the overdraft limitBeyond the overdraft limitOverdrawn, within the limitOverdrawn, 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.

Closing balance and net cash flow each monthJanuary: closing balance −$6,200.00, overdrawn, within the limit. February: closing balance −$14,000.00, overdrawn, within the limit. March: closing balance −$25,700.00, beyond the overdraft limit. April: closing balance −$24,200.00, beyond the overdraft limit. May: closing balance −$19,800.00, overdrawn, within the limit. June: closing balance −$13,200.00, overdrawn, within the limit. The lowest closing balance is −$25,700.00 in March. Overdraft limit $20,000.(30,000)(20,000)(10,000)010,000$, negative in bracketsJanuary: net cash flow −$14,600.00February: net cash flow −$7,800.00March: net cash flow −$11,700.00April: net cash flow $1,500.00May: net cash flow $4,400.00June: net cash flow $6,600.00Overdraft limit (20,000)January: closing balance −$6,200.00, overdrawn, within the limitJanFebruary: closing balance −$14,000.00, overdrawn, within the limitFebMarch: closing balance −$25,700.00, beyond the overdraft limitMarApril: closing balance −$24,200.00, beyond the overdraft limitAprMay: closing balance −$19,800.00, overdrawn, within the limitMayJune: closing balance −$13,200.00, overdrawn, within the limitJunLowest (25,700)(13,200)Closing balanceNet cash flow
Chart The line is the closing balance at the end of each month, the bars the net cash flow in it; the dashed line is the overdraft limit. A red dot marks a month beyond the limit.
The chart’s figures as a table
Each month’s balance
MonthOpening balanceNet cash flowClosing balancePosition
January8,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.

The forecast with inflows changed
InflowsLowest balanceInMonths beyond the limitFinal balance
Inflows −20%−$108,000.00June6−$108,000.00
Inflows −10%−$60,600.00June5−$60,600.00
Inflows −5%−$39,300.00April5−$36,900.00
As forecast (the figures as entered)−$25,700.00March2−$13,200.00
Inflows +5%−$14,575.00March0$10,500.00
Inflows +10%−$3,450.00March0$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