← All tools/Calculators/Business/Inventory Turnover Calculator
Inventory Turnover Calculator
See how fast your stock sells: the turnover ratio for the year, and how many days of inventory you hold.
Estimate only, not financial advice. Use the cost of goods sold from your profit-and-loss account, and opening and closing stock at cost — not at selling price.
Inventory turnover
How the numbers are worked out
How it works
Average inventory = (opening inventory + closing inventory) ÷ 2 Turnover = cost of goods sold ÷ average inventory Days of stock = 365 ÷ turnover
Worked example: cost of goods sold ₹12,00,000, opening inventory ₹2,00,000, closing inventory ₹4,00,000. Average inventory = (2,00,000 + 4,00,000) ÷ 2 = ₹3,00,000. Turnover = 12,00,000 ÷ 3,00,000 = 4.0×, and days of stock = 365 ÷ 4 = 91.25 days — about three months of stock on hand.
Frequently asked questions
What is a good inventory turnover?
It depends on the business — grocers turn stock 10 or more times a year, furniture sellers maybe 2 or 3. Compare with similar businesses, not with a single magic number.
Is a higher turnover always better?
Not always. Very high turnover can mean stock-outs and lost sales; very low turnover ties cash up in shelves. The healthy range is one that keeps shelves full without hoarding cash.
Should I use sales or cost of goods sold?
Cost of goods sold. Inventory is valued at cost, so dividing sales (which include your margin) by stock at cost would overstate how fast stock moves.
Why average the opening and closing stock?
Because stock rises and falls through the year. A single end-of-year figure can be misleading — after a big sale, or just before a delivery — so the average of the two ends is the fairer base.
What does “91.25 days of stock” mean in practice?
That on average, stock sits for about 91 days before it is sold. Roughly, the business holds a quarter’s worth of sales on its shelves at any time.
More tools
Tell us what you think
Loving this tool, or stuck on something? Tell us — it takes a minute.
We’ll only use your name and email to reply if needed. The tool and page are filled in for you.