Skip to the worksheet
Revision Library
Choose a subject

Cash-flow forecasting - Worksheets, Questions and Revision

13 original exam-style questions - 6 pages of questions with a full mark scheme - free printable PDF.

Grades 4-7

This topic is chapter 4 of GCSE Business Topic Workbook 3.

Revision Library
revisionlibrary.co.uk
GCSE · Finance

3.4 Cash-flow forecasting

AQA 8132 · Calculator allowed · about 60 minutes
Total Marks
Name: _______________________________    Date: ____ / ____ / ______
Answer ALL questions in the spaces provided. Show your working for every calculation: method marks are available even if your final answer is wrong. Bright Spark Electricals, used throughout this pack, is a fictional business.
1
Which one of the following is a cash OUTFLOW for Bright Spark Electricals?
  • A) A £2,000 bank loan received from Bright Spark Electricals' bank
  • B) Money paid in by Kofi as extra capital
  • C) Cash paid to a supplier for new stock of electrical goods
  • D) Cash received from a cash sale to a customer
(Total for Question 1 is 1 mark)
2
Define two terms used in a cash-flow forecast.
(a)State what is meant by the term 'net cash flow' in a cash-flow forecast.(1)
(b)State what is meant by the term 'closing balance' in a cash-flow forecast.(1)
(Total for Question 2 is 2 marks)
3
Other than negotiating supplier payment terms, state two other methods Bright Spark Electricals could use to improve its cash-flow position.
(Total for Question 3 is 2 marks)
4
Which one of the following is true of cash flow but NOT necessarily true of profit?
  • A) It is calculated over a trading period such as a year
  • B) It only counts money that has actually been received or paid out
  • C) It can include sales made on credit that have not yet been paid for
  • D) It is shown on a statement of comprehensive income
(Total for Question 4 is 1 mark)
5
Explain one action Kofi, the owner of Bright Spark Electricals, could take in January or February to try to avoid the business's cash balance falling below its £2,000 target in February.
(Total for Question 5 is 3 marks)
6
Bright Spark Electricals' statement of financial position shows current assets (cash, inventory and trade receivables) of £9,400 and current liabilities (trade payables and an overdraft) of £5,600.
(a)Calculate Bright Spark Electricals' working capital. Show your working.(2)
(b)State what a positive working capital figure, as calculated in part a, tells us about Bright Spark Electricals' short-term liquidity.(2)
(Total for Question 6 is 4 marks)
7
Bright Spark Electricals' April closing balance is £2,700 (question 10). In May it forecasts cash inflows of £8,900 and cash outflows of £7,650.
Calculate Bright Spark Electricals' net cash flow and closing balance for May. Show your working.
(Total for Question 7 is 4 marks)
8
Which one of the following best describes 'overtrading'?
  • A) A business trading too rarely to survive
  • B) A business expanding its sales too quickly without enough cash/finance to support the growth
  • C) A business that only ever trades using cash, never credit
  • D) A business that consistently makes a loss every year
