Understanding the working capital turnover ratio calculator — concept and principle
This calculator measures how much revenue a business generates per unit of working capital, the money tied up in current assets after current liabilities. It shows the turnover, the average working capital, working capital at the start and end, working capital per unit of revenue and the year-end current ratio. Analysts and finance managers use it to judge how efficiently short-term funds support sales.
How it is calculated
- Working capital = current assets − current liabilities
- Average working capital = (start + end) ÷ 2
- Working capital turnover = revenue ÷ average working capital
- Working capital per 1 of revenue = average working capital ÷ revenue
- Current ratio at the end = current assets ÷ current liabilities
If average working capital is zero or negative, the ratio is not meaningful and the page stops.
The principle
Working capital funds the day-to-day cycle of buying, producing, selling and collecting. A high turnover means sales are supported by relatively little working capital, so less money is tied up in receivables and inventory. A low turnover means a lot of money sits in current assets relative to sales. Very high turnover is not always good: it can mean the company is short of liquidity. When working capital is near zero, the ratio becomes huge and meaningless; the cash conversion cycle is then a better tool.
Worked example
Defaults: revenue 2,400,000; current assets 700,000 and liabilities 400,000 at the start; 820,000 and 420,000 at the end.
- Working capital at the start = 700,000 − 400,000 = $300,000; at the end = $400,000.
- Average = (300,000 + 400,000) ÷ 2 = $350,000.
- Turnover = 2,400,000 ÷ 350,000 = 6.86×.
- Working capital per 1 of revenue = 0.15.
- Current ratio at the end = 820,000 ÷ 420,000 = 1.95.
| Current assets at the end of the year | Working capital turnover |
|---|---|
| 205,000 | 56.47× |
| 410,000 | 16.55× |
| 615,000 | 9.7× |
| 820,000 | 6.86× |
| 1.02e+06 | 5.3× |
| 1.23e+06 | 4.32× |
| 1.64e+06 | 3.16× |
How to read the result
Each dollar of working capital supports about 6.86 of yearly sales. Working capital grew by a third while revenue is a single year's figure, so check whether receivables or inventory are building up faster than sales. Compare with industry peers, because retailers, manufacturers and service firms need very different amounts of working capital.
Common mistakes
- Including short-term debt inconsistently in current liabilities.
- Using only year-end balances in a seasonal business.
- Reading a very high ratio as efficiency when liquidity is tight.
- Comparing companies with different credit terms without adjustment.
Frequently asked questions
What is a good working capital turnover?
It depends on the industry; compare with similar companies and your own trend.
What if working capital is negative?
The ratio is not meaningful; some businesses, such as supermarkets, operate with negative working capital by design.
How is it different from the current ratio?
The current ratio measures liquidity at one date; turnover links working capital to a year's sales.
Sources: CFA Institute, "CFA Program Level II Financial Ratio List"