Cash-flow forecasting - Worksheets, Questions and Revision
13 original exam-style questions - 6 pages of questions with a full mark scheme - free printable PDF.
Cash-flow forecasting revision guideMore GCSE Business practiceMock exams
This topic is chapter 4 of GCSE Business Topic Workbook 3.
3.4 Cash-flow forecasting
- 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
- 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
Calculate Bright Spark Electricals' net cash flow and closing balance for May. Show your working.
- 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
| Month | Opening balance (pounds) | Total cash inflows (pounds) | Total cash outflows (pounds) | Net cash flow (pounds) | Closing balance (pounds) |
|---|---|---|---|---|---|
| January | 1,500 | 7,000 | 6,300 | (a) | (b) |
| February | (c) | 6,200 | 7,000 | (d) | (e) |
| March | (f) | 8,500 | 6,900 | (g) | (h) |
Calculate Bright Spark Electricals' closing balance for April. Show your working.
Recommend what Kofi should do about the February shortfall. Justify your answer using the figures given in this pack.
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.