Days Inventory Outstanding (DIO) Calculator
Calculate Days Inventory Outstanding (DIO), also called Days Sales of Inventory, to measure how many days on average a company holds inventory before selling it. Lower DIO generally signals efficient inventory management.
How to use this tool
- Enter average inventory, cost of goods sold (cogs) and period length in the fields above.
- Results update instantly as you type — or click Calculate.
- Read your days inventory outstanding and the full breakdown beneath it.
⚠ This tool provides general estimates for education only and is not financial, tax or legal advice. Figures may not reflect your situation — verify with a qualified professional.
Formula
DIO = (Average Inventory ÷ COGS) × Number of Days
Equivalently: DIO = Days ÷ Inventory Turnover Ratio, where Inventory Turnover = COGS ÷ Average Inventory.
How it works
Days Inventory Outstanding measures the average number of days a company holds inventory before it is sold, using Cost of Goods Sold as the cost basis. It is a component of the Cash Conversion Cycle (CCC) alongside DSO and DPO. A lower DIO indicates inventory moves quickly, which generally reduces holding costs and spoilage risk, though the ideal level varies by industry.
Worked example
Retail Company Inventory Efficiency
- A retailer reports average inventory of $50,000 and annual COGS of $300,000 (365-day year).
- Apply the formula: DIO = (Inventory ÷ COGS) × Days = (50,000 ÷ 300,000) × 365.
- Fraction: 50,000 ÷ 300,000 = 0.16667.
- Multiply: 0.16667 × 365 = 60.83 days.
The DIO is 60.83 days, meaning inventory turns over approximately every 61 days.
Common mistakes to avoid
- Using total revenue instead of COGS in the denominator, understating DIO because revenue includes markup -- inventory is carried at cost, making COGS the correct base.
- Using ending inventory rather than average inventory (beginning + ending / 2), which distorts DIO in periods when inventory levels change significantly.
- Using 360 days for one calculation and 365 for another when comparing periods or companies, creating non-comparable results.
Key terms
- What does DIO measure?
- DIO measures the average number of days a company keeps inventory on hand before converting it to sales revenue.
- Is a lower DIO always better?
- Generally yes — lower DIO means faster inventory turnover and less capital tied up — but too low can indicate stock-outs. The optimal level depends on industry norms and lead times.
- How does DIO relate to the Cash Conversion Cycle?
- CCC = DIO + DSO − DPO. DIO is the first stage, representing the time from purchasing inventory to selling it.
- Should I use beginning, ending, or average inventory?
- Average inventory (beginning + ending ÷ 2) is preferred as it smooths seasonal fluctuations, but some analysts use ending inventory for simplicity.
Frequently asked questions
- Is a lower DIO always better?
- Generally yes -- lower DIO means faster turnover and less capital tied up in stock. However, extremely low DIO can signal stockout risk. The optimal DIO balances carrying costs against the risk of running out during lead time.
- How is DIO related to inventory turnover?
- DIO = Days / Inventory Turnover, and Inventory Turnover = COGS / Average Inventory. A turnover of 6 on a 360-day basis equals a DIO of 60 days.
- How does DIO fit into the cash conversion cycle?
- CCC = DIO + DSO - DPO. DIO measures how long cash is tied up in inventory before a sale. Reducing DIO shortens the CCC and improves working capital efficiency.