- Foundation
- About 22 min
- 5 practice questions
Activity (turnover) ratios
Calculate inventory, trade receivables and trade payables turnover ratios with collection and payment periods, and net assets, fixed assets and working capital turnover ratios, and interpret each.
If something looks wrong, please tell us.
By the end of this lesson you can
- Calculate inventory turnover and explain what high and low values mean.
- Calculate trade receivables and trade payables turnover and convert them into average collection and payment periods.
- Calculate net assets (capital employed), fixed assets and working capital turnover ratios.
Activity ratios measure how quickly assets are turned into sales, so they show how efficiently resources are used. They are expressed as a number of times in a year; a higher turnover usually means better use of assets, and therefore they are also called efficiency ratios. This lesson uses the Vikas Industries Ltd data from Lesson 2.
Inventory turnover ratio
Inventory turnover = Cost of revenue from operations ÷ Average inventory, where average inventory = (opening + closing) ÷ 2, and cost of revenue from operations = revenue from operations − gross profit (or opening inventory + net purchases + direct expenses − closing inventory).
Vikas Industries: average inventory = (₹1,80,000 + ₹2,40,000) ÷ 2 = ₹2,10,000; cost of revenue from operations ₹21,00,000. Inventory turnover = 10 times. A low turnover may signal bad buying or obsolete stock; a high turnover is good but must be read carefully, as it may come from buying in small lots or selling at a low margin to raise cash.
Trade receivables turnover ratio
Trade receivables turnover = Net credit revenue from operations ÷ Average trade receivables, where trade receivables = debtors + bills receivable, taken before any provision for doubtful debts. Average collection period = days (or months) in the year ÷ turnover ratio.
Vikas Industries: average receivables = (₹2,80,000 + ₹2,00,000) ÷ 2 = ₹2,40,000; credit revenue ₹24,00,000. Turnover = 10 times; average collection period = 365 ÷ 10 = 36.5 days. Higher turnover means quicker collection.
Trade payables turnover ratio
Trade payables turnover = Net credit purchases ÷ Average trade payables (creditors + bills payable). Average payment period = days in the year ÷ turnover ratio. Vikas Industries: average payables = (₹1,20,000 + ₹2,40,000) ÷ 2 = ₹1,80,000; credit purchases ₹18,00,000. Turnover = 10 times; payment period = 36.5 days. A lower ratio means a longer credit period from suppliers, or delayed payment, which can hurt the firm's reputation.
Net assets, fixed assets and working capital turnover
| Ratio | Formula | Vikas Industries Ltd (illustrative) |
|---|---|---|
| Net assets (capital employed) turnover | Revenue from operations ÷ Capital employed | 30,00,000 ÷ 15,00,000 = 2 times |
| Fixed assets turnover | Revenue from operations ÷ Net fixed assets | 30,00,000 ÷ 11,00,000 = 2.73 times |
| Working capital turnover | Revenue from operations ÷ Working capital | 30,00,000 ÷ 3,00,000 = 10 times |
Working capital = current assets − current liabilities = ₹6,00,000 − ₹3,00,000 = ₹3,00,000. High turnover of capital employed, fixed assets and working capital is a good sign of efficient use of resources.
From turnover ratio to days
- Find the average balance (Opening + Closing) ÷ 2
- Divide the flow by the average Credit sales, credit purchases or cost of revenue
- Turnover in times per year
- Days = 365 ÷ turnover Months = 12 ÷ turnover
Inventory turnover = Cost of revenue ÷ Average inventory. Receivables turnover = Credit revenue ÷ Average receivables. Payables turnover = Credit purchases ÷ Average payables. Collection or payment period = 365 ÷ turnover.
Worked example: finding revenue from inventory turnover
Illustrative. A trader keeps average inventory of ₹50,000, turns it over 6 times a year, and earns gross profit of 25 per cent on revenue from operations. Cost of revenue = 6 × ₹50,000 = ₹3,00,000. Since cost is 75 per cent of revenue, revenue = ₹3,00,000 ÷ 0.75 = ₹4,00,000, and gross profit = ₹1,00,000.
Worked example 2: reading collection and payment periods together
Illustrative. Ganga Traders allows customers 30 days' credit and receives 45 days' credit from its suppliers. Its credit revenue is ₹14,60,000 and average trade receivables are ₹1,80,000, so receivables turnover = 8.11 times and the collection period = 365 ÷ 8.11, about 45 days. Its credit purchases are ₹10,95,000 and average trade payables ₹1,80,000, so payables turnover = 6.08 times and the payment period = about 60 days. Interpretation: customers take 45 days against the 30 allowed, so collection is slow and needs attention; and the firm takes about 60 days to pay suppliers who allow 45, so it is paying late, which can harm its reputation with suppliers. Turnover ratios become meaningful when compared with the credit terms actually agreed.
Key takeaways: activity ratios show how many times assets turn into sales. Use cost of revenue for inventory, credit revenue for receivables and credit purchases for payables, each over the average balance; 365 ÷ turnover gives days. Turnover of capital employed is split into fixed assets and working capital turnover.
Check your understanding
-
1. Opening inventory ₹60,000, closing inventory ₹80,000, cost of revenue from operations ₹5,60,000. Inventory turnover is:
- 7 times
- 9.33 times
- 8 times
- 4 times
Show answer
Answer: C. Average inventory = (₹60,000 + ₹80,000) ÷ 2 = ₹70,000. Turnover = ₹5,60,000 ÷ ₹70,000 = 8 times.
-
2. Credit revenue from operations ₹7,20,000; average trade receivables ₹1,20,000. The average collection period in months is:
- 2 months
- 6 months
- 1.67 months
- 0.5 months
Show answer
Answer: A. Turnover = ₹7,20,000 ÷ ₹1,20,000 = 6 times. Collection period = 12 ÷ 6 = 2 months.
-
3. While calculating trade receivables turnover, debtors are taken:
- After deducting provision for doubtful debts
- Excluding bills receivable
- Before deducting provision for doubtful debts
- At their closing figure only
Show answer
Answer: C. The textbook states that debtors should be taken before making any provision for doubtful debts, and that trade receivables include bills receivable.
-
4. Case: Revenue from operations is ₹18,00,000, current assets ₹5,00,000 and current liabilities ₹2,00,000. Working capital turnover is:
- 3.6 times
- 9 times
- 2.57 times
- 6 times
Show answer
Answer: D. Working capital = ₹5,00,000 − ₹2,00,000 = ₹3,00,000. Turnover = ₹18,00,000 ÷ ₹3,00,000 = 6 times.
-
5. Assertion (A): A very high inventory turnover is always a good sign. Reason (R): A high inventory turnover may result from buying in small lots or selling quickly at low margins.
- Both A and R are true, and R is the correct explanation of A
- Both A and R are true, but R is not the correct explanation of A
- A is true, but R is false
- A is false, but R is true
Show answer
Answer: D. A is false: high turnover is generally good but must be interpreted carefully. R is true and is exactly why a high figure is not automatically good.
Sign in to keep track of the lessons you finish.