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.
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.
- Average inventory = ($40,000 + $60,000) ÷ 2 = $50,000.
- Inventory turnover = $150,000 ÷ $50,000 = 3.00 turns for the quarter.
- Estimated days in inventory = 90 ÷ 3.00 = 30 days.
How to use the calculator
- Choose the reporting period and count its calendar days.
- 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.
- 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 referenceInventory 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.