Operations (Activity) Ratios Calculator

Operations (Activity) Ratios Calculator

Emerging AI Skill PRO

Enter Calculation

Formula

Inventory TurnoverA=COGS (A)Inventory (A)Inventory TurnoverB=COGS (B)Inventory (B)Δ=Inventory TurnoverB−Inventory TurnoverA\begin{gathered} \text{Inventory Turnover}_A = \frac{\text{COGS (A)}}{\text{Inventory (A)}} \\[1.5em] \text{Inventory Turnover}_B = \frac{\text{COGS (B)}}{\text{Inventory (B)}} \\[1.5em] \Delta = \text{Inventory Turnover}_B - \text{Inventory Turnover}_A \end{gathered}
Show calculation steps (3)
  1. Total Asset Turnover

    Total Asset TurnoverA=Sales (A)Total Assets (A)Total Asset TurnoverB=Sales (B)Total Assets (B)Δ=Total Asset TurnoverB−Total Asset TurnoverA\begin{gathered} \text{Total Asset Turnover}_A = \frac{\text{Sales (A)}}{\text{Total Assets (A)}} \\[1.5em] \text{Total Asset Turnover}_B = \frac{\text{Sales (B)}}{\text{Total Assets (B)}} \\[1.5em] \Delta = \text{Total Asset Turnover}_B - \text{Total Asset Turnover}_A \end{gathered}

    Sales divided by total assets for period A and period B; the change is B minus A.

  2. Average Collection Period (days)

    ACP=Accounts Receivable (A)Period Sales (A)×DaysACPB=Accounts Receivable (B)Period Sales (B)×Days\begin{gathered} \text{ACP} = \frac{\text{Accounts Receivable (A)}}{\text{Period Sales (A)}} \times \text{Days} \\[1.5em] \text{ACP}_B = \frac{\text{Accounts Receivable (B)}}{\text{Period Sales (B)}} \times \text{Days} \end{gathered}

    Accounts receivable divided by sales for the reporting period, times the number of days in that period.

  3. Equity Multiplier

    Equity MultiplierA=Total Assets (A)Shareholder Equity (A)Equity MultiplierB=Total Assets (B)Shareholder Equity (B)Δ=Equity MultiplierB−Equity MultiplierA\begin{gathered} \text{Equity Multiplier}_A = \frac{\text{Total Assets (A)}}{\text{Shareholder Equity (A)}} \\[1.5em] \text{Equity Multiplier}_B = \frac{\text{Total Assets (B)}}{\text{Shareholder Equity (B)}} \\[1.5em] \Delta = \text{Equity Multiplier}_B - \text{Equity Multiplier}_A \end{gathered}

    Total assets divided by shareholder equity for period A and period B; the change is B minus A.

Usage stats

Advertisement

Results

Inventory Turnover (A)
6
times
Ratio A
Inventory Turnover (times) 6
Total Asset Turnover (times) 1.25
Average Collection Period (days) 45.6
Equity Multiplier (times) 2

Report an error on this page

What this calculator does

The Operations Ratios Calculator computes the core activity (efficiency) ratios used to judge how well a business uses its assets: Inventory Turnover, Total Asset Turnover, Average Collection Period, and the Equity Multiplier. It is universal accounting math, so it works with any currency — just enter your figures in the units you already use. You can also enter a second scenario (column B) to see the change between two periods, budgets, or what-if cases.

How to use it

Enter your figures for scenario A (Cost of Goods Sold, Inventory, Sales, Total Assets, Accounts Receivable, Sales for the Reporting Period, and Shareholder Equity). Optionally fill in scenario B to enable a side-by-side comparison and a Change column (B minus A). Set the Reporting Period in days (commonly 365) and choose how many significant figures to display. Any ratio whose denominator is zero is shown as undefined ("—") rather than infinity.

The formulas

Inventory Turnover = COGS / Inventory. Total Asset Turnover = Sales / Total Assets. Average Collection Period = (Accounts Receivable / Period Sales) x Days, which equals receivables divided by average daily sales. Equity Multiplier = Total Assets / Shareholder Equity, a measure of financial leverage.

$$\text{Inventory Turnover} = \dfrac{\text{COGS}}{\text{Inventory}}$$$$\text{Total Asset Turnover} = \dfrac{\text{Sales}}{\text{Total Assets}}$$$$\text{ACP} = \dfrac{\text{Accounts Receivable}}{\text{Period Sales}} \times \text{Days}$$$$\text{Equity Multiplier} = \dfrac{\text{Total Assets}}{\text{Shareholder Equity}}$$
Advertisement
Four activity ratio formulas shown as fraction cards in a grid
The four operations ratios: inventory turnover, total asset turnover, average collection period and equity multiplier.

Worked example

With COGS = 100,000, Inventory = 17,000, Sales = 90,000, Total Assets = 250,000, Accounts Receivable = 8,000, Period Sales = 90,000, Shareholder Equity = 120,000 and 365 days at 3 significant figures:

$$\text{Inventory Turnover} = \dfrac{100{,}000}{17{,}000} = 5.88$$$$\text{Total Asset Turnover} = \dfrac{90{,}000}{250{,}000} = 0.360$$$$\text{Average Collection Period} = \dfrac{8{,}000}{90{,}000} \times 365 = 32.4 \text{ days}$$$$\text{Equity Multiplier} = \dfrac{250{,}000}{120{,}000} = 2.08$$

If scenario B raises Total Assets to 300,000 (equity unchanged), its Equity Multiplier is \(2.50\), a Change of \(+0.42\).

Two side-by-side panels comparing four ratio values between scenario A and B
Comparing two scenarios highlights how operating efficiency changes.

FAQ

Why is a ratio shown as a dash? The denominator was zero, so the ratio is mathematically undefined; fill in that figure to compute it.

What does "significant figures" do? It controls display precision only; the underlying math is unrounded. "auto" shows natural precision.

Should I use net or gross sales? Use net sales (revenue) consistently for turnover, and credit/net sales for the collection period to keep the comparison meaningful.

Last updated:

Most popular in Financial

View all Financial calculators