Cover lesson · Business · Year 11 · Advanced

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

Name: Class: Date:

Cover teacher: you need no subject knowledge

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.

What you are doing

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.

Step 1: read the pack

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.

Step 2: complete the forecast

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.

£JanFebMarAprMayJun
Surf lessons4006001,2003,6005,4007,200
Board and wetsuit hire1001503009001,3501,800
Total inflows500
Rent450450450450450450
Wages008002,4003,2004,000
New wetsuits and boards003,600000
Insurance1,20000000
Advertising150150300300150150
Van loan250250250250250250
Total outflows2,050
Net cashflow−1,550
Opening balance1,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.

Step 3: read the forecast

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

Step 4: Owen’s errors

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 (£)JanFebMar
Total inflows5007501,500
Total outflows2,0508505,400
Net cashflow−1,550−1003,900
Opening balance1,5001,5001,400
Closing balance−501,4005,300
 Where is the error?What rule did Owen break?Correct figure
1
2

Step 5: test the improvements

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.

£JanFebMarAprMayJun
New total outflows2,0508504,850
New net cashflow−1,550−1004,150
New closing balance−50−150

(b) Both improvements. Insurance is now £110 every month and the kit is paid in 3 instalments.

£JanFebMarAprMayJun
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 balanceMonthInside the £2,000 overdraft?
No change
Improvement 1 only−3,180March
Improvement 2 only
Both improvements

Step 6: advise Owen

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.

Step by step

  1. 5 min Read the pack. Underline the opening balance and the overdraft limit.
  2. 14 min Complete the forecast from February to June.
  3. 7 min Find the months with a cash problem.
  4. 6 min Find and correct Owen’s 2 errors.
  5. 13 min Test the improvements and fill in the summary.
  6. 10 min Write your recommendation on your own.

Success criteria

If you finish early