Worked example · Business · Year 11
LNF: Numeracy → Understanding the number system helps us to represent and compare relationships between numbers and quantities → Financial literacy
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.
| £ | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Total inflows | 500 | 750 | 1,500 | 4,500 | 6,750 | 9,000 |
| Total outflows | 2,050 | 850 | 5,400 | 3,400 | 4,050 | 4,850 |
| Net cashflow | −1,550 | −100 | −3,900 | 1,100 | 2,700 | 4,150 |
| Opening balance | 1,500 | −50 | −150 | −4,050 | −2,950 | −250 |
| Closing balance | −50 | −150 | −4,050 | −2,950 | −250 | 3,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.
(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.
| Where is the error? | What rule did Owen break? | Correct figure | |
|---|---|---|---|
| 1 | February opening balance: 1,500 | The opening balance must be the closing balance of the month before. He copied January’s opening balance instead. | −50 (so February closing is −150) |
| 2 | March net cashflow: 3,900 | Net 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.
(a) Each instalment is 3,600 ÷ 3 = £1,200.
| Improvement 2 only (£) | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| New total outflows | 2,050 | 850 | 3,000 | 4,600 | 5,250 | 4,850 |
| New net cashflow | −1,550 | −100 | −1,500 | −100 | 1,500 | 4,150 |
| New closing balance | −50 | −150 | −1,650 | −1,750 | −250 | 3,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 (£) | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| New total outflows | 960 | 960 | 3,110 | 4,710 | 5,360 | 4,960 |
| New net cashflow | −460 | −210 | −1,610 | −210 | 1,390 | 4,040 |
| New closing balance | 1,040 | 830 | −780 | −990 | 400 | 4,440 |
January outflows: 2,050 − 1,200 + 110 = 960. Every other month is the Improvement 2 figure + 110.
(c)
| Lowest closing balance | Month | Inside the £2,000 overdraft? | |
|---|---|---|---|
| No change | −4,050 | March | No |
| Improvement 1 only | −3,180 | March | No |
| Improvement 2 only | −1,750 | April | Yes, by only £250 |
| Both improvements | −990 | April | Yes, 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.
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.
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).