Activity Ratios: 3 Turnover Formulas Made Simple
Activity ratios, also called efficiency or turnover ratios, show how well a company uses its assets to generate sales. The three core ones are receivables turnover (net sales ÷ average net receivables), inventory turnover (cost of goods sold ÷ average inventory), and asset turnover (net sales ÷ average total assets). Results are expressed in times per period.
A company can own many assets without using them productively. These ratios help you spot where resources are tied up. This guide follows the ratio reference in Wiley’s Intermediate Accounting, Appendix 4B. Want a deeper dive on collections? See our accounts receivable turnover guide.
Video lesson with Professor Farhat
Professor Farhat walks through each turnover ratio step by step. Jump straight to the part you need:
- 1:13 Total asset turnover
- 4:32 Fixed asset turnover
- 7:15 Inventory turnover
- 9:58 Days’ sales in inventory
- 11:13 Accounts receivable turnover
- 13:57 Days’ sales in receivables (average collection period)
Watch the complete Farhat Lectures video on YouTube.
What are the main activity ratios and their formulas?
| Ratio | Reference formula | What the result describes |
|---|---|---|
| Accounts receivable turnover | Net sales ÷ Average net accounts receivable | Sales relative to the average customer balance awaiting collection |
| Inventory turnover | Cost of goods sold ÷ Average inventory | Inventory cost flowing through sales relative to average inventory held |
| Asset turnover | Net sales ÷ Average total assets | Sales generated per dollar invested in total assets |
Turnover is usually expressed in times per period, not as a profit percentage. Annual inventory turnover of 5 means annual cost of goods sold is five times average inventory. It does not mean the company earned a 500% profit.
Activity ratios are sometimes called efficiency or asset-utilization ratios. They complement liquidity ratios: collections and inventory movement influence how readily current assets can support payments.
Why do activity ratios use average balances?
Sales and cost of goods sold accumulate over a period. A balance sheet reports assets at one date. Averaging beginning and ending assets makes the comparison more representative of the resources used during that period.
Average balance = (Beginning balance + Ending balance) ÷ 2. Apply this separately to net receivables, inventory, and total assets. “Net receivables” means the receivable balance after its related allowance.
The simple average is not a guarantee of precision. A seasonal business may have large balances between the two dates. If monthly or quarterly averages are provided, follow the problem’s instructions. Keep periods consistent: do not compare one company’s quarterly turnover directly with another company’s annual turnover.
Why use cost for inventory but sales for other ratios?
Inventory is carried on the balance sheet at cost (written down if its value falls below cost), so inventory turnover uses cost of goods sold. Using sales would mix a selling-price numerator with a cost-based denominator. A higher markup could then make turnover appear stronger even though inventory moved at the same pace.
Asset turnover intentionally asks how much revenue the entire asset base generates, so net sales is appropriate. Receivables turnover needs one extra distinction. The textbook reference formula uses net sales. For a collection-focused analysis, net credit sales are preferable when separately available because cash sales never become receivables.
If total net sales are used as a proxy for net credit sales, disclose that choice. Significant cash sales can make collections appear faster. Our receivables turnover formula and collection-days lesson walks through this difference in detail. Our example below assumes all sales are credit sales, so both approaches give the same result.
Worked example: one company, three activity ratios
Hypothetical example. Willow Wholesale has annual net sales of $900,000, all on credit, and cost of goods sold of $540,000. Beginning and ending net receivables are $80,000 and $100,000. Inventory is $120,000 and $150,000. Total assets are $600,000 and $750,000.
| Measure | Average balance | Turnover |
|---|---|---|
| Receivables | ($80,000 + $100,000) ÷ 2 = $90,000 | $900,000 ÷ $90,000 = 10.00 times |
| Inventory | ($120,000 + $150,000) ÷ 2 = $135,000 | $540,000 ÷ $135,000 = 4.00 times |
| Total assets | ($600,000 + $750,000) ÷ 2 = $675,000 | $900,000 ÷ $675,000 = 1.33 times |
Receivables turnover of 10.00 suggests the annual credit-sales volume is ten times the average net receivable balance. Inventory turnover of 4.00 describes cost flowing through inventory. Asset turnover of approximately 1.33 means $1.33 of annual sales for each $1 of average total assets. Round only the final result when intermediate calculations are not exact.
How do you convert turnover into days?
Receivables and inventory turnover can be converted into days by dividing the days in the reporting period by the corresponding turnover for that same period. For annual turnover, use the following formulas. For a shorter period, use its matching day count. This conversion does not apply to total asset turnover.
- Average collection period (also called days’ sales in receivables) = 365 ÷ Receivables turnover
- Days’ sales in inventory = 365 ÷ Inventory turnover
Here’s Willow Wholesale again:
- Average collection period: 365 ÷ 10.00 = 36.5 days. On average, customers pay about 36 or 37 days after a sale.
- Days’ sales in inventory: 365 ÷ 4.00 = 91.25 days. Inventory sits about 91 days before it is sold.
Add the two together and you get an approximate operating cycle: 36.5 + 91.25 = 127.75, or about 128 days from buying inventory to collecting cash from the customer.
Exam tip: some problems use a 360-day year instead of 365. Use whatever the question gives you. Professor Farhat covers both day measures in the video at 9:58 and 13:57.
What does high or low turnover tell you?
Higher turnover can indicate more efficient use of resources, but the cause matters. Faster receivables turnover could reflect better collections or stricter credit terms that discourage customers. Faster inventory turnover could reflect good sales or inadequate inventory that causes stockouts.
Asset turnover also depends on the business model. A service company with few physical assets may have a different pattern from a capital-intensive manufacturer. Aging equipment can reduce recorded asset balances through depreciation, increasing turnover without a matching improvement in sales.
Compare the company with its own history and similar businesses using consistent formulas. The SEC’s financial-statement guide supports the cost-of-sales-over-average-inventory calculation and cautions that suitable ratios vary by industry.
Efficiency is also different from profit. A company may sell large volumes at very small margins. Read profitability ratios to connect sales generation with earnings, and coverage ratios to assess financing pressure.
What other activity ratios might you see?
The three ratios above are the core set in the textbook reference. Other sources and exam questions sometimes add these:
| Ratio | Formula | What it describes |
|---|---|---|
| Fixed asset turnover | Net sales ÷ Average net property, plant, and equipment | How much revenue long-lived operating assets produce |
| Accounts payable turnover | Net credit purchases ÷ Average trade accounts payable (cost of goods sold may be used as a proxy when purchase data are unavailable) | How quickly the company pays its suppliers |
| Working capital turnover | Net sales ÷ Average working capital | How much revenue each dollar of working capital supports |
Definitions vary more for these ratios than for the core three, so always check which formula your textbook or exam question expects.
Where do activity ratios show up on the CPA and CMA exams?
On the CPA exam, the Financial Accounting and Reporting (FAR) core section includes calculating receivables, inventory, and accounts payable turnover. The Business Analysis and Reporting (BAR) discipline also tests ratio analysis and interpretation of financial statement fluctuations. On the CMA exam, the IMA tests financial ratios in Part 2, Section A: Financial Statement Analysis.
On both exams, expect to interpret results, not just calculate them. A classic question asks what a change in turnover suggests about collections or inventory.
Asset turnover also connects to profitability through the DuPont relationship: return on assets = profit margin × asset turnover. Say Willow Wholesale earned a 5% profit margin. Its return on assets would be about 5% × 1.333 = 6.7%. You can check it directly: net income of $45,000 ÷ average total assets of $675,000 = 6.7%. Our profitability ratios lesson covers return on assets in more detail.
Common activity-ratio mistakes
Do not use purchases instead of cost of goods sold for inventory turnover. Purchases add inventory; cost of goods sold measures inventory released through sales. Do not divide by ending balances when the required averages can be calculated. Do not interpret 1.33 times as 1.33%. Finally, avoid labeling every increase “good” without checking why it occurred.
Key takeaways
- Activity ratios measure efficiency, not profit.
- Receivables turnover = Net sales ÷ Average net accounts receivable. Use net credit sales when you have it.
- Inventory turnover = Cost of goods sold ÷ Average inventory. Use cost, never sales or purchases.
- Asset turnover = Net sales ÷ Average total assets.
- Use average balances: (beginning balance + ending balance) ÷ 2.
- Results are in times per period. For receivables or inventory turnover, divide the matching period’s day count by turnover to estimate days; use 365 for an annual period unless the question specifies otherwise.
- Higher is not automatically better. Always find out why a ratio moved.
Want more practice like this? Try the free sample course.
Practice questions with explanations
1. Calculate inventory turnover.
Cost of goods sold is $420,000. Beginning inventory is $60,000 and ending inventory is $80,000.
Answer: Average inventory is $70,000; turnover is $420,000 ÷ $70,000 = 6.00 times. Sales revenue is not needed.
2. Which receivables numerator should you use?
A collection problem supplies net credit sales of $500,000 and total net sales of $650,000.
Answer: Use $500,000 for a collection-focused calculation. If a question specifically asks for the net-sales version of the formula, use $650,000 and note that choice.
3. Does asset turnover of 2.0 prove high profitability?
Answer: No. It shows $2 of sales per $1 of average assets. Expenses may consume most or all of those sales; examine profit margin or return on assets to assess earnings.
4. Convert receivables turnover into days.
A company’s receivables turnover is 8.0 times. Using a 365-day year, what is its average collection period?
Answer: 365 ÷ 8.0 = 45.625, or about 45.6 days. On average, customers take about 46 days to pay.
Interactive Activity Ratios Exercise: Match Formulas and Meanings
Match accounts receivable turnover, inventory turnover, and asset turnover with their formulas and what they measure.
Select one formula and one meaning for each ratio, then choose Check answers. Each correct selection earns one point, for a total of six points.
Formula note: This exercise uses the textbook’s net-sales formula for receivables turnover. For collection-focused analysis, use net credit sales when available. Review why the numerator matters if you need a reminder.
Review the turnover formulas and meanings
| Activity ratio | Formula | What it measures |
|---|---|---|
| Accounts receivable turnover | Net sales ÷ Average net accounts receivable | Measures liquidity of receivables. |
| Inventory turnover | Cost of goods sold ÷ Average inventory | Measures liquidity of inventory. |
| Asset turnover | Net sales ÷ Average total assets | Measures how efficiently assets are used to generate sales. |
Frequently asked questions
What are the three main activity ratios?
Answer: Receivables turnover, inventory turnover, and asset turnover. Some sources also include fixed asset turnover, accounts payable turnover, and working capital turnover.
Is a higher activity ratio always better?
Answer: No. Higher turnover often signals efficiency, but it can also come from overly strict credit terms, inventory shortages, or old, heavily depreciated assets. Compare the result with prior years and similar companies.
How do you convert a turnover ratio into days?
Answer: Divide the days in the reporting period by receivables turnover or inventory turnover for that same period. Use 365 for annual turnover, or 360 if the question specifies. Annual receivables turnover of 10 means an average collection period of 36.5 days. This conversion does not apply to total asset turnover.
What is the difference between activity ratios and profitability ratios?
Answer: Activity ratios measure how efficiently assets generate sales. Profitability ratios measure how much of those sales turn into earnings.
Are activity ratios the same as liquidity ratios?
Answer: No. Activity ratios examine how assets are used or move through operations. Liquidity ratios directly compare short-term resources or operating cash generation with obligations.
Is net sales the same as net income?
Answer: No. Net sales reflects sales after relevant returns, allowances, and discounts. Net income is the earnings remaining after expenses and other income-statement items.
What if only an ending balance is supplied?
Answer: Follow the stated instructions and identify any ending-balance approximation. Do not silently call it an average when beginning data are missing.
Sources and learning context
Lesson scope: Wiley Intermediate Accounting, Appendix 4B: Ratio Analysis—A Reference. For primary-source background on financial statements and selected ratios, see the U.S. Securities and Exchange Commission’s student-friendly guide.
About the author
Mansour Farhat, CPA, CIA, DBA, teaches accounting and CPA and CMA exam preparation through Farhat Lectures and the Farhat Lectures YouTube channel.
CONTINUE LEARNING
Responses