Inventory turnover calculator
Inventory turnover tells you how many times in a year you sell and replace your average stock. Turn it round and you get the days stock sits in the shop or godown before it is sold, which is money tied up and not earning.
The formula
Average stock = (opening stock + closing stock) ÷ 2.
Inventory turnover = cost of goods sold ÷ average stock. Days in stock = 365 ÷ inventory turnover.
Cost of goods sold = opening stock + purchases + direct expenses − closing stock. The gross profit calculator works it out.
Worked example
A hardware shop sold goods costing ₹36,00,000 in the year. Stock was ₹5,00,000 at the start and ₹7,00,000 at the end, an average of ₹6,00,000. Turnover is ₹36,00,000 ÷ ₹6,00,000 = 6 times a year, so stock sits for about 61 days before it is sold.
More business calculators
- Business and accounting calculators
- Break-even calculator
- Gross profit calculator
- EBITDA calculator
- ROI calculator
- NPV calculator
- IRR calculator
- Payback period calculator
- Working capital calculator
- Current ratio calculator
- Quick ratio calculator
- Debt to equity ratio
- Debtor days calculator
- Depreciation calculator
- Cash flow forecast
- Accounting basics
Questions people ask
Why use cost of goods sold and not sales?
Stock is valued at cost, so comparing it with sales at selling price would mix two different bases and overstate turnover. If you only know sales, some people use sales ÷ average stock; just use the same method every year.
What is a good stock turnover?
It depends on the trade. A grocery or medical store turns stock many times a year; a jeweller or furniture shop far fewer. Compare with your own past years and with others in the same line.
How do I lower the days in stock?
Order smaller amounts more often, clear slow-moving items, stock fewer variants that rarely sell, and agree quicker delivery with suppliers so you need less safety stock.
A tax professional can call you back. Asking is free.
Get helpMore calculators
Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.