Working capital · Inventory management
Days Inventory Outstanding (DIO): Formula, Calculation & Benchmarks
Days inventory outstanding tells you how many days of inventory a company carries on average before turning it into a sale. Walmart runs about 45 days; a pharmaceutical company might hold 150. DIO is the first leg of the cash conversion cycle — the longer inventory sits, the longer cash is locked up in the supply chain. This guide covers the DIO formula, Walmart’s FY2024 worked example, sector benchmarks, and what high versus low DIO actually means for a business.
Days inventory outstanding (DIO) measures the average number of days a company holds inventory before selling it. Formula: DIO = (Inventory / Cost of Revenue) × 365. A lower DIO means faster inventory turns and less capital tied up in stock; a higher DIO may signal slow-moving products or deliberate buffer-stocking.
The DIO Formula Explained
DIO converts the inventory balance into a days metric by measuring it relative to the cost of revenue run rate. The standard annual formula divides ending (or average) inventory by cost of goods sold and multiplies by 365. Some analysts use average inventory (beginning plus ending divided by two) to smooth period-end fluctuations from large seasonal builds or draw-downs.
| Variant | Formula | When to Use |
|---|---|---|
| Ending inventory | (Inventory ÷ COGS) × 365 | Default for most public company comparisons |
| Average inventory | ((Inv₀ + Inv₁) / 2 ÷ COGS) × 365 | Smooths seasonal inventory swings |
| Quarterly | (Inventory ÷ Quarterly COGS) × 90 | Tracking trend within a fiscal year |
Most analysts use year-end inventory in the numerator because it is directly available from the balance sheet without adjustments. Using average inventory produces a more conservative estimate and is preferred when a company has pronounced seasonal patterns — a retailer that builds inventory heavily before the holiday quarter will show artificially high DIO if only the year-end balance is used. For trend analysis, pick one method and apply it consistently across all periods being compared.
Worked Example: Walmart (WMT) FY2024
Walmart is a benchmark case for retail inventory efficiency. As the world’s largest retailer by revenue, Walmart’s supply chain is designed around rapid inventory velocity — keeping shelves stocked while minimizing the capital tied up in backroom inventory. Its DIO reflects the operational discipline that separates it from less efficient peers.
Step 1: Gather balance sheet and income statement inputs (FY2024)
- Inventory (year-end)
- $54.9B
- Cost of revenue
- $446.0B
Step 2: Calculate DIO
- DIO ($54.9B ÷ $446.0B × 365)
- 44.9 days
Walmart turns its inventory roughly every 45 days — a reflection of its high-velocity grocery and consumables mix and its legendary supply chain efficiency. For context, Amazon’s DIO runs approximately 30–35 days (driven by its marketplace and fulfillment-center model), while Target’s DIO sits around 55–60 days (more discretionary merchandise, slower turns). The difference between 45 days and 60 days at Walmart’s scale represents tens of billions of dollars in working capital: a 15-day DIO reduction on $446B in COGS frees roughly $18B in cash. That is why inventory turns are a central operational KPI for every large retailer.
DIO by Industry — Benchmark Ranges
DIO varies significantly by industry based on the nature of the product, supply chain length, and demand predictability. Perishable goods force fast turns; regulated industries carry large safety stocks. Always compare within sector.
| Sector | Typical DIO Range | Key Driver |
|---|---|---|
| Grocery / Mass Retail | 20–45 days | High-velocity SKUs; perishable products force fast turns |
| Apparel Retail | 60–120 days | Seasonal collections; long lead times from overseas factories |
| Automotive Dealers | 30–60 days | High per-unit value; floor plan financing drives turn pressure |
| Consumer Electronics | 25–50 days | Short product cycles; obsolescence risk penalizes slow movers |
| Pharmaceuticals | 90–180 days | Regulatory safety stocks; long production and testing timelines |
| Manufacturing | 40–80 days | Raw material + WIP + finished goods across production stages |
| Food & Beverage | 15–45 days | Perishability and shelf-life constraints drive fast movement |
| Software / SaaS | N/A | No physical inventory; DIO is not applicable |
DIO as the First Leg of the Cash Conversion Cycle
DIO is the opening component of the cash conversion cycle. The full formula is: CCC = DIO + DSO − DPO. DIO measures how long cash is locked up in inventory before a sale occurs; DSO measures how long cash is locked in receivables after the sale; DPO measures how long the company delays paying its own suppliers. A company shortens its cash conversion cycle by reducing DIO, reducing DSO, or extending DPO — all three levers work together to minimize the time between spending cash on inventory and recovering it from customers.
| Component | Measures | Effect on CCC |
|---|---|---|
| DIO | Days inventory is held before sale | Higher DIO = longer cycle (unfavorable) |
| DSO | Days until customers pay after sale | Higher DSO = longer cycle (unfavorable) |
| DPO | Days until suppliers are paid | Higher DPO = shorter cycle (favorable) |
What Is a Good DIO?
There is no universal target for DIO — a 45-day DIO is excellent for a pharmaceutical company and alarming for a fresh-food retailer. The practical framework is threefold: compare to sector peers, compare to the company’s own history, and consider the direction of the trend.
- Lower DIO generally means less capital at risk. A company with 30-day DIO is converting its inventory investment into cash four times as fast as a peer with 120-day DIO. That speed compounds: every freed dollar can be redeployed into more inventory cycles per year, improving return on invested capital without requiring additional equity or debt.
- Too low can mean stockout risk. Just-in-time inventory management reduces DIO but leaves no buffer when supply chains are disrupted. The COVID-era shortages of 2020–2021 penalized companies with minimal safety stocks. A DIO that falls sharply below the peer group warrants questions about whether the company is running lean by design or by necessity.
- Industry context is non-negotiable. Comparing Walmart’s 45-day DIO to a specialty pharmaceutical company’s 150-day DIO tells you nothing useful. Sector-adjusted peer comparisons are the only valid benchmark for DIO assessment.
High DIO vs. Low DIO: What Each Signals
A rising or persistently high DIO is one of the earliest operational warning signs in financial analysis. A falling DIO is typically positive — but the context matters.
- High DIO warning: slow-moving product. If DIO is rising while revenue growth is slowing, the most likely cause is weakening demand. Products are sitting longer on shelves or in warehouses because customers are buying less. This often precedes inventory write-downs, which hit gross margins directly.
- High DIO warning: overstocking. Procurement teams that order ahead of demand projections can build inventory faster than sales absorb it. This shows up as rising raw-material or finished-goods inventory relative to revenue. Cross-reference with management guidance on supply chain strategy.
- High DIO warning: obsolescence risk. Consumer electronics, fashion, and technology hardware face product cycles of 12–24 months. Inventory that ages beyond one cycle risks becoming unsellable at full margin — companies may need deep discounts or write-offs. Rising DIO in obsolescence-prone industries is a red flag.
- Low DIO signal: lean operations. A DIO below the sector average sustained over multiple years typically reflects genuine operational excellence — sophisticated demand forecasting, strong supplier relationships, and logistics discipline. Walmart and Amazon represent this end of the spectrum.
- Low DIO signal: just-in-time risk. Companies relying heavily on just-in-time delivery have minimal inventory buffers. This can mask supply chain fragility. Investors should ask whether a low DIO comes with appropriate supplier diversification and backup sourcing options.