(Total for Question 8 is 1 mark)
9
Bright Spark Electricals, a fictional electrical retailer, forecasts the following cash inflows and outflows for its first four months of trading.
MonthOpening balance (pounds)Total cash inflows (pounds)Total cash outflows (pounds)Net cash flow (pounds)Closing balance (pounds)
January1,5007,0006,300(a)(b)
February(c)6,2007,000(d)(e)
March(f)8,5006,900(g)(h)
Calculate the value of each missing figure, (a) to (h). Show your working.
(a)Calculate the missing net cash flow for January.(1)
(b)Calculate the missing closing balance for January.(1)
(c)Calculate the missing opening balance for February.(1)
(d)Calculate the missing net cash flow for February.(1)
(e)Calculate the missing closing balance for February.(1)
(f)Calculate the missing opening balance for March.(1)
(g)Calculate the missing net cash flow for March.(1)
(h)Calculate the missing closing balance for March.(1)
(Total for Question 9 is 8 marks)
10
Bright Spark Electricals' April opening balance is £3,000 (March's closing balance, question 9h). In April it forecasts cash inflows of £7,800 and cash outflows of £8,100.
Calculate Bright Spark Electricals' closing balance for April. Show your working.
(Total for Question 10 is 3 marks)
11
Bright Spark Electricals wants to maintain a minimum closing cash balance of £2,000 each month as a safety buffer. Using your answers to question 9, state which month's closing balance falls below this £2,000 target, and calculate by how much. Show your working.
(Total for Question 11 is 3 marks)
12
Bright Spark Electricals' cash-flow forecast (questions 9-10) shows its closing balance dips below its £2,000 target in February, falling to £1,400, a shortfall of £600 (question 11), even though the business has positive working capital of £3,800 (question 6a) and a positive net cash flow in two of the four months.
Recommend what Kofi should do about the February shortfall. Justify your answer using the figures given in this pack.
(Total for Question 12 is 9 marks)
13
Bright Spark Electricals is considering offering credit customers a 2% discount for paying their invoice within 7 days instead of the usual 30-day credit terms. Analyse the likely impact of this change on Bright Spark Electricals' cash-flow forecast.
(Total for Question 13 is 6 marks)
Mark scheme · 3.4 Cash-flow forecasting

Question 1

  • C caoB1
  • Answer: C

Question 2

  • (a) the difference between total cash inflows and total cash outflows in a given period (oe)B1
  • (a) Answer: The difference between total cash inflows and total cash outflows in a given period.
  • (b) the amount of cash a business has at the end of a period, found by adding the net cash flow to the opening balance (oe)B1
  • (b) Answer: The amount of cash a business has at the end of a period, found by adding net cash flow to the opening balance.

Question 3

  • offer customers a discount for early payment, or chase up overdue customer paymentsB1
  • arrange a short-term bank overdraft or loan to cover the shortfallB1
  • Answer: Any two, e.g. offer early-payment discounts/chase late payers; arrange a short-term overdraft or loan.

Question 4

  • B caoB1
  • Answer: B

Question 5

  • identifies an action, e.g. negotiate longer payment terms with a supplier for some of the outflows due in FebruaryB1
  • develops the point, e.g. this pushes some cash outflow into a later monthB1
  • links clearly to an outcome, e.g. keeping more cash available in February, helping the balance stay above the £2,000 minimum targetB1
  • Answer: Negotiate longer payment terms with a supplier so some February outflow is delayed, keeping more cash available and helping the balance stay above the £2,000 target.

Question 6

  • (a) 9,400 - 5,600 seenM1
  • (a) £3,800 caoA1
  • (a) Answer: £3,800.
  • (b) the business has enough short-term (current) assets to cover its short-term (current) liabilities/debtsB1
  • (b) this means it should, in the short term, be able to pay its bills as they fall due (good short-term liquidity)B1
  • (b) Answer: Current assets exceed current liabilities, so the business should be able to pay its short-term bills as they fall due.

