Inventory Turnover Calculator

Choose this calculator to see how many times you sell through your inventory each year and how many days stock sits before it moves. Spot slow-moving products, tighten your cash conversion cycle, and free up capital for higher-return opportunities.

By CalcMastery Editorial Team

Inventory Turnover Calculator

Calculate inventory turnover and days in inventory (DIO). Use COGS (recommended) or Net Sales and choose average or single-period inventory.

Select the time basis for your inputs. Days in inventory is scaled to this period.

Exact number of days in your measurement period.

COGS (recommended)Net Sales

COGS basis is standard. Sales basis is an approximation when COGS is unavailable.

Average Inventory (recommended)Single Inventory (period end)

Average inventory smooths intra‑period swings and is standard for turnover/DIO.

$

COGS for the selected period. Used when basis is COGS.

$

Sales net of returns/allowances. Used for the Sales basis.

$

Inventory at the start of the period.

$

Inventory at the end of the period.

$

Single inventory balance for the period end.

Scenarios
Example scenarios: Retail / Manufacturing / Seasonal / Overstocked
Retail (Fast‑Moving)Manufacturing (Moderate)Seasonal (Slow)Overstocked (Very Slow)

Results

  • Inventory Turnover—
  • Days in Inventory (DIO)— days
  • Average Inventory$
  • Turnover Numerator—
  • Inventory Velocity—

Enter your inputs above to calculate the results.

What is Inventory Turnover?

Inventory turnover shows how many times a company sells and replenishes its inventory over a period. It’s a core efficiency metric: strong turnover means less capital trapped in stock, faster cash conversion, and higher ROIC; weak turnover signals overstocking or demand/supply issues.

Formula

Inventory Turnover = COGS / Average Inventory
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
DIO = Period Days / Inventory Turnover

Example

Inputs:

COGS =

500,000

Beginning Inventory =

50,000

Ending Inventory =

55,000

Period =

365

days

  1. Average Inventory = (50,000 + 55,000) / 2 = 52,500
  2. Inventory Turnover = 500,000 / 52,500 approx 9.52
  3. DIO = 365 / 9.52 approx 38.33 days

The business turns inventory ≈9.5× per year, holding stock for ≈38 days, indicating fast inventory velocity and efficient working-capital use.

How to Use the Inventory Turnover Calculator

Choose the analysis period

  • Select the period length (for example, Annual – 365 days). The calculator uses this to translate your turnover ratio into Days in Inventory (DIO).

Select the turnover basis

    • Pick COGS (recommended) or Net Sales. The calculator will then set the numerator in the turnover formula:
Inventory Turnover = COGS or Net Sales / Average Inventory

Set the inventory basis

    • Leave Average Inventory (recommended) on if you have both beginning and ending inventory; the tool will compute
Average Inventory = (Beginning Inventory + Ending Inventory) / 2

Switch to Single Inventory (period end) only if you only know the ending balance.

Enter your financial inputs

  • Type in COGS (or Net Sales, depending on your basis), plus Beginning Inventory and Ending Inventory. The calculator will automatically ignore any field that isn’t needed for the chosen options.

Review turnover, days, and velocity

    • Check the Inventory Turnover, Days in Inventory (DIO) and Inventory Velocity labels in the Results area. Days in inventory is derived as:
Days in Inventory = Period Days / Inventory Turnover

Compare these outputs against prior periods and industry norms to judge whether your current speed is too slow, too aggressive, or on target.

Frequently Asked Questions

Should I base inventory turnover on COGS or Net Sales in this calculator?

Use COGS when you can, because inventory is recorded at cost and the standard formula is COGS ÷ average inventory. Net Sales is a rough alternative when you don’t have reliable COGS data, but it mixes in gross margin and can overstate turnover.

Why does the calculator ask for both beginning and ending inventory?

The tool uses them to compute average inventory: (Beginning Inventory + Ending Inventory) ÷ 2. Averaging smooths out one-off spikes and gives a more realistic turnover and days-in-inventory figure than using a single period-end balance.

What is a “good” inventory turnover or days in inventory value?

In many sectors, healthy turnover tends to fall roughly in the 5–10× per year range (about 36–73 days of inventory), but the right number depends heavily on your industry, product type, and business model. Always compare your results with past periods and sector benchmarks instead of chasing a generic target.

How should I use the Days in Inventory (DIO) result from this calculator?

DIO shows how many days, on average, your stock sits before being sold. Use it to spot slow-moving items, tune reorder points, and test whether changes in purchasing, pricing, or promotions are actually speeding up or slowing down inventory flow over time.

Sources & Methodology