Free inventory turnover calculator

Calculate inventory turns and estimated days in inventory using cost of goods sold and your opening and closing balances.

Example · 90-day quarter

3.00 turns

$150,000 COGS ÷ $50,000 average inventory

30 days in inventory · 90 days ÷ 3.00 turns

Calculate inventory turnover

Start with the example or enter your own reporting period.

Reporting period and values at cost

Use one period, currency, cost basis and inventory scope for all three amounts.

Your inventory turnover

3.00 turns

For the 90-day reporting period

Estimated days in inventory
30 days
Average inventory at cost
50,000 in your input currency

Worked example

Harbor Thread Co. reviews January 1 through March 31, 2026. Over those 90 days, COGS was $150,000. Opening inventory at cost was $40,000 and closing inventory was $60,000.

  1. Average inventory = ($40,000 + $60,000) ÷ 2 = $50,000.
  2. Inventory turnover = $150,000 ÷ $50,000 = 3.00 turns for the quarter.
  3. Estimated days in inventory = 90 ÷ 3.00 = 30 days.

How to use the calculator

  1. Choose the reporting period and count its calendar days.
  2. Enter COGS and the inventory balances at the start and end, using the same currency and cost basis. Find COGS on the income statement and inventory balances in your stock valuation records.
  3. Divide COGS by average inventory for turnover. Divide the period days by turnover for estimated days in inventory. Use the unrounded turnover to calculate days.

Days in inventory estimates historical inventory movement. For future stock coverage, use current available stock, expected demand and scheduled receipts.

OpenStax formula reference

Inventory turnover questions

What is inventory turnover?

Inventory turnover measures how many times an average inventory balance turned over in a reporting period. Divide cost of goods sold by average inventory at cost.

How do I calculate average inventory?

Add the opening and closing balances and divide by two. For seasonal stock, a series of balances across the period can give a more representative average.

What is a good inventory turnover ratio?

Compare similar products or businesses over equivalent periods. Consider margins, seasonal demand and stockouts alongside the turnover ratio.

What if COGS or average inventory is zero?

With positive inventory and zero COGS, turnover is zero and estimated days is unavailable. With zero average inventory, turnover and estimated days are undefined.

Cycle-count review sheetsLot traceability worksheet