Other Ratios (Cambridge (CIE) A Level Accounting): Revision Note

Exam code: 9706

Dan Finlay

Written by: Dan Finlay

Reviewed by: Lucy Kirkham

Updated on

Working capital cycle

What is the working capital cycle?

What is the formula?

Trade space receivables space turnover space open parentheses days close parentheses plus inventory space turnover space open parentheses days close parentheses
minus trade space payables space turnover space open parentheses days close parentheses

How should the value be written?

Write as the number of days (X days)

How should the value be rounded?

Each ratio is rounded up to the next whole day

What does the value mean?

The value represents the time it takes a business to convert its net working assets into cash

  • You need to remember the formulas for the efficiency ratios

    • Trade receivables turnover

      • fraction numerator Trade space receivables over denominator Credit space sales end fraction cross times 365

    • Inventory turnover

      • fraction numerator Average space inventory over denominator Cost space of space sales end fraction cross times 365

    • Trade payables turnover

      • fraction numerator Trade space payables over denominator Credit space purchases end fraction cross times 365

How do I interpret the value?

  • If the working capital cycle is shorter

    • The cash is tied up in assets for less time

    • This means it is more efficient and results in better liquidity

  • If the working capital cycle is longer

    • There might be a need for additional financing to fund the working capital

    • There is a greater risk of cash flow problems

  • The working capital cycle can be negative

    • For example, retail businesses sell goods for cash before paying suppliers

  • Manufacturing businesses have a higher working capital cycle because the cycle starts when the raw material is purchased

How can the working capital cycle be improved?

  • Reduce the amount of inventory that the business holds

    • However, low inventory risks lost sales if the goods are unavailable when needed by customers

  • Collect money from customers quicker

    • However, giving customers tighter credit terms could cause them to use a different supplier

  • Pay suppliers later

    • However, this could damage supplier relationships or result in late payment penalties

Worked Example

Omatola runs a small business by herself. She provides the following information for the year ended 29 February 2024.

$

Sales

40 000

Purchases

25 000

Inventory at 1 March 2023

7 000

Inventory at 29 February 2024

9 000

Trade receivables

11 000

Trade payables

4 000

All sales and purchases were made on a credit basis.

Calculate the working capital cycle at 29 February 2024. Round up your answer to the next whole day.

Answer:

  • Calculate the average inventory

    • fraction numerator Opening space inventory space plus space Closing space inventory over denominator 2 end fraction

fraction numerator $ 7 space 000 space plus space $ 9 space 000 over denominator 2 end fraction equals $ 8 space 000

  • Calculate the cost of sales

    • Opening inventory + Purchases - Closing inventory

$7 000 + $25 000 - $9 000 = $23 000

  • Calculate the required ratios

Ratio

Days

Trade receivables turnover

fraction numerator 11 space 000 over denominator 40 space 000 end fraction cross times 365 equals 100.375

101

Inventory turnover

fraction numerator 8 space 000 over denominator 23 space 000 end fraction cross times 365 equals 126.95...

127

Trade payables turnover

fraction numerator 4 space 000 over denominator 25 space 000 end fraction cross times 365 equals 58.4

59

  • Calculate the working capital cycle

    • Trade space receivables space turnover space open parentheses days close parentheses plus inventory space turnover space open parentheses days close parentheses
minus trade space payables space turnover space open parentheses days close parentheses

101 plus 127 minus 59 equals 169

169 days

Net working assets to revenue (sales)

What is the net working assets to revenue ratio?

What is the formula?

fraction numerator Net space working space assets over denominator Revenue space open parentheses sales close parentheses end fraction cross times 100

where

Net space working space assets equals inventories plus trade space receivables minus trade space payables

How should the value be written?

Write as a percentage (X%)

How should the value be rounded?

Round to two decimal places

What does the value mean?

The value represents how much working capital is needed to generate each dollar of revenue

  • The ratio measures how efficiently a business uses its net current assets (excluding cash) relative to its sales

    • A lower percentage is more efficient because less working capital is needed per dollar of revenue

    • A higher percentage suggests that more working capital is tied up relative to sales

Examiner Tips and Tricks

Actions to improve the net working assets to revenue ratio also improve the working capital cycle.

Should I use the year end or average figures?

  • The question will tell you which figures to use

  • Average figures tend to be more representative of the performance

    • Sales take place during the year, not just at the end

  • However, averages can distort the perception because changes do not take place evenly throughout the year

  • The business needs to be consistent

    • If they used the year end figures, then they should continue using year end figures in subsequent years

Worked Example

Omatola runs a small business by herself. She provides the following information for the year ended 29 February 2024.

$

Sales

40 000

Purchases

25 000

Inventory at 1 March 2023

7 000

Inventory at 29 February 2024

9 000

Trade receivables

11 000

Trade payables

4 000

All sales and purchases were made on a credit basis.

Calculate the net working assets to revenue ratio for 29 February 2024 using year end balances.

Answer:

  • Calculate the net working assets

$9 000 + $11 000 - $4 000 = $16 000

  • Calculate the net working assets to revenue ratio

    • fraction numerator Net space working space assets over denominator Revenue space open parentheses sales close parentheses end fraction cross times 100

fraction numerator 16 space 000 over denominator 40 space 000 end fraction cross times 100 equals 40 percent sign

40%

Unlock more, it's free!

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

the (exam) results speak for themselves:

Dan Finlay

Author: Dan Finlay

Expertise: Maths Subject Lead

Dan graduated from the University of Oxford with a First class degree in mathematics. As well as teaching maths for over 8 years, Dan has marked a range of exams for Edexcel, tutored students and taught A Level Accounting. Dan has a keen interest in statistics and probability and their real-life applications.

Lucy Kirkham

Reviewer: Lucy Kirkham

Expertise: Head of Content Creation

Lucy has been a passionate Maths teacher for over 12 years, teaching maths across the UK and abroad helping to engage, interest and develop confidence in the subject at all levels.Working as a Head of Department and then Director of Maths, Lucy has advised schools and academy trusts in both Scotland and the East Midlands, where her role was to support and coach teachers to improve Maths teaching for all.