Inventory Turnover
How fast inventory sells
Why This Matters
Inventory sitting on a shelf is money sitting still.
Every unit of inventory represents cash that was spent โ on ingredients, raw materials, or finished goods โ that hasn't come back yet. The faster it sells, the faster that cash returns and becomes available to buy more inventory, pay bills, or invest in growth.
Inventory Turnover measures how many times a company sells and replaces its entire inventory in a given period. A high turnover means inventory moves quickly โ the business is selling efficiently and doesn't tie up excessive cash in stock. A low turnover means inventory lingers โ raising the risk of spoilage, obsolescence, and cash flow strain.
For a coffee shop, inventory is perishable. Milk, pastries, and syrups expire. Inventory that doesn't turn fast enough becomes waste โ a direct hit to gross margin. For a furniture retailer, slow-turning inventory may simply mean the product isn't selling. For a manufacturer, it could mean production is outpacing demand.
Inventory Turnover is one of the most operational of all financial ratios. It connects directly to purchasing decisions, pricing strategy, supplier terms, and storage costs. A declining trend is one of the earliest warning signs of operational trouble.
The Formula
INVENTORY TURNOVER
Cost of Goods Sold (COGS)
Average Inventory
= Inventory Turnover
Where: Average Inventory = (Beginning Inventory + Ending Inventory) รท 2
Output: A NUMBER (times per period, usually annual)
โ Why COGS, not Revenue? Inventory is recorded at cost, not selling price. Using COGS keeps both sides of the ratio at the same cost basis โ an apples-to-apples comparison. (Some analysts use Revenue; always check which is being used.)
โ Why Average Inventory? Inventory fluctuates throughout the year. A year-end snapshot may be unrepresentative (seasonal low or high). Average inventory gives a more accurate measure of what was typically on hand during the period income was earned.
Companion Metric: Days Inventory Outstanding (DIO)
Inventory Turnover is often converted to Days Inventory Outstanding โ how many days, on average, inventory sits before being sold:
DAYS INVENTORY OUTSTANDING (DIO)
365 days
Inventory Turnover
= DIO
OR directly:
Average Inventory ร 365
COGS
= DIO
DIO = 30 days โ Inventory sells in about 30 days on average
DIO = 90 days โ Inventory sits for 3 months before selling
Lower DIO = faster inventory movement = better (generally)
Step-by-Step Calculation
ABC Coffee Shop โ Year Ended December 31, 2026
From the Income Statement
- COGS$80,000
From the Balance Sheet
- Ending Inventory (Dec 31, 2026)$12,000
- Beginning Inventory (Jan 1, 2026)$9,500
Average Inventory = ($12,000 + $9,500) รท 2 = $10,750
Inventory Turnover = $80,000 รท $10,750 = 7.44ร
Days Inventory Outstanding (DIO) = 365 รท 7.44 = 49.1 days
Interpretation: ABC Coffee Shop turns its inventory 7.44 times per year โ selling and replacing its average inventory stock roughly every 49 days. For a food service business with perishable goods, this is reasonable, though room for improvement exists (industry leaders target 30 days or less).
Interpreting Inventory Turnover
Context is everything โ ideal turnover rates vary enormously by industry:
| Industry | Typical Turnover | Notes |
|---|---|---|
| Grocery / Food Retail | 15โ30ร | High-volume, perishable goods |
| Fast Food / Restaurant | 20โ50ร | Daily ingredients, small stock |
| Coffee Shop | 10โ20ร | Perishable goods, regular restocking |
| Apparel / Fashion | 4โ8ร | Seasonal, style risk |
| Furniture / Home | 4โ6ร | Large items, long sell cycle |
| Automobile Dealers | 6โ10ร | High value, moderate velocity |
| Manufacturing | 4โ8ร | Production cycle drives turns |
| Pharmaceuticals | 3โ5ร | Long shelf life, specialized |
| Luxury Goods | 2โ3ร | Intentionally exclusive supply |
General Interpretation Guide (context-dependent)
Very High (well above industry): Potentially understocking โ risk of lost sales / stockouts
High (above industry avg): Excellent sell-through โ
At Industry Average: Normal operations โ
Below Industry Average: Slow-moving stock; investigate
Very Low (well below industry): Serious concern โ obsolescence, demand problem, or overstocking
Trend Analysis: ABC Coffee Shop
| Metric | 2024 | 2025 | 2026 |
|---|---|---|---|
| COGS | $65,200 | $69,580 | $80,000 |
| Beginning Inventory | $8,000 | $8,800 | $9,500 |
| Ending Inventory | $8,800 | $9,500 | $12,000 |
| Average Inventory | $8,400 | $9,150 | $10,750 |
| Inventory Turnover | 7.76ร | 7.60ร | 7.44ร |
| DIO (days) | 47.0 | 48.0 | 49.1 |
| Industry Average | 12ร | 12ร | 12ร |
Inventory turnover is slowly declining (7.76 โ 7.44) while inventory is growing faster than COGS. Not yet alarming โ still positive turns โ but worth monitoring.
Possible explanations:
- ABC is building safety stock as business grows (intentional)
- New product lines require more inventory variety
- Slight demand forecasting inefficiency
NOTE: ABC's 7.44ร is below the coffee shop industry average of ~12ร. This suggests ABC may be carrying more inventory than needed โ an opportunity to improve cash flow by reducing average stock levels.
If ABC matched industry average of 12ร:
Average Inventory needed: $80,000 รท 12 = $6,667
Current average: $10,750
Potential cash release: ~$4,000 in freed-up inventory investment
Cross-Company Comparison: ABC vs. Horizon Cafรฉ
| Metric (2026) | ABC Coffee Shop | Horizon Cafรฉ | Industry Avg |
|---|---|---|---|
| COGS | $80,000 | $572,000 | โ |
| Average Inventory | $10,750 | $36,000 | โ |
| Turnover | 7.44ร | 15.9ร | 12ร |
| DIO | 49.1 days | 23.0 days | โ |
Horizon turns inventory more than twice as fast as ABC. At Horizon's scale, efficient inventory management becomes critical โ $36K in average inventory generating $572K in COGS shows tight supply chain management.
ABC's slower turns may reflect:
- Smaller purchasing volumes (less frequent, larger orders)
- Less sophisticated inventory management systems
- Intentional buffer stock given unreliable suppliers
In practical terms: ABC's $10,750 average inventory supports $80K COGS. If ABC turned inventory at Horizon's rate (15.9ร), it would need only ~$5,000 in average inventory โ freeing $5,750 in cash.
The Inventory Turnover โ Gross Margin Trade-off
There's a fundamental relationship between inventory turnover and gross margin that helps explain why different businesses operate at different turnover rates:
Low Margin / High Turnover
Grocery store โ sells at thin margins but turns over inventory daily.
"I'll make a little on each unit but sell thousands of them."
High Margin / Low Turnover
Luxury watch retailer โ sells at fat margins but inventory may sit months.
"I'll make a lot on each unit and wait for the right buyer."
Both can be highly profitable โ different paths to the same destination.
This is directly connected to the ROA decomposition (Net Margin ร Asset Turnover) from the profitability section โ high-turnover businesses trade margin for velocity; high-margin businesses trade velocity for pricing power.
Common Mistakes
Mistake 1: Using Revenue Instead of COGS
โ Wrong
Inventory Turnover = Revenue รท Average Inventory
= $170,000 รท $10,750 = 15.8ร
โ Right
Inventory Turnover = COGS รท Average Inventory
= $80,000 รท $10,750 = 7.44ร
Using Revenue inflates the ratio because revenue includes the markup over cost. Always check which formula a source uses before comparing ratios.
Mistake 2: Using Year-End Inventory Instead of Average
โ Wrong
Inventory Turnover = $80,000 รท $12,000 = 6.67ร
(using only ending inventory)
โ Right
Inventory Turnover = $80,000 รท $10,750 = 7.44ร
(using average of beginning and ending). For seasonal businesses especially, year-end inventory can be at a peak or trough that distorts the ratio.
Mistake 3: High Turnover Is Always Good
โ Wrong
"Turnover jumped from 10ร to 25ร โ great improvement!"
Possible reality: stockouts and lost sales, a discontinued product line, or dramatically reduced safety stock increasing supply risk.
โ Right
Extremely high turnover (well above industry) may signal understocking risk. The goal is optimal turnover โ fast enough to minimize carrying costs and cash tie-up, but not so fast that stockouts occur. Always check whether revenue and customer satisfaction are holding up alongside high turnover.
Key Takeaway
Inventory Turnover measures how many times a company sells and replaces its inventory in a period โ calculated as COGS divided by average inventory. The companion metric, Days Inventory Outstanding (DIO), expresses this as the average number of days inventory sits before selling. Higher turnover generally means better efficiency and less cash tied up in stock, but optimal turnover varies widely by industry. A declining turnover trend signals potential overstocking, slowing demand, or supply chain inefficiency โ and is an early warning sign worth investigating before it impacts gross margin or cash flow.
Test Your Understanding
See if you've got the basics down. Click each option and check your answer.
Question 1: COGS = $240,000. Beginning inventory = $20,000. Ending inventory = $28,000. What is inventory turnover?
Question 2: Inventory Turnover = 8ร. What is Days Inventory Outstanding?
Question 3: A luxury car dealer has inventory turnover of 4ร per year. A grocery store has turnover of 25ร per year. Which is performing better?
Question 4: True or False: Using revenue instead of COGS in the inventory turnover formula produces a lower ratio.
Ready to Practice?
Calculate inventory turnover and DIO from comparative balance sheets and income statements. Identify the trend and assess whether inventory management is improving or deteriorating.
Try the Practice LabWhat's Next?
Accounts Receivable Turnover โ How fast does the company collect cash from customers? If inventory turnover measures how fast stock moves, AR turnover measures how fast those sales convert to actual cash.
Accounts Receivable Turnover
How fast we collect from customers
Earnings Per Share
Profit allocated to each share