Understanding your turnover ratio
Turnover norms are industry-specific — perishability, product value, and supply chains drive them. The table shows the broad pattern; the informative comparison is always within an industry and against your own trend.
| Sector pattern | Typical turns per year | Typical DSI |
|---|---|---|
| Grocery / perishables | 10–20+ | under 35 days |
| General retail and apparel | 4–8 | 45–90 days |
| Durables, furniture, jewelry | 1–4 | 90–365 days |
- Ranges are indicative sector patterns from financial-analysis practice, not standards; within any sector the spread is wide.
- A rising ratio can signal efficiency — or under-stocking that causes stockouts and lost sales; a falling ratio can signal slowing demand or deliberate stock building ahead of a season.
- Inventory accounting method (FIFO vs LIFO vs weighted average) changes both COGS and inventory values, so comparisons across companies using different methods are distorted.
- Seasonal businesses should use a monthly average inventory; a year-end snapshot taken at the seasonal low overstates turnover.
What is inventory turnover?
Inventory turnover is the ratio of annual cost of goods sold to average inventory, showing how many times the stock on hand is sold through and replaced in a year. It is a standard efficiency ratio in financial statement analysis: capital tied up in inventory earns nothing, incurs storage and insurance costs, and risks obsolescence, so faster turnover generally reflects leaner working-capital management — up to the point where stockouts start costing sales.
The ratio uses cost of goods sold rather than revenue in the numerator because inventory is carried at cost on the balance sheet; using revenue would inflate the ratio by the gross margin. Average inventory — typically the mean of beginning and ending balances, or a monthly average for seasonal businesses — smooths out point-in-time distortions.
Days sales of inventory (DSI) restates the same information as a holding period: 365 divided by the turnover ratio. Five turns per year equals about 73 days of inventory on hand. DSI feeds directly into the cash conversion cycle alongside receivable and payable days, which is why analysts track it as a working-capital lever.
How to use this inventory turnover calculator
- Enter annual cost of goods sold from the income statement.
- Enter average inventory — commonly (beginning inventory + ending inventory) ÷ 2, or a monthly average for seasonal stock.
- Read the turnover ratio (times per year) and the days sales of inventory.
- Compare against your industry's norms and your own prior periods — grocery turns far faster than jewelry, so cross-industry comparison is uninformative.
- Worked example: $600,000 of annual COGS against $120,000 of average inventory gives a turnover of 5× per year, meaning inventory sits an average of 73 days.
The formula behind inventory turnover
Turnover divides annual COGS by average inventory value; days sales of inventory divides 365 by the turnover. Both express the same relationship — one as a frequency, one as a duration.
Common mistakes
- Using revenue instead of COGS in the numerator, which inflates the ratio by the gross margin and breaks comparability with standard benchmarks.
- Using ending inventory instead of average inventory — a low year-end snapshot (common after holiday selling) overstates turnover.
- Chasing a higher ratio without watching stockouts; the cost of a lost sale often exceeds the carrying cost saved.
- Comparing across industries or across companies using different inventory accounting methods (FIFO vs LIFO).
- Ignoring product-level mix — a healthy aggregate ratio can hide dead stock in some lines offset by fast movers in others.
अक्सर पूछे जाने वाले सवाल
What is a good inventory turnover ratio?
It depends on the industry: grocery and perishables commonly turn 10–20+ times per year, general retail around 4–8, and high-value durables like furniture or jewelry as low as 1–4. Within an industry, higher generally indicates leaner working capital — provided stockouts are not rising. The most useful benchmarks are direct competitors and your own historical trend.
How do I calculate inventory turnover?
Divide annual cost of goods sold by average inventory value: $600,000 of COGS against $120,000 of average inventory is a turnover of 5× per year. Average inventory is usually the mean of the beginning and ending balances, or a monthly average for seasonal businesses. Dividing 365 by the ratio converts it to days on hand — 73 days in this example.
Why use COGS instead of sales in the formula?
Because inventory is recorded at cost on the balance sheet, matching it against cost of goods sold compares like with like. Using revenue would mix a retail-priced numerator with a cost-priced denominator, inflating the ratio by the gross margin — a 50%-margin retailer would show double its true turnover. Some quick screens use sales anyway, so check which convention a benchmark uses before comparing.
What is days sales of inventory (DSI)?
DSI is the average number of days inventory sits before being sold: 365 divided by the turnover ratio. A turnover of 5 equals 73 days of inventory on hand. DSI is one leg of the cash conversion cycle — together with days sales outstanding and days payable outstanding — which measures how long cash is tied up in operations.
Is higher inventory turnover always better?
Not beyond the point where availability suffers. High turnover reduces carrying costs, obsolescence, and tied-up capital, but running too lean causes stockouts, lost sales, and expensive rush replenishment. Inventory management frameworks — including the EOQ model — treat this explicitly as a trade-off between holding costs and ordering/stockout costs rather than a race to the highest ratio.
संदर्भ
- Ross SA, Westerfield RW, Jordan BD. Fundamentals of Corporate Finance. 13th ed. McGraw-Hill Education, 2021 — asset management ratios.
- CFA Institute. Financial Statement Analysis — activity ratios. CFA Program Curriculum.
- U.S. Small Business Administration (SBA). Manage your finances — inventory management basics. sba.gov.
- Chopra S, Meindl P. Supply Chain Management: Strategy, Planning, and Operation. 7th ed. Pearson, 2019.