Inventory Turnover Calculator
Enter cost of goods sold for a period and your stock value at the start and end of it. You get average inventory, the turnover ratio and the days of stock on hand.
Enter your numbers to see the result.
How to use this tool
- Enter cost of goods sold for a period (often a year).
- Enter your inventory value at the start and end of that period, at cost.
- Adjust the number of days if the period is not a year.
Formulas and method
Average inventory = (Opening inventory + Closing inventory) ÷ 2
Inventory turnover = Cost of goods sold ÷ Average inventory
Days of stock on hand = Days in period ÷ Inventory turnover
Inventory must be valued at cost, the same basis as cost of goods sold.
Worked example
Cost of goods sold 120,000 for the year, inventory 18,000 at the start and 22,000 at the end.
- Average inventory = 20,000; turnover = 6×.
- Days on hand = 365 ÷ 6 = 60.8 days.
Limitations
- A two-point average can mislead for seasonal businesses; average monthly stock values give a better picture.
- Healthy turnover differs a lot between sectors.
Frequently asked questions
Is a higher turnover always better?
Usually it means less cash tied up in stock, but too high can mean frequent stock-outs. Compare with businesses like yours and with your own history.