Inventory Ratios: Turnover, Days Inventory, and COGS Analysis Worked
Inventory turnover, days inventory outstanding (DIO), and the inventory-to-COGS relationship are core operating efficiency metrics. This guide walks through the formulas with 5 worked examples, explains how the ratios change with industry and business model, and shows how to read inventory red flags on financial statements.
What You'll Learn
- ✓Calculate inventory turnover and days inventory outstanding (DIO)
- ✓Distinguish average inventory vs ending inventory in the formula
- ✓Read inventory red flags (rising DIO, write-downs, obsolescence)
- ✓Compare inventory ratios across industries with realistic benchmarks
- ✓Connect inventory ratios to the cash conversion cycle
1. Direct Answer: The Two Core Formulas
Inventory Turnover = Cost of Goods Sold / Average Inventory. This tells you how many times the company's inventory was sold and replaced during the period. Days Inventory Outstanding (DIO) = 365 / Inventory Turnover (or equivalently, Average Inventory / COGS × 365). DIO tells you the average number of days inventory sits before being sold. Higher turnover (lower DIO) generally signals operating efficiency; rising DIO across periods can signal slowing demand, obsolescence, or excess buying. Industry context matters enormously: grocery (turnover 12-20x, DIO 18-30 days) is very different from heavy machinery (turnover 1-3x, DIO 120-365 days).
Key Points
- •Inventory Turnover = COGS / Average Inventory
- •Days Inventory Outstanding (DIO) = 365 / Turnover or (Avg Inventory / COGS) × 365
- •Average inventory = (Beginning + Ending) / 2
- •Higher turnover = more efficient (typically); rising DIO is a red flag
- •Industry benchmarks: grocery 12-20x turnover, retail 6-10x, manufacturing 4-8x, heavy machinery 1-3x
2. Worked Example 1: Retail Company
Target Corp 2024 financials: COGS $80B, beginning inventory $13B, ending inventory $14B. Average inventory = (13 + 14) / 2 = $13.5B Inventory Turnover = 80 / 13.5 = 5.93x DIO = 365 / 5.93 = 61.5 days Interpretation: Target turns its inventory roughly 6 times per year, with average shelf time of 61 days. Compared to Costco (turnover ~12x, DIO ~30 days), Target carries roughly twice the inventory days. This reflects different business models — Costco's smaller SKU count and warehouse-style merchandising support faster turnover than Target's broader assortment.
Key Points
- •Average inventory uses both beginning and ending balances
- •Retail turnover varies widely by format (warehouse 10-15x, dept store 3-5x)
- •Higher turnover doesn't always mean better — depends on margin and gross profit dollars
- •Compare within same retail format for meaningful benchmarks
3. Worked Example 2: Rising DIO as a Red Flag
Company X reports five years of inventory and COGS: Year 1: COGS $100M, ending inventory $20M, DIO ~73 days Year 2: COGS $110M, ending inventory $25M, DIO ~83 days Year 3: COGS $115M, ending inventory $32M, DIO ~102 days Year 4: COGS $118M, ending inventory $38M, DIO ~118 days Year 5: COGS $120M, ending inventory $45M, DIO ~137 days DIO rising from 73 to 137 days while COGS growth is decelerating signals one or more problems: (1) demand slowing but production unchanged, (2) inventory obsolescence — old inventory accumulating that cannot be sold at full price, (3) push from competition reducing inventory turnover, (4) deliberate inventory build for upcoming demand (the benign case). Look at the inventory note for write-downs, obsolescence reserves, and inventory by category to determine which.
Key Points
- •Rising DIO with flat or slowing COGS growth is a structural red flag
- •Could indicate: slowing demand, obsolescence, competition, or deliberate build (less common)
- •Always check inventory write-downs and obsolescence reserves in the footnotes
- •Year-over-year DIO change is more informative than the absolute level
4. Worked Example 3: Inventory Composition Matters
Two manufacturers have identical $50M ending inventory and identical 90-day DIO. Manufacturer A: $5M raw materials, $5M WIP (work in progress), $40M finished goods. Manufacturer B: $30M raw materials, $15M WIP, $5M finished goods. Manufacturer A's $40M finished goods may suggest demand softening — finished products are stacking up unsold. Manufacturer B's heavy raw materials and WIP may suggest a production ramp for upcoming demand or supply chain hedging against shortage. The identical DIO masks very different operational situations. Always look at inventory composition (the breakdown is required in U.S. GAAP filings, footnoted) before drawing conclusions about a company's inventory position.
Key Points
- •DIO alone is incomplete — the COMPOSITION of inventory matters
- •High finished goods → potential demand weakness
- •High raw materials/WIP → potential ramp or supply hedging
- •10-K filings (US GAAP) require inventory composition breakdown in footnotes
5. Worked Example 4: Connecting to Cash Conversion Cycle
The cash conversion cycle (CCC) measures the days between paying suppliers and collecting from customers: CCC = DIO + DSO − DPO Where DSO is days sales outstanding (receivables collection time) and DPO is days payable outstanding (supplier payment time). Worked example: a manufacturer with DIO = 60 days, DSO = 45 days, DPO = 35 days has CCC = 60 + 45 − 35 = 70 days. The company's working capital is tied up for 70 days on average — funded by either cash on hand or short-term debt. Reducing DIO from 60 to 40 days (through better inventory management) reduces CCC by 20 days. For a $100M revenue company, that's roughly $5.5M of working capital freed up — meaningful liquidity improvement. This is why supply chain and inventory optimization are major focus areas for CFOs and operations leaders.
Key Points
- •Cash Conversion Cycle = DIO + DSO − DPO
- •Inventory reduction directly reduces CCC and frees working capital
- •20-day DIO reduction on $100M revenue company frees ~$5.5M working capital
- •Supply chain optimization is a recurring CFO priority for this reason
- •Negative CCC (cash before payment to suppliers) is the dream — Amazon achieved this for years
6. Industry Benchmarks (US 2024)
Approximate inventory ratios by industry: • Grocery / supermarket: turnover 12-20x, DIO 18-30 days. High volume, low margin, perishables. • Apparel retail: turnover 4-6x, DIO 60-90 days. Seasonal cycles, fashion risk. • Discount retail (Walmart, Target): turnover 6-10x, DIO 36-60 days. • Warehouse club (Costco): turnover 10-13x, DIO 28-36 days. Limited SKU count enables faster turn. • Auto dealership: turnover 8-12x for new vehicles, 4-8x for used vehicles, DIO 30-90 days. • Heavy industrial / capital equipment: turnover 1-3x, DIO 120-365 days. Long production cycles. • Pharmaceutical: turnover 1-3x, DIO 120-365 days. Long shelf life, regulatory considerations. • Restaurant chains: turnover 30-50x, DIO 7-15 days. Fresh ingredients, daily/weekly turn. • Tech hardware (e.g., Apple): turnover 8-12x, DIO 30-45 days. Tight inventory management with global supply chain. Benchmarking against the right peer set is critical. Compare grocery to grocery, not grocery to industrial machinery.
Key Points
- •Industry context drives huge variance — grocery 12-20x vs heavy machinery 1-3x
- •Always benchmark against direct peers, not cross-industry
- •Trends within a company vs prior years are often more informative than absolute level
- •Outliers in either direction warrant investigation (too low = stockouts; too high = obsolescence)
Key Takeaways
- ★Inventory Turnover = COGS / Average Inventory; DIO = 365 / Turnover
- ★Average inventory uses (Beginning + Ending) / 2
- ★Rising DIO with slowing COGS growth is a structural red flag (demand or obsolescence)
- ★Inventory composition (raw materials, WIP, finished goods) tells more than DIO alone
- ★Cash Conversion Cycle = DIO + DSO − DPO; inventory reduction directly improves working capital
- ★Industry benchmarks vary 10x: grocery turnover 15x vs industrial machinery 2x
Practice Questions
1. Company X has COGS of $200M, beginning inventory $25M, ending inventory $35M. Calculate inventory turnover and DIO.
2. A retailer reports inventory turnover declined from 8.5x to 6.2x year-over-year while revenue grew 12%. What questions should this raise?
3. A company has DIO = 75 days, DSO = 30 days, DPO = 50 days. Calculate the Cash Conversion Cycle.
FAQs
Common questions about this topic
Use AVERAGE inventory ((Beginning + Ending) / 2) for the most accurate calculation. Some quick analyses use ending inventory only, which works for stable companies but distorts the ratio for companies with seasonal inventory or growth. For seasonal businesses, quarterly or monthly average inventory provides even better accuracy.
Retail sells finished goods to consumers immediately; the inventory cycle is fast. Manufacturing converts raw materials into finished goods over weeks or months (production cycle), then sells to retailers or end customers (sales cycle). Both legs of the cycle add to inventory days. Heavy industrial machinery can have multi-year production cycles, producing single-digit turnover.
Industry-dependent. The right comparison is to direct peers and the company's own historical performance. A grocery chain with turnover of 5x has a problem (peers are 12-20x); an industrial equipment manufacturer with turnover of 5x is performing very well (peers are 1-3x). Always benchmark within the right industry segment.
A write-down reduces ending inventory and creates a one-time charge to COGS (or a separate impairment line). This temporarily INCREASES turnover (lower denominator, higher numerator). Watch for these one-time effects when analyzing — a sudden turnover improvement may reflect a write-down rather than operational improvement. Read the footnotes.
Same metric, different name. 'Days of supply' is more common in operations and supply chain contexts; 'days inventory outstanding (DIO)' or 'days inventory on hand' is more common in financial analysis. All three describe how many days of forward sales the inventory represents.
Yes. Provide the company's financial statements and FinanceIQ calculates inventory turnover, DIO, and the cash conversion cycle, benchmarks against industry peers, identifies year-over-year trends, and flags inventory composition concerns from the footnotes. Especially useful for retail, manufacturing, and consumer goods analyses where inventory management is a primary operational lever. This content is for educational purposes only and does not constitute financial advice.