Cover lesson · Business · Year 11 · Advanced
LNF: Numeracy → Understanding the number system helps us to represent and compare relationships between numbers and quantities → Financial literacy
Name: Class: Date:
What this practises: GCSE Business (Made for Wales) Unit 3, section 3.3.3 Cashflow and cashflow forecasts: “calculate and interpret a cashflow forecast” and “recommend improvements to cashflow”. Pupils complete a 6-month forecast with negative numbers, find two errors in a draft, test two improvements and write a recommendation using their figures. This is a numeracy lesson: money calculations, negative balances and a written sentence on what the numbers mean.
Print: this sheet, one per pupil, and the stimulus sheet “Tonnau Surf School: the cashflow pack”, one between two. Pupils need a calculator. No computers are needed. The figures are also in tonnau-surf-cashflow.csv if you are in a computer room.
Run: 5 min read the pack in pairs · 14 min Step 2, complete the forecast · 7 min Step 3, read the forecast · 6 min Step 4, Owen’s errors · 13 min Step 5, test the improvements · 10 min Step 6, write the recommendation alone. Total 55 minutes.
Collect: this sheet. A check you can make: the June closing balance in Step 2 should be £3,900. If a pupil has a different number, ask them to check that each opening balance is the closing balance of the month before.
Owen runs a surf school. He makes most of his money in summer, but he has to pay bills all year. A cashflow forecast shows whether he will have enough cash in the bank each month. You are going to finish his forecast, find the months where he runs out of cash, check his own draft for mistakes, and test two ways to fix the problem.
Negative numbers: a negative balance means the account is overdrawn. Write it with a minus sign, for example −50. Take care: −50 + (−100) = −150, and −150 + 1,100 = 950.
Read sections 1 to 5 with your partner. Underline the opening balance and the overdraft limit. Circle the two months where the biggest bills are paid.
January is done for you as an example. Complete February to June. Work down each column: totals, then net cashflow, then balances. The opening balance for February is January’s closing balance.
| £ | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| Surf lessons | 400 | 600 | 1,200 | 3,600 | 5,400 | 7,200 |
| Board and wetsuit hire | 100 | 150 | 300 | 900 | 1,350 | 1,800 |
| Total inflows | 500 | |||||
| Rent | 450 | 450 | 450 | 450 | 450 | 450 |
| Wages | 0 | 0 | 800 | 2,400 | 3,200 | 4,000 |
| New wetsuits and boards | 0 | 0 | 3,600 | 0 | 0 | 0 |
| Insurance | 1,200 | 0 | 0 | 0 | 0 | 0 |
| Advertising | 150 | 150 | 300 | 300 | 150 | 150 |
| Van loan | 250 | 250 | 250 | 250 | 250 | 250 |
| Total outflows | 2,050 | |||||
| Net cashflow | −1,550 | |||||
| Opening balance | 1,500 | |||||
| Closing balance | −50 |
January working: inflows 400 + 100 = 500. Outflows 450 + 0 + 0 + 1,200 + 150 + 250 = 2,050. Net cashflow 500 − 2,050 = −1,550. Closing balance 1,500 + (−1,550) = −50.
(a) In which months is the closing balance below zero?
(b) In which months does the balance go below the overdraft limit of −£2,000? By how much in the worst month?
(c) The June closing balance is positive. Does that mean Owen has no problem? Explain in 2 sentences.
Owen started the forecast himself. His January column is correct, but he made 2 errors in February and March. Find each error, say what the rule should be, and write the correct figure.
| Owen’s draft (£) | Jan | Feb | Mar |
|---|---|---|---|
| Total inflows | 500 | 750 | 1,500 |
| Total outflows | 2,050 | 850 | 5,400 |
| Net cashflow | −1,550 | −100 | 3,900 |
| Opening balance | 1,500 | 1,500 | 1,400 |
| Closing balance | −50 | 1,400 | 5,300 |
| Where is the error? | What rule did Owen break? | Correct figure | |
|---|---|---|---|
| 1 | |||
| 2 |
Look at section 4 of the pack. Only the outflows change; the inflows stay the same.
(a) Improvement 2 only. The £3,600 is paid as 3 instalments. How much is each instalment? Now fill in the new figures. Insurance is still £1,200 in January.
| £ | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| New total outflows | 2,050 | 850 | 4,850 | |||
| New net cashflow | −1,550 | −100 | 4,150 | |||
| New closing balance | −50 | −150 |
(b) Both improvements. Insurance is now £110 every month and the kit is paid in 3 instalments.
| £ | Jan | Feb | Mar | Apr | May | Jun |
|---|---|---|---|---|---|---|
| New total outflows | ||||||
| New net cashflow | ||||||
| New closing balance |
(c) Owen’s accountant tested Improvement 1 only. The lowest closing balance was −£3,180 in March. Fill in the summary.
| Lowest closing balance | Month | Inside the £2,000 overdraft? | |
|---|---|---|---|
| No change | |||
| Improvement 1 only | −3,180 | March | |
| Improvement 2 only | |||
| Both improvements |
On your own. Write a recommendation to Owen in 100 to 150 words. Say which improvement or improvements he should use, and use at least 3 figures from your forecasts. Include one drawback, for example the total cost of paying insurance monthly.