Direct Answer
Days Inventory Outstanding (DIO) is the average number of days inventory sits before it's sold, calculated as inventory divided by cost of goods sold, multiplied by the days in the period. A low DIO generally means faster inventory turnover; a rising DIO deserves scrutiny but is not by itself proof of a problem, and DIO is only meaningful when compared against a company's own history and against peers with a similar product and manufacturing profile.
What Is Days Inventory Outstanding (DIO)?
Days Inventory Outstanding measures how long, on average, a company's cash stays tied up in raw materials, work in process, and finished goods before that inventory converts into a sale. A company can report healthy revenue while quietly building inventory faster than it can sell it - DIO is the metric that surfaces that gap.
The formula, exactly as implemented in Swoopr's working-capital module:
DIO = (Inventory ÷ Cost of Goods Sold) × Days in Period
Most published DIO figures use a 365-day annual period even when the underlying inventory and COGS figures come from a single quarter, in which case quarterly COGS should first be annualized (or the day count set to roughly 91) so the units line up. Average inventory - the mean of the beginning and ending balance - is preferable to a single ending balance, which can be distorted by a large shipment received or sold right at period-end.
Worked Example
A hypothetical company reports $80 million of inventory and $400 million of annual cost of goods sold.
| Input | Value |
|---|---|
| Inventory | $80,000,000 |
| Cost of goods sold | $400,000,000 |
| Days in period | 365 |
| DIO | (80 ÷ 400) × 365 = 73 days |
This hypothetical company holds inventory for about 73 days on average before it's sold. On its own that number says little - it becomes useful once compared against this same company's DIO from a year ago, and against direct peers with a similar product mix and manufacturing process.
What Is Inventory Turnover?
Inventory turnover is the inverse framing of the same relationship: instead of measuring how many days inventory sits, it measures how many times per year a company sells through and replaces its inventory balance.
Inventory turnover = Cost of Goods Sold ÷ Average Inventory
Using the same hypothetical inputs but an $80 million average inventory balance and $400 million of cost of goods sold, inventory turnover is 400 ÷ 80 = 5× - the company sells through and replaces its full inventory balance roughly five times a year. Turnover and DIO should agree with each other: 365 ÷ 5 turns ≈ 73 days, matching the DIO figure above. Retail and consumer-goods analysts tend to favor turnover, since it's a familiar merchandising metric, while DIO reads naturally alongside a cash-conversion-cycle day count.
Why Does a Rising DIO Deserve Scrutiny?
A DIO that climbs quarter over quarter, or that grows meaningfully faster than cost of goods sold, is a prompt to ask why - not a verdict on its own. Several explanations are common, and they are not mutually exclusive:
- Slowing demand. If products aren't selling as quickly as forecast, unsold inventory accumulates on the balance sheet even while production continues at the prior pace.
- Overproduction. A company that builds ahead of an anticipated supply constraint, component shortage, or new product launch can see DIO rise even while customer demand stays healthy - the increase reflects a deliberate operating choice, not necessarily weakness.
- Inventory obsolescence risk. Inventory that sits longer has more time to fall out of fashion, become technologically outdated, or expire, which raises the odds that some of it eventually gets written down rather than sold at full value.
- Product mix or transition effects. A shift toward products with longer manufacturing lead times, or a transition between product generations that leaves old-generation stock unsold, can mechanically raise DIO without reflecting weaker demand for the business as a whole.
The right response is to treat a rising DIO as a research question: read the inventory footnote for any reserve or write-down commentary, check whether revenue growth and inventory growth are moving at similar rates, and see whether management addresses inventory positioning on the earnings call. A DIO increase that tracks a disclosed, deliberate inventory build ahead of a supply constraint reads very differently from one that appears alongside slowing sales and rising promotional activity.
Why Does DIO Vary So Much by Industry?
DIO is a function of a company's product type and manufacturing cycle, not just how well it manages inventory. A cross-industry comparison can be misleading even when both companies are managing inventory responsibly.
| Business model | Typical DIO pattern | Why |
|---|---|---|
| Grocery retail, perishable goods | Days to a few weeks | Perishability and high sales velocity force rapid turnover; holding inventory longer means spoilage losses. |
| Apparel and consumer electronics | Roughly 30-90 days | Seasonal collections and product cycles require inventory to sell through before it becomes stale or discounted. |
| Aircraft and heavy-equipment manufacturing | Many months | Long production cycles, custom configurations, and work-in-process inventory held through a multi-stage build are a normal part of the business, not a warning sign. |
Comparing a grocery retailer's near-instant turnover against an aircraft manufacturer's multi-month DIO says nothing about which company manages inventory better - it mostly describes what they build and how long that takes. A useful comparison set holds the product type and production cycle roughly constant: compare the manufacturer against other manufacturers with a similar build cycle, and track each company's own DIO trend over time as the more reliable signal.
How Does DIO Connect to Inventory Write-Down Risk?
Inventory is carried on the balance sheet at cost, generally the lower of cost or net realizable value. The longer inventory sits unsold, the more time it has to lose value relative to that carrying cost - through obsolescence, expiration, falling out of season, or a competitor's newer product making it less desirable.
A persistently rising DIO is one input into assessing that risk: it suggests a growing share of inventory may be capitalized at a cost the company will not fully recover when it eventually sells. That's not proof a write-down is coming - management may have a credible plan to sell through the excess at a modest discount - but it's a reason to check the inventory reserve and impairment disclosures in the filing footnotes, and to watch whether gross margin comes under later pressure from markdowns needed to clear the backlog.
Common Misconceptions About DIO
| Misconception | Reality |
|---|---|
| "Lower DIO is always better" | A DIO that's too low relative to peers can also mean a company is running lean enough to risk stockouts and lost sales during a demand spike. |
| "A rising DIO means the company can't sell its products" | Rising DIO is a research question with several benign explanations - a deliberate build ahead of a supply constraint, new product launches, seasonal timing - not an automatic demand red flag. |
| "DIO can be compared across any two companies" | DIO is driven heavily by product type and production cycle length; only compare companies with a similar business model and manufacturing profile. |
| "Ending inventory is fine to use instead of average inventory" | An ending balance can be skewed by a shipment received or shipped right at period-end; average inventory smooths that distortion out. |
Frequently Asked Questions
What is a good DIO?
There is no universal good DIO - it depends entirely on the industry and business model. A grocery retailer selling perishable goods can turn inventory in a matter of days, while an aircraft or heavy-equipment manufacturer can carry work-in-process inventory for months as a normal part of its production cycle. Judge DIO against the company's own history and against direct peers with a similar product and manufacturing profile.
Does a rising DIO always mean a company is in trouble?
No. A rising DIO is a research question, not a verdict. It can reflect slowing demand, deliberate overproduction ahead of an expected constraint, a strategic decision to build safety stock, or a genuine risk of inventory obsolescence. The explanation matters more than the direction of the change, which requires reading the inventory footnote and management commentary rather than the ratio alone.
What is the difference between DIO and inventory turnover?
They are inverse framings of the same underlying relationship between inventory and cost of goods sold. DIO expresses how many days inventory sits before being sold - lower is generally faster. Inventory turnover expresses how many times per year inventory is sold and replaced - higher is generally faster. Dividing the day count in the period by inventory turnover should return roughly the DIO figure, since both describe the same inventory cycle.
How does rising DIO connect to inventory write-down risk?
Inventory sitting longer before sale has more time to become obsolete, go out of season, or lose value relative to its carrying cost on the balance sheet. If a company is capitalizing inventory it may never sell at full value, a rising DIO can be an early signal that a future write-down or impairment charge is more likely, though it is not proof one is coming.
How does the inventory costing method affect turnover comparisons?
Different costing methods assign different costs to goods sold and to remaining inventory, so during periods of changing prices two companies with identical physical inventory report different values and therefore different turnover. Companies using a method that produces lower reported inventory values disclose the difference, which allows adjustment. Without it, cross-company turnover comparisons partly measure the accounting policy.
What does the composition of inventory reveal that the total does not?
The inventory footnote generally splits the balance between raw materials, work in progress, and finished goods. Finished goods rising faster than the total suggests production outpacing sales, while raw materials rising ahead of the others suggests anticipated demand or supply concerns. The direction of the build carries different implications, which the aggregate figure hides.
How do write-downs affect the turnover measure?
A write-down reduces the inventory balance and increases cost of sales, which improves turnover in the period it occurs. The improvement reflects a loss rather than efficiency. A turnover figure that improves sharply in a period containing a large write-down should be read with that in mind, since the underlying inventory situation deteriorated rather than improved.
Why does turnover differ so much between businesses selling similar products?
Assortment breadth, service levels, and distribution structure all drive inventory requirements independently of demand. A company holding wide assortment to guarantee availability accepts lower turnover in exchange for fewer lost sales. Turnover therefore reflects a strategic choice about service level as much as operational efficiency, which is why the highest turnover in an industry is not automatically the best position.
How should turnover be assessed for a company with long production lead times?
Long lead times structurally require holding more inventory, so a low turnover figure describes the production process rather than management performance. The more informative comparison is against the company's own history and against the lead times themselves, since inventory rising while lead times are unchanged indicates something has shifted. Absolute turnover levels across industries measure the manufacturing model.