The Cash Budget (SQA National 5 Business Management): Revision Note

Exam code: X810 75

Lisa Eades

Written by: Lisa Eades

Reviewed by: Steve Vorster

Updated on

Elements of a cash budget

The importance of cash

  • Cash is the 'blood' of a business, as without it, a business cannot survive

    • It is a liquid asset in the form of notes, coins and money in the bank

  • A new business may have to pay cash on purchase for all of its supplies until its suppliers trust them enough to provide credit terms (buy now, pay later)

    • A supplier may then give the business trade credit of 30 or 60 days

    • This means that the business can receive their stock now and only pay for it in 30 or 60 days; the cash outflow is delayed

    • As the business sells its products, they receive money generated from the business revenue, which represents a cash inflow

    • At the end of 60 days, they will pay their supplier (cash outflow), but the firm may still have half of its stock available for sale

  • More established businesses need to ensure that they manage cash-flow to ensure that they do not run out of money

    • Cash-flow issues may put the business in a situation where

      • It is unable to pay key stakeholders, such as workers and suppliers

      • Production is likely to cease, as workers will not work without pay and suppliers will not supply goods if they are not paid

      • It is unable to pay utility bills and rent

    • The business could be forced into liquidation and, ultimately, is likely to fail

The cash budget

  • A cash budget is a prediction of the anticipated cash inflows and outflows, usually for a six- to twelve-month period

Cash receipts and payments

  • Cash receipts include income from sales, loan sums received from the bank, interest received or capital injected into a business by owners

  • Cash payments include payments for stock, staff wages and salaries, rent and utility bills and repayments of bank loans

Examiner Tips and Tricks

You may be asked to identify an example of a cash inflow or a cash outflow from a list.

Inflows can be remembered using the acronym SLIC (Sales, Loans, Interest, Capital) while outflows can be remembered using the acronym SWURRS (Stock, Wages, Utilities, Rent, Repayments Salaries).

Opening balance

  • The opening balance is the cash position at the beginning of each month

    • In the first month, this is usually

      • Cash carried forward from any earlier trading

      • Cash introduced by the owner or from loans received

    • In later months, the opening balance is the closing balance carried forward from the previous month

Net cash

  • Net cash is the difference between cash inflows and cash outflows during a month

    • It is sometimes called net cash flow

Net cash flow formula: cash inflows minus cash outflows. Inflows include sales revenue; outflows include wages. Illustrated with coins and notes.
Net cash flow is calculated by subtracting cash outflows from cash inflows during a given period of time

Closing balance

  • The closing balance is the sum of the month's net cash and the opening balance

    • The closing balance is calculated using the formula

Closing space balance space equals space Net space cash space plus space Opening space balance

The usefulness of cash budgets

  • Cash budgets are particularly useful when

    • 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

    • Applying 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

Examiner Tips and Tricks

Students often treat the cash budget as a summary. It’s actually a planning tool, used to predict future cash shortages, not just record past figures

Interpreting a cash budget

  • A business must first gather information about all cash inflows and cash outflows it expects to encounter over the period

  • The following steps should then be taken to construct the cash budget

Step 1: Calculate total cash inflows

March

April

May

Cash inflows

Cash from sales

£4,500

£4,800

£5,300

Capital introduced

£6,000

£0

£0

Total cash inflows

£10,500

£4,800

£5,300

  • In this instance, the business expects to receive cash inflows from sales in March, April and May

  • Owners' capital of £6,000 will be introduced in March

  • The total for each month is calculated by adding cash from sales to capital introduced

Step 2: Calculate total cash outflows

March

April

May

Cash outflows

Rent

£1,400

£1,400

£1,400

Stock

£6,800

£600

£800

Wages

£2,100

£2,100

£2,100

Utilities

£460

£460

£480

Total cash outflows

£10,760

£4,560

£4,780

  • In this instance, the business expects to pay rent of £1,400 in March, April and May

  • It will purchase a significant amount of stock in March with smaller amounts in April and May

  • Wages are expected to be £2,100 in each month

  • Utilities of £460 will be paid in March and April, increasing to €480 in May

  • Total cash outflows each month is calculated by adding these together

Step 3: Calculate net cash

  • Net cash is calculated by subtracting total cash outflows from total cash inflows

March

April

May

Total cash inflows

£10,500

