Category: Financial Calculations • Difficulty: Intermediate • Related metrics: Inventories, Cost of Sales
1) What you’ll learn
What inventory turnover measures and how it links operations to cash flow
The standard formulas for Inventory Turnover and Days Inventory Outstanding (DIO)
How to calculate using Cost of Sales and average inventory, step-by-step
Why industry context matters and what “good” looks like across sectors
How to use turnover trends in screening, forecasting, and valuing companies
Common pitfalls: seasonality, accounting methods (FIFO/LIFO), and revenue-based shortcuts
2) Concept explanation
Inventory turnover tells you how many times a company sells and replaces its inventory over a period (usually a year). In plain terms, it’s a speedometer for stock movement. Faster turnover typically means the company converts goods into sales more quickly, tying up less cash in warehouses.
You calculate it by comparing the cost of what was sold to the amount of inventory held on average. Using cost rather than sales is important because the inventory on the balance sheet is recorded at cost, not selling price. This keeps the numerator and denominator in the same “units.”
Turnover connects to the rhythm of the business. A grocer sells perishables quickly (high turnover), while a luxury jeweler sells fewer high-ticket items (low turnover). Neither is inherently better; the key is whether turnover aligns with the business model, pricing power, and supply chain stability.
3) Why it matters
Inventory is cash sitting on shelves. The longer it sits, the more it risks damage, obsolescence, or markdowns—and the more working capital it absorbs. Higher turnover can free up cash, shrink storage costs, and improve return on capital. But if turnover is too high because inventory is too lean, the company risks stockouts and lost sales.
For investors, inventory turnover is a practical lens on operational execution. Combined with gross margins, it reveals merchandising skill: can a company sell quickly without discounting? Over time, improving turnover can reduce the cash needed to grow, supporting better free cash flow and potentially higher valuation.
Pair inventory turnover with Days Inventory Outstanding (DIO) to compare companies with different turnover speeds on a common time scale: days.
4) Calculation method
Core formula
Inventory Turnover = Cost of Sales / Average Inventory
Average inventory (basic)
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
Days Inventory Outstanding (DIO)
DIO = 365 / Inventory Turnover
Step-by-step example A (annual, simple average):
Inputs from financial statements:
Cost of Sales (also called Cost of Goods Sold, COGS): $600 million
Beginning Inventory: $150 million
Ending Inventory: $210 million
Compute average inventory:
(150m+210m) / 2 = $180m
Compute inventory turnover:
600m/180m = 3.33x
Compute DIO:
365 / 3.33 ≈ 109.6 days
Interpretation: The company turns its inventory about 3.3 times per year, or holds roughly 110 days of inventory on average.
Step-by-step example B (quarterly averaging for seasonality):
Suppose inventories by quarter end were: Q1 140m,Q2160m, Q3 220m,Q4180m; annual Cost of Sales is $720m.
Average inventory (quarterly average):
(140m+160m + 220m+180m) / 4 = $175m
Turnover:
175m = 4.11x
Why quarterly averaging? If inventory is seasonal (for example, building for holidays), a simple begin/end average may misstate the true average. Using quarterly or monthly averages smooths the effect.
Alternative (less preferred): Sales-based turnover
Sales-based turnover = Sales / Average Inventory
This can be misleading because sales are at selling price while inventory is at cost. Use only when COGS is unavailable, and compare companies consistently.
Accounting nuances:
FIFO vs LIFO: Under inflation, LIFO raises Cost of Sales and lowers inventory values compared to FIFO, making turnover look higher. Compare like with like or adjust using LIFO reserves when disclosed.
Write-downs: Significant inventory write-downs reduce inventory and can temporarily inflate turnover; check notes for unusual items.
Capitalized costs: Some firms capitalize freight-in or handling into inventory; others expense more. This affects both cost of sales and inventory levels.
5) Case study
Company Alpha (mid-market apparel retailer) vs. Company Beta (discount grocery chain).
Alpha (Apparel):
Cost of Sales: $1,200m
Quarterly inventories: 260m,300m, 420m,320m → Average = $325m
Turnover = 1,200m/325m = 3.69x
DIO = 365 / 3.69 ≈ 99 days
Gross margin: 42%
Beta (Grocery):
Cost of Sales: $6,500m
Quarterly inventories: 360m,380m, 410m,390m → Average = $385m
Turnover = 6,500m/385m = 16.88x
DIO = 365 / 16.88 ≈ 21.6 days
Gross margin: 24%
Analysis:
Beta’s high turnover matches the grocery model: perishables sell quickly, and the business runs on thin margins but rapid volume.
Alpha’s lower turnover reflects fashion cycles and higher markups; items stay longer to preserve brand and pricing.
Which is better? Neither in isolation. For Alpha, a rising turnover from, say, 3.0x to 3.7x without margin erosion suggests better assortment and inventory planning. For Beta, a fall from 18x to 16.9x might indicate supply chain friction or overstocking that could pressure cash.
Always judge turnover relative to peers and the firm’s own history. A single period spike or drop can be driven by timing, promotions, or one-off write-downs.
6) Practical applications
Screening for working capital efficiency:
Favor companies with stable or improving turnover vs. their 3–5 year history and peers.
Combine with Receivables and Payables days to assess the Cash Conversion Cycle.
Forecasting growth and cash needs:
Project inventory as a function of future Cost of Sales and target DIO. For example, if Cost of Sales is expected at $1,000m and target DIO is 80 days, implied average inventory is:
Average Inventory = (Target DIO / 365) × Cost of SalesAverage Inventory = (80 / 365) × �PROTECTED_EXPR_13�219m
This helps estimate working capital investment and free cash flow.
Diagnosing margin pressure:
Falling turnover with stable sales can signal slow-moving stock and future markdowns. Watch for rising Days Inventory before gross margin declines.
Supply chain risk monitoring:
Sudden turnover drops might indicate logistics bottlenecks or demand weakness; sudden spikes may reflect stockouts or aggressive inventory cuts that could hurt sales.
Valuation context:
Improvements in turnover reduce capital tied up per dollar of revenue, lifting returns on invested capital (ROIC). This can justify higher valuation multiples if sustainable.
Management quality check:
Consistent DIO improvement alongside stable or rising gross margins often points to strong merchandising, demand forecasting, and replenishment systems.
7) Common misconceptions
よくある誤解
- Higher turnover is always better: Extremely lean inventory can cause stockouts, lost sales, and unhappy customers.
- Use sales instead of cost: Mixing sales (at selling price) with inventory (at cost) distorts turnover; use Cost of Sales for accuracy.
- One quarter tells the story: Seasonality and timing mean you should use multi-period averages and trends, not a single snapshot.
- Cross-industry comparisons are definitive: A luxury brand with low turnover isn’t “worse” than a grocer; context is everything.
- Accounting methods don’t matter: FIFO vs LIFO, write-downs, and capitalization policies can materially skew turnover.
8) Summary
まとめ
- Inventory turnover shows how many times inventory is sold and replaced over a period.
- Use Cost of Sales divided by average inventory; convert to DIO for an intuitive days measure.
- Compare within industries and against a company’s own history, not across unrelated sectors.
- Adjust for seasonality using quarterly or monthly averages to avoid distorted results.
- Watch accounting choices like FIFO/LIFO and one-off write-downs that can inflate or deflate turnover.
- Improving turnover can free cash and lift ROIC, but overly lean stock risks lost sales.
Glossary links
Inventories: A current asset representing goods held for sale or used in production, measured at cost.
Cost of Sales (COGS): The direct costs of producing goods sold in a period; used as the numerator in turnover.
Days Inventory Outstanding (DIO): 365 divided by inventory turnover; average days inventory sits before being sold.
FIFO/LIFO: Inventory accounting methods that affect cost recognition and balance sheet inventory values.
Working Capital: Current assets minus current liabilities; inventory is a major component.
Glossary
Inventory Turnover: A ratio showing how many times a company sells and replaces its inventory in a period.
Average Inventory: The mean inventory level over a period, often beginning plus ending divided by two or multi-period average.
Cost of Sales (COGS): Direct costs of goods sold in a period, including materials and direct labor.
Days Inventory Outstanding (DIO): An efficiency metric calculated as 365 divided by inventory turnover, expressed in days.
FIFO: First-In, First-Out inventory accounting method; older costs flow to COGS first, newer costs remain in inventory.
LIFO: Last-In, First-Out method; newer costs flow to COGS first, older costs remain in inventory.
Working Capital: Current assets minus current liabilities; indicates short-term operating liquidity.
Cash Conversion Cycle: The time it takes to convert investments in inventory and other resources into cash from sales.
