Activity ratios: formulas and operating interpretation

An activity ratio shows how efficiently a business uses assets or moves balances through its operating cycle. Total asset turnover, inventory turnover and receivables turnover answer different questions, so they should be read together. A company can generate more sales from its assets while taking longer to collect from customers.

The CFA Institute's financial analysis techniques reading groups inventory, receivables and asset turnover within activity ratios. They complement the profitability and liquidity measures covered in financial ratios; they do not replace those measures.

Match each question to its ratio

Use revenue when asking how much sales activity an asset supports. Use cost of goods sold when comparing inventory carried at cost with the inventory consumed through sales. For customer collections, use credit sales and trade receivables on a consistent gross or net basis.

Total asset turnover = Net revenue / Average total assets

Inventory turnover = Cost of goods sold / Average inventory

Receivables turnover = Net credit sales / Average trade receivables

Average balance = (Beginning balance + Ending balance) / 2

Turnover is expressed as times per stated period. Annual turnover and quarterly turnover are different measures unless a clearly labeled annualization is applied. For the annual examples below, days are calculated using a 365-day convention:

Inventory days = 365 / Annual inventory turnover

Receivables days = 365 / Annual receivables turnover

The days measures express the same balances in time rather than turns. They are not an aging report and cannot identify which invoices or stock items are overdue.

Use the right rows from your exports

Start with the income statement or ledger export for net revenue and cost of goods sold. Use the sales register to separate credit sales from immediate cash sales. Reconcile those totals before combining them with a balance-sheet export.

The balance data should include opening and closing total assets, inventory and trade receivables. For receivables, exclude employee advances, tax receivables and other amounts unrelated to customer sales. If you use balances net of a credit-loss allowance, label that choice and keep it consistent.

Inventory requires an equally clear policy. The IRS discussion of accounting methods and inventories describes specific identification, FIFO and LIFO and explains how accounting methods affect reported income. That is a reason to inspect valuation policies before comparing turnover across entities; it is not permission to treat different cost bases as equivalent.

For seasonal businesses, retrieve monthly balances as well as year-end balances. A low closing inventory after a holiday peak can make a two-point average look lean even when the business held substantial stock throughout the year.

A two-year example for a US distributor

The following illustrative distributor makes all sales on credit. Receivables are gross trade balances, and both years use the same inventory costing policy. Amounts are in USD.

First compute the average balances. The second year's opening amounts equal the first year's closing amounts, which is an initial continuity check.

Then divide each flow by the matching average balance. Ratios are rounded to two decimals and days to one decimal. All day calculations use the unrounded ratios.

For example, Year 2 asset turnover is $3,000,000 / $1,600,000 = 1.875 times before rounding. Year 2 receivables turnover is $3,000,000 / $300,000 = 10.00 times, equivalent to 36.5 days under the stated convention.

Prove the figures before explaining them

Multiply each unrounded turnover ratio by its denominator. The result must reproduce its numerator:

These identities prove the calculations, while the ledger reconciliation proves that the inputs came from the intended accounts. Neither replaces the other. A correct formula applied to inventory that includes another entity's stock still answers the wrong question.

For a combined business-unit ratio, sum the numerators and average balances before dividing. Do not average unit turnover rates without the corresponding denominator weights. The distinction is explained in count-weighted and value-weighted measures.

Turn the comparison into an operating discussion

Overall asset turnover increases slightly, and inventory turnover is unchanged. Customer collection is the exception: receivables turnover falls while collection days increase. The controller should ask the credit and sales teams whether terms changed, invoices were disputed or growth shifted toward slower-paying customers.

Average receivables increased from $200,000 to $300,000. At Year 1's 12.00 turns, Year 2's credit sales would require $3,000,000 / 12 = $250,000 of average receivables. Actual average receivables are $50,000 above that comparison. This estimates the additional balance associated with slower turnover; it does not prove that all of it is overdue or immediately collectible.

The credit team owns the collection investigation. Use the receivables turnover calculation for account boundaries and days sales outstanding for the comparison with customer terms. Operations and procurement own the inventory discussion: the same aggregate turns can hide shortages in fast-selling items and excess stock elsewhere. The inventory turnover ratio develops that item-level interpretation.

Finance owns the consistent definitions and the reconciliation. The operating managers own the explanation and the action, including any service or margin tradeoff that faster turnover would create.

Where it goes wrong

• Mixing cost and sales bases. Revenue over inventory produces a different figure from COGS over inventory and moves with gross margin.
• Using only the closing balance. Seasonality or a late collection can distort the resources used during the year.
• Counting cash sales in credit turnover. Those sales never created trade receivables and can make collection appear faster.
• Comparing different asset policies. Acquisitions, disposals, depreciation and outsourcing can change asset turnover without comparable operating improvement.
• Calling faster turnover automatically better. Stockouts and tighter credit terms can improve a ratio while damaging sales or service.

Compare activity ratios on your own files

Bring a sample of your own ledger, sales and balance exports to Covirage. Covirage maps the columns, its tools compute and check the ratios, and the external AI model explains the changes with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your own data.

See Covirage for finance teams for the reporting context.