Worked example · Business · Year 11

Fixing a cashflow forecast for a surf school

LNF: Numeracy → Understanding the number system helps us to represent and compare relationships between numbers and quantities → Financial literacy

What this is

A secure Year 11 response, annotated so you can see which success criterion each part meets. It is also the answer key. Key figures: closing balances −50, −150, −4,050, −2,950, −250, 3,900; the overdraft limit is broken in March (by £2,050) and April (by £950). Lowest balance: no change −£4,050; Improvement 1 only −£3,180; Improvement 2 only −£1,750; both −£990. This practises GCSE Business Unit 3, section 3.3.3 Cashflow and cashflow forecasts.

Step 2: the completed forecast

£JanFebMarAprMayJun
Total inflows5007501,5004,5006,7509,000
Total outflows2,0508505,4003,4004,0504,850
Net cashflow−1,550−100−3,9001,1002,7004,150
Opening balance1,500−50−150−4,050−2,950−250
Closing balance−50−150−4,050−2,950−2503,900

March working: outflows 450 + 800 + 3,600 + 0 + 300 + 250 = 5,400. Net 1,500 − 5,400 = −3,900. Closing −150 + (−3,900) = −4,050.

April working: outflows 450 + 2,400 + 0 + 0 + 300 + 250 = 3,400. Net 4,500 − 3,400 = 1,100. Closing −4,050 + 1,100 = −2,950.

Every opening balance is the closing balance of the month before, and the negative numbers are added correctly. Check: June closing balance £3,900, as the cover teacher’s note says. Evidences criteria 1 and 2.

Step 3: reading the forecast

(a) The closing balance is below zero in January, February, March, April and May: 5 of the 6 months.

(b) March (−4,050) and April (−2,950). The worst month is March, which is £2,050 below the −£2,000 limit, because 4,050 − 2,000 = 2,050.

(c) No. The business ends June with £3,900, but in March and April it would go past its overdraft limit, so payments such as wages would bounce before the summer money arrives. A business can be profitable over the year and still fail because it runs out of cash at the wrong time.

The answer to (c) explains the difference between having money eventually and having cash when bills are due, which is the whole point of a cashflow forecast. Evidences criterion 2.

Step 4: Owen’s errors

 Where is the error?What rule did Owen break?Correct figure
1February opening balance: 1,500The opening balance must be the closing balance of the month before. He copied January’s opening balance instead.−50 (so February closing is −150)
2March net cashflow: 3,900Net cashflow is inflows minus outflows. He did outflows minus inflows, so the sign is wrong.−3,900 (so March closing is −4,050)

Both errors are found, the rule is stated and the knock-on effect on the closing balance is corrected. Owen’s draft made March look like £5,300 in the bank when it would really be −£4,050: a difference of £9,350. Evidences criterion 3.

Step 5: testing the improvements

(a) Each instalment is 3,600 ÷ 3 = £1,200.

Improvement 2 only (£)JanFebMarAprMayJun
New total outflows2,0508503,0004,6005,2504,850
New net cashflow−1,550−100−1,500−1001,5004,150
New closing balance−50−150−1,650−1,750−2503,900

March outflows: 5,400 − 3,600 + 1,200 = 3,000. April: 3,400 + 1,200 = 4,600. May: 4,050 + 1,200 = 5,250.

(b)

Both improvements (£)JanFebMarAprMayJun
New total outflows9609603,1104,7105,3604,960
New net cashflow−460−210−1,610−2101,3904,040
New closing balance1,040830−780−9904004,440

January outflows: 2,050 − 1,200 + 110 = 960. Every other month is the Improvement 2 figure + 110.

(c)

 Lowest closing balanceMonthInside the £2,000 overdraft?
No change−4,050MarchNo
Improvement 1 only−3,180MarchNo
Improvement 2 only−1,750AprilYes, by only £250
Both improvements−990AprilYes, by £1,010

Only the changed outflows are recalculated, and the pupil notices that the worst month moves from March to April. The June balance is £540 higher with both improvements only because 6 months of insurance at £110 (£660) is less than £1,200 so far: the other £660 is still to pay later in the year. Evidences criterion 4.

Step 6: recommendation

Owen should use both improvements. With no changes, his balance falls to −£4,050 in March, which is £2,050 past his overdraft limit, so his bills would bounce. Paying the supplier in 3 instalments of £1,200 is the most important change, because on its own it keeps the lowest balance at −£1,750. However, that leaves only £250 of overdraft to spare, so one wet week in April could push him over the limit. Paying insurance monthly as well raises the lowest balance to −£990, which gives him £1,010 of safety. The drawback is that monthly insurance costs £1,320 a year instead of £1,200, so he pays £120 more. He will also still be overdrawn in March and April and will pay interest. I think the extra £120 is worth it to avoid running out of cash.

135 words. A clear recommendation, five figures from the forecasts, a reason for choosing both instead of just one, and a drawback with a figure. Evidences criterion 5.

If you finish early: answers

Total inflows 500 + 750 + 1,500 + 4,500 + 6,750 + 9,000 = £23,000. Total outflows 2,050 + 850 + 5,400 + 3,400 + 4,050 + 4,850 = £20,600. 23,000 − 20,600 = 2,400, and 1,500 + 2,400 = £3,900, the June closing balance.

Insurance: 1,320 − 1,200 = 120, and 120 ÷ 1,200 × 100 = 10% more.

Other ideas: take a deposit when summer lessons are booked (increases lesson inflows in March), cut March advertising from £300 (reduces outflows), or start instructors later in March (reduces wages).

Why this response is secure