Days Sales of Inventory (DSI)
What Is Days Sales of Inventory?
Days Sales of Inventory (DSI) is a financial ratio that measures the average number of days it takes for a company to convert its inventory into sales. Also known as the "Average Age of Inventory," it is a key metric for assessing inventory management efficiency and liquidity.
Inventory is cash sitting on a shelf. Until it is sold, it generates no revenue but incurs storage costs, insurance, and the risk of going bad (obsolescence). Days Sales of Inventory (DSI) tells investors exactly how long that cash is trapped. DSI is an efficiency ratio. It answers the question: "If we stopped buying new inventory today, how many days would it take to sell everything we have?" For a supermarket selling perishable goods, this number should be very low (days). For a luxury watchmaker, it might be very high (months or years). Investors use DSI to spot operational problems. If a company's sales are flat but its DSI is rising, it means inventory is piling up faster than it can be sold. This is often a leading indicator of future markdowns, lower margins, and cash flow problems.
Key Takeaways
- DSI calculates how long cash is tied up in inventory.
- Formula: (Average Inventory / Cost of Goods Sold) x 365.
- A lower DSI indicates efficient inventory management and higher liquidity.
- A high DSI suggests slow sales, excess stock, or potential obsolescence.
- DSI varies significantly by industry (e.g., grocery stores vs. airplane manufacturers).
- It is a component of the Cash Conversion Cycle (CCC).
The Formula
DSI = (Average Inventory / Cost of Goods Sold) × 365
Interpreting the Ratio
Low DSI (Good): The company is turning over its inventory quickly. It implies strong demand and efficient supply chain management. Cash is freed up rapidly to be reinvested. High DSI (Bad): The company is struggling to sell its products. It may be overproducing or facing weak demand. This ties up working capital and increases storage costs. Too Low DSI (Risk): If DSI is *too* low, the company might be running out of stock frequently (stockouts), leading to lost sales and unhappy customers.
Real-World Example: Retail Giants
Comparing Walmart (WMT) vs. Tiffany & Co. (TIF - historically).
FAQs
There is no universal number. A grocery store aims for <10 days (perishables). A car dealer might aim for 45-60 days. A heavy machinery maker might be 100+ days. You must compare a company against its direct competitors and its own historical trend.
DSI is the first part of the cycle. Cash Conversion Cycle = DSI + DSO (Days Sales Outstanding) - DPO (Days Payable Outstanding). It measures the total time from spending cash on inventory to receiving cash from customers.
Yes. A company can artificially lower DSI at the end of a quarter by offering massive discounts to clear inventory ("channel stuffing") or delaying new purchases. Always look at the trend over multiple quarters.
Inventory levels fluctuate. Using just the ending balance can be misleading if the company builds up stock for holidays (Q4). Averaging the beginning and ending inventory for the period smooths out seasonality.
You can use "Sales" instead of COGS, but this inflates the ratio because Sales includes profit margin while Inventory is valued at cost. Always use COGS for accuracy if possible.
The Bottom Line
Days Sales of Inventory is a vital pulse check on a company's operational efficiency. It reveals whether management is effectively balancing supply with demand. For investors, a rising DSI is a red flag signaling potential trouble ahead—bloated warehouses, future writedowns, and cash flow strain. Conversely, a stable or falling DSI in a growing company is a hallmark of operational excellence.
More in Financial Statements
At a Glance
Key Takeaways
- DSI calculates how long cash is tied up in inventory.
- Formula: (Average Inventory / Cost of Goods Sold) x 365.
- A lower DSI indicates efficient inventory management and higher liquidity.
- A high DSI suggests slow sales, excess stock, or potential obsolescence.