What Is Days Inventory?
Days Inventory, also called Days Sales of Inventory (DSI) or days in inventory, measures how many days, on average, a company holds inventory before it is sold. It is a working capital efficiency metric that links the balance sheet to the income statement by comparing average inventory with Cost of Goods Sold.
In practical terms, Days Inventory answers a simple question: how long is cash tied up in inventory? A lower figure usually means inventory is moving faster, while a higher figure can suggest slower sales, excess stock, weaker demand or operational inefficiency. For businesses that carry meaningful inventory—such as retailers, manufacturers, wholesalers and consumer goods companies—this ratio is an important indicator of operating discipline and liquidity.
| Ticker | Company | Price | GF Score™ | days-inventory |
|---|---|---|---|---|
| - | ||||
| - | ||||
| - | ||||
| - | ||||
| - |
Days Inventory matters because inventory is one of the largest uses of working capital for many companies. If goods sit too long in warehouses or on store shelves, cash remains tied up, storage costs rise and the risk of markdowns, spoilage or obsolescence increases. On the other hand, inventory that turns too quickly can also create problems if the company cannot keep products in stock and loses sales.
At its core, the metric is the inverse of Inventory Turnover expressed in days. Rather than asking how many times inventory turns over during a period, Days Inventory asks how many days each turn takes.
The standard formula is:
- Days Inventory measures the average number of days a company holds inventory before selling it.
- It is calculated using average inventory, cost of goods sold and the number of days in the period.
- Lower Days Inventory often indicates faster inventory movement, but “better” always depends on the business model and industry.
- The metric is most useful when compared over time and against close peers.
- Seasonal patterns, accounting methods and product mix can materially affect the ratio.
- GuruFocus generally calculates Days Inventory using average total inventories divided by cost of goods sold, multiplied by days in period.
How Is Days Inventory Calculated?
The basic calculation uses average inventory rather than ending inventory, because inventory levels can fluctuate meaningfully during the year or quarter.
Average inventory is commonly calculated as:
For an annual period, the formula is typically:
For a quarterly period, the same logic applies, but the period length is shorter. GuruFocus historically presents quarterly Days Inventory by using average inventory for the quarter, dividing by quarterly cost of goods sold and multiplying by the days in the quarter, often expressed as 365/4 for simplicity.
Components of the formula
Average Total Inventories
This is the average inventory balance over the period. Using an average helps smooth temporary spikes or dips at period-end.
Cost of Goods Sold (COGS)
COGS is used instead of revenue because inventory is recorded at cost, not at selling price. Matching inventory to COGS makes the ratio more economically consistent.
Days in Period
This is usually 365 for annual data. For interim periods, analysts may use the actual number of days in the period or an approximation such as 365/4 for a quarter.
Relationship to inventory turnover
Days Inventory and inventory turnover are closely related:
That means a company with high inventory turnover will generally have low Days Inventory, and vice versa.
Formula variations
Some sources use ending inventory instead of average inventory, especially for quick calculations. Others may use sales instead of COGS, but that is less standard and can distort comparisons because sales include markup. For consistency, the most common and analytically sound version uses average inventory and COGS.1,2,3
Days Inventory Trend Over Time
Days Inventory is usually more informative as a trend than as a one-time snapshot. A stable or declining figure can indicate healthy demand, disciplined purchasing and efficient inventory management. A rising trend may suggest slowing sell-through, overproduction, weaker forecasting or a buildup of unsold goods.
Trend analysis is especially important for seasonal businesses. Retailers, for example, often build inventory ahead of holiday periods and then reduce it afterward. Because of that, comparing one quarter with the immediately preceding quarter can be misleading. In many cases, it makes more sense to compare the same fiscal quarter year over year.
What Does Days Inventory Tell You?
Days Inventory helps investors understand how efficiently a company converts inventory into sales. Since inventory ties up cash, the ratio offers insight into both operating efficiency and working capital quality.
A lower Days Inventory often suggests:
- faster inventory turnover,
- stronger demand,
- better purchasing and supply chain management,
- lower risk of obsolescence or markdowns.
A higher Days Inventory may suggest:
- slower sales,
- excess stock,
- weaker demand,
- poor forecasting,
- a shift toward slower-moving products.
That said, lower is not always better. Some companies intentionally hold more inventory to improve service levels, avoid stockouts or protect against supply chain disruptions. A premium manufacturer with long production cycles may also naturally report higher Days Inventory than a grocery chain or discount retailer.
Investors often use Days Inventory alongside other working capital metrics, especially:
- Inventory Turnover
- Days Sales Outstanding (DSO)
- Days Payable Outstanding (DPO)
- Cash Conversion Cycle (CCC)
Together, these measures show how quickly a company turns cash invested in operations back into cash collected from customers.
Limitations of Days Inventory
Like any ratio, Days Inventory has important limitations.
First, it is highly industry-specific. A supermarket should have much lower Days Inventory than an aerospace manufacturer, and a software company may have little or no inventory at all. Cross-industry comparisons are often not meaningful.
Second, the metric can be distorted by seasonality. Many businesses build inventory ahead of peak selling periods. Looking at a single quarter without context can lead to the wrong conclusion.
Third, accounting choices can affect comparability. Inventory valuation methods such as FIFO and LIFO can change reported inventory and COGS, especially during periods of inflation. That means two otherwise similar companies may report different Days Inventory partly because of accounting treatment rather than operational reality.4,5
Fourth, the ratio does not tell you why inventory changed. A higher figure could reflect weak demand, but it could also reflect a strategic inventory build ahead of a product launch, tariff change or supply chain disruption.
Fifth, Days Inventory can be less useful for businesses with minimal physical inventory, such as many service firms, software companies and asset-light platforms.
For these reasons, Days Inventory should usually be evaluated with peer comparisons, historical trends, management commentary and related metrics such as gross margin, inventory turnover and the cash conversion cycle.
Real-World Example
A useful way to understand Days Inventory is to compare businesses with very different inventory profiles.
Costco generally operates with relatively fast-moving inventory because it sells high volumes of everyday goods through a limited-SKU warehouse model. That kind of business tends to benefit from rapid sell-through, efficient replenishment and strong bargaining power with suppliers. Investors would usually expect a retailer like Costco to post comparatively low Days Inventory versus many other consumer businesses.
By contrast, Nike often carries a broader mix of seasonal products, style-driven merchandise and global channel inventory. Apparel and footwear companies can see inventory build when consumer demand softens, product cycles shift or wholesale partners reduce orders. In that setting, a rising Days Inventory figure can become an early warning sign that markdown pressure or margin compression may follow.
The point is not that one company is automatically “better” because it has lower Days Inventory. The point is that the metric reflects the economics of the business model. For a warehouse retailer, low Days Inventory is often central to the model. For a branded apparel company, the number may naturally be higher and more volatile.
FAQs
What is a good Days Inventory?
There is no universal benchmark. A good Days Inventory depends on the industry, product type and business model. Grocery and discount retailers usually have much lower figures than industrial manufacturers or luxury goods companies. The most useful comparison is against close peers and the company’s own historical range.
What is the difference between Days Inventory and related metrics?
Days Inventory measures how long inventory sits before being sold. Inventory Turnover measures how many times inventory is sold and replaced during a period. Days Sales Outstanding measures how long it takes to collect receivables, while Days Payable Outstanding measures how long the company takes to pay suppliers. Together, these metrics feed into the cash conversion cycle.
Can Days Inventory be negative?
Under normal circumstances, no. Inventory and COGS are generally positive, so Days Inventory should also be positive. If reported data produces a negative or nonsensical figure, it usually points to unusual accounting, data classification issues or a company that does not have a conventional inventory structure.
How should investors use Days Inventory?
Investors should use it as part of a broader working capital analysis. The best approach is to compare the ratio over time, against direct competitors and alongside gross margin, inventory turnover, receivables, payables and management commentary. A single number in isolation rarely tells the full story.
- PE Ratio - A stock's price divided by its earnings per share, the most widely used valuation multiple for comparing a stock's cost relative to its profits.
- PB Ratio - A stock's price divided by its book value per share, measuring how much investors are paying for each dollar of net assets.
- PS Ratio - A stock's price divided by its revenue per share, useful for valuing companies with low or negative earnings.
- Price-to-Free-Cash-Flow - A stock's price divided by free cash flow per share, a popular alternative to the PE ratio that focuses on real cash generation.
- ROE % - Net income divided by shareholders' equity, measuring how efficiently a company generates profit from the money shareholders have invested.
- ROIC % - Net operating profit after tax divided by invested capital, measuring how effectively a company deploys its capital to generate returns.
Summary
Days Inventory is a simple but useful measure of how long a company holds inventory before selling it. Because inventory ties up cash and carries risks such as spoilage, obsolescence and markdowns, the ratio can reveal a great deal about operating efficiency and working capital management.
Still, the metric is not one-size-fits-all. A low figure can be a sign of strength, but only in the right context. Industry structure, seasonality, accounting methods and business strategy all matter. For that reason, Days Inventory is most powerful when used as part of a broader analysis rather than as a standalone judgment.
Sources
- U.S. Securities and Exchange Commission, “Inventory” — https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins-6
- Investopedia, “Days Sales of Inventory (DSI): Definition, Formula, Importance” — https://www.investopedia.com/terms/d/dsi.asp
- Corporate Finance Institute, “Days Inventory Outstanding (DIO)” — https://corporatefinanceinstitute.com/resources/accounting/days-inventory-outstanding-dio/
- Financial Accounting Standards Board, “Inventory (Topic 330)” — https://asc.fasb.org/topic&trid=2127424
- IAS 2 Inventories, IFRS Accounting Standards — https://www.ifrs.org/issued-standards/list-of-standards/ias-2-inventories/
- Wall Street Prep, “Days Inventory Outstanding (DIO)” — https://www.wallstreetprep.com/knowledge/days-inventory-outstanding-dio/
- AccountingTools, “Days in Inventory Formula” — https://www.accountingtools.com/articles/days-in-inventory-formula
- GuruFocus, Costco summary page — https://www.gurufocus.com/stock/COST/summary
- GuruFocus, Nike summary page — https://www.gurufocus.com/stock/NKE/summary