£4,800

£5,300

Total cash outflows

£10,760

£4,560

£4,780

Net cash

(£260)

£240

£520

  • In March net cash is £10,500 - £10,760 = £(260)

    • Net cash is negative as cash outflows are greater than cash inflows

  • In April net cash is £4,800 - £4,560 = £240

  • In May net cash is £5,300 - £4,780 = £520

    • In both months, net cash is positive as cash inflows are greater than cash outflows

Step 4: Calculate opening and closing balances

  • The opening balance is the previous month’s closing balance carried forward

  • The closing balance is calculated by adding net cash to the opening balance

March

April

May

Net cash

(£260)

£240

£520

Opening balance

£0

(£260)

(£20)

Closing balance

(£260)

(£20)

£500

  • In March the opening balance of €0 is added to the net cash of €(260) to leave a closing balance of €(260)

  • In April the closing balance from March is carried forward to become its opening balance of €(260) 

  • This opening balance is added to April's net cash of €240 to leave a closing balance of €(20)

  • In May the closing balance from April is carried forward to become its opening balance of €(20)

  • This opening balance is added to May's net cash of €520 to leave a closing balance of €500

The complete cash budget

March

April

May

Cash inflows

Cash from sales

£4,500

£4,800

£5,300

Capital introduced

£6,000

£0

£0

Total cash inflows

£10,500

£4,800

£5,300

Cash outflows

Rent

£1,400

£1,400

£1,400

Stock

£6,800

£600

£800

Wages

£2,100

£2,100

£2,100

Utilities

£460

£460

£480

Total cash outflows

£10,760

£4,560

£4,780

Net cash

(£260)

£240

£520

Opening balance

£0

(£260)

(£20)

Closing balance

(£260)

(£20)

£500

Worked Example

Here is a simple three-month cash budget for a small seaside café

 

March

April 

May

Cash inflows

Sales

46,000

54,000

61,000

Cash outflows

Inventory

13,000

13,000

13,000

Wages

28,000

28,000

 

Miscellaneous

3,500

4,000

4,000

Total cash outflows

 

45,000

48,000

Net cash

1,500

9,000

 

Opening balance

4,000

5,500

14,500

Closing balance

 

14,500

30,500

Complete the cash flow forecast to show

a. Total cash outflows for March 

b. Closing balance for March 

c. Wages for May

d. Net cash for May        

(4)

Step 1: Add all of March's cash outflows to calculate the total

Total space outflows space for space March space equals space 13 comma 000 space plus space 28 comma 000 space plus space 3 comma 500 space

equals space 44 comma 500    [1]

Step 2: Add the opening balance to the net cash flow to calculate March's closing balance

Opening space balance space plus space Net space cash space equals space Closing space balance

equals space 4 comma 000 space plus space 1 comma 500 space

equals space 5 comma 500
   [1]

Step 3: Subtract inventory and miscellaneous outflows from total cash outflows to calculate wages

Wages space for space May space equals space 48 comma 000 space minus space 13 comma 000 space minus space 4 comma 000

equals space 31 comma 000    [1]

Step 4: Subtract total cash outflows from total cash inflows to calculate net cash

Total space cash space Inflows space minus space Total space cash space outflows space equals space Net space cash

equals space 61 comma 000 space minus space 48 comma 000

equals space 13 comma 000    [1]

Unlock more, it's free!

Join the 100,000+ Students that ❤️ Save My Exams

the (exam) results speak for themselves:

Lisa Eades

Author: Lisa Eades

Expertise: Business Content Creator

Lisa has taught A Level, GCSE, BTEC and IBDP Business for over 20 years and is a senior Examiner for Edexcel. Lisa has been a successful Head of Department in Kent and has offered private Business tuition to students across the UK. Lisa loves to create imaginative and accessible resources which engage learners and build their passion for the subject.

Steve Vorster

Reviewer: Steve Vorster

Expertise: Economics & Business Subject Lead

Steve has taught A Level, GCSE, IGCSE Business and Economics - as well as IBDP Economics and Business Management. He is an IBDP Examiner and IGCSE textbook author. His students regularly achieve 90-100% in their final exams. Steve has been the Assistant Head of Sixth Form for a school in Devon, and Head of Economics at the world's largest International school in Singapore. He loves to create resources which speed up student learning and are easily accessible by all.