Using Cash-flow Forecasts (CIE IGCSE Business)

• Cash is the 'blood' of a business, as without it, a business will die
  • It is a liquid asset in the form of notes, coins and money in the bank
     
• A profitable business is likely to fail if it does not have sufficient cash
  • Cash-poor businesses will struggle to pay suppliers, employees and operating expenses
  • This is called insolvency 
    • E.g. Lifestyle retailer Joules announced plans to liquidate in December 2022 as a result of cash-flow difficulties despite making a profit of £2.6 million during the previous year

• A cash-flow forecast is a prediction of the anticipated cash inflows and  cash outflows typically for a three, six or twelve month period
  
  • Typical outflows include payments for raw materials, paying staff wages and salaries, paying bills such as electricity and  repaying loans 
    
  • Typical inflows include receipts from sales, money received from a new bank loan, money from the sale of an asset and money from investors
    
    

Diagram: Example of a Six-month Cash-flow Forecast

The six month cash-flow forecast clearly shows how inflows and outflows of cash into a business are accounted for

Steps in constructing a cash-flow forecast

• The business starts with an opening balance of £500 in January
• Total inflows for January are £8,600
• Total outflows are expected to be £4,770
• The Net Cash-flow is expected to be £3,830 (£8,600 - £4,770)
• January’s closing balance is expected to be £4,330 (£500 + £3,830)
• Each closing balance becomes the opening balance for the next month
  • As the closing balance for January is £4,330, the opening balance for February is therefore £4,330
    
    
•  The calculation process starts again in February, and every month onwards 
  • Net cash flow + opening balance = closing balance 
     
• Overall, despite negative net cash flow between February and May, this businesses closing balance is expected to remain positive during the period, suggesting it does not expect to suffer cash flow problems
    

The importance of cash-flow forecasts

• By analysing cash flow over time, businesses can better plan and allocate financial resources
  • E.g. Problematic months can be identified early and sources of additional finance put in place to ease the cash-flow
    
    
• Cash flow forecasts are useful in the following situations
  • Starting up a business: identifying how much cash is needed in the first few months
  • Running an existing business: recognising where a fall in sales may require use of an overdraft facility
  • Supporting applications for borrowing: determining the size of loan or overdraft needed, when and for how long it is needed and by when it is likely to be fully repaid
  • Managing transactions: identifying how much or how little cash is deposited at the bank can determine when bills should be paid

• It is important for a business to know how to calculate and interpret a cash-flow forecast

An Example of a Start-up 3 Month Cash Flow Forecast (£s)

Cash-flow forecast analysis

Executive Summary

• Overall, this cash flow forecast supports a decision for the business to arrange an overdraft facility with their bank
• As sales increase in January and February, inflows are greater than outflows, and the business has a positive cash flow
• This changes in March as the level of sales falls and the net cash flow turns negative
• An overdraft facility will help them survive if their closing balance drops below zero in the next month or two

January

• The opening balance of £500 has been introduced by the owner
• The business is expected to achieve sales of £4,600
• Total outflows are expected to be £4,540
• The Net Cash Flow is expected to be £60 (£4,600 - £4,540)
• January’s closing balance is expected to be £560 (£60 + £500)

February

• The closing balance from January becomes the opening balance for February
• Sales of £5,100 are expected to be the business total inflows 
• Total outflows are expected to be £3,890
• The net cash flow is expected to be £1,210 (£5,100 - £3,890) 
• The closing balance is expected to be £1,770 (£1,210 + £560) 

March

• The closing balance from February becomes the opening balance for March
• The business expects to achieve sales of £3,100 as its total inflows 
• Total outflows are expected to be £3,940
• The net cash flow is expected to be -£840 (£3,100 - £3,940) 
• The closing balance is expected to be £930 (-£840 + £1,770)