Question 7

  • 8,900 - 7,650 seenM1
  • £1,250 cao (net cash flow)A1
  • 2,700 + 1,250 seen (dependent on the net cash flow above; ft from question 10's April closing balance)dM1
  • £3,950 cao (closing balance)A1
  • Answer: Net cash flow £1,250; closing balance £3,950.

Question 8

  • B caoB1
  • Answer: B

Question 9

  • (a) £700 caoB1
  • (a) Answer: £700.
  • (b) £2,200 cao (ft from part a)B1
  • (b) Answer: £2,200.
  • (c) £2,200 cao (ft from part b: a month's opening balance equals the previous month's closing balance)B1
  • (c) Answer: £2,200.
  • (d) negative £800 cao (accept '(£800)')B1
  • (d) Answer: negative £800.
  • (e) £1,400 cao (ft from parts c and d)B1
  • (e) Answer: £1,400.
  • (f) £1,400 cao (ft from part e)B1
  • (f) Answer: £1,400.
  • (g) £1,600 caoB1
  • (g) Answer: £1,600.
  • (h) £3,000 cao (ft from parts f and g)B1
  • (h) Answer: £3,000.

Question 10

  • 7,800 - 8,100 seen (= negative £300)M1
  • 3,000 + (-300) seenM1
  • £2,700 caoA1
  • Answer: £2,700.

Question 11

  • February identifiedB1
  • 2,000 - 1,400 seenM1
  • £600 caoA1
  • Answer: February, by £600.

Question 12

  • Level 1 Makes simple, undeveloped comments about the shortfall, with little or no use of the pack's figures and no clear recommendation.1-3
  • Level 2 Gives a developed argument for one option, using some of the pack's figures, but does not fully weigh both sides or reach a clearly justified recommendation.4-6
  • Level 3 Weighs the evidence for different responses to the shortfall, using the forecast and working-capital figures from this pack, and reaches a justified recommendation supported by that analysis.7-9
  • Indicative content:
    • The shortfall is relatively small (£600) and temporary, recovering strongly in March (net cash flow of £1,600, question 9g), and the business holds positive working capital of £3,800 overall, suggesting the underlying business is not in serious financial difficulty.
    • Low-cost, no-new-borrowing options such as delaying a February supplier payment (question 5) or chasing early customer payment (question 3) may be enough to close a gap of only £600 without taking on new finance or interest costs.
    • Against relying only on delaying payments: suppliers may not agree, or repeated delays could damage the relationship, so a small short-term overdraft may be a more reliable safety net for the gap.
    • A full bank loan is unnecessary and disproportionate for a temporary £600 dip that reverses within one month, given March's forecast net cash flow of £1,600.
    • Judgement: a reasonable recommendation is that Kofi arranges a small short-term overdraft facility (e.g. covering the £600 gap) as a low-cost safety net for February, while also trying to negotiate better payment timing with suppliers, rather than seeking a larger, more expensive loan for what the forecast shows is a brief, one-month dip.

Question 13

  • Level 1 Makes simple, undeveloped points about the discount, with limited application to Bright Spark Electricals and little or no reference to the pack's figures.1-3
  • Level 2 Provides a developed and applied analysis of the benefits and drawbacks of the discount for Bright Spark Electricals' cash position, referring to the pack's figures.4-6
  • Indicative content:
    • Encouraging customers to pay within 7 days would bring forward cash inflows that would otherwise arrive later in the 30-day credit period, which could help close or reduce a shortfall like the one forecast for February (question 11).
    • Faster payment reduces the risk of late or non-payment by credit customers, giving Bright Spark Electricals more reliable, predictable cash inflows to plan around.
    • The 2% discount reduces the amount of cash actually received on each discounted sale, so total cash inflows would be slightly lower than the forecast figures in questions 7 and 9 for any customer who takes up the offer.
    • Not every credit customer will take the discount, so the improvement to cash flow depends on how many customers change their payment behaviour, which is uncertain and hard to forecast precisely.
    • A balanced conclusion is likely to note that bringing cash in earlier is valuable given the February shortfall shown in this pack, but the 2% cost needs to be weighed against how reliably it changes customer payment timing, rather than assumed to fully solve the shortfall.

Mark your answers

Check answers without an account. Some answers can be checked automatically; use the mark scheme to mark the rest.

Question 1

1 mark
Choose an answer

Question 2

2 marks
Did your answer earn the marks?

Question 3

2 marks
Did your answer earn the marks?

Question 4

1 mark
Choose an answer

Question 5

3 marks
Did your answer earn the marks?

Question 6

4 marks
Did your answer earn the marks?

Question 7

4 marks
Did your answer earn the marks?

Question 8

1 mark
Choose an answer

Question 9

8 marks
Did your answer earn the marks?

Question 10

3 marks

Question 11

3 marks

Question 12

9 marks
Did your answer earn the marks?

Question 13

6 marks
Did your answer earn the marks?
Mark my answers

Worksheets are written for Revision Library and come with a full mark scheme; a few English packs quote an out-of-copyright text, and name it on the page. Exam board names and specification codes say which qualification a pack suits: we are not affiliated with, endorsed by or approved by any exam board, and no past-paper question is reproduced here. Rights queries: hello@revisionlibrary.co.uk