How the DIO Calculator works
Days Inventory Outstanding (DIO) measures how long, on average, a company holds inventory before it is sold. It answers a simple operational question: given current stock levels and the pace of sales at cost, how many days of selling would it take to work through the goods currently on the shelf? DIO is one of the three components of the cash conversion cycle, alongside days sales outstanding and days payable outstanding.
The formula
The standard formula is:
DIO = (Average Inventory / Cost of Goods Sold) x Number of Days in Period
Average inventory is calculated as (beginning inventory + ending inventory) / 2, which smooths out timing distortions from a single snapshot balance. Cost of Goods Sold (COGS) is the total cost of the inventory sold during the period — not revenue — because DIO compares inventory (carried at cost) to the cost of what moved out the door. The period length is typically 365 days for an annual figure, 90 or 91 days for a quarter, or 30 days for a month.
Worked example
Suppose a company starts the year with $50,000 of inventory and ends with $60,000, for an average inventory of $55,000. Its cost of goods sold for the year is $400,000. Over a 365-day period:
DIO = ($55,000 / $400,000) x 365 ≈ 50.2 days
That means, on average, about 50 days pass between when inventory is acquired or produced and when it is sold. The same inputs give an inventory turnover ratio of $400,000 / $55,000 ≈ 7.27, meaning the company cycles through its average inventory roughly 7.3 times per year — turnover and DIO are two views of the same underlying pace.
What moves DIO
- Inventory levels: holding more stock relative to sales volume raises DIO; leaner stocking lowers it.
- Cost of goods sold: faster sales at cost (higher COGS for the same inventory) lowers DIO, since the same stock is worked through more quickly.
- Period length: the same average inventory and COGS produce a proportionally different DIO depending on whether you annualize (365 days) or use a shorter reporting period.
Reading the result
Lower DIO generally signals efficient inventory management and less cash tied up in unsold stock, but a DIO that is too low can also mean thin stock levels that risk running out of goods. Higher DIO ties up more working capital and raises exposure to obsolescence, spoilage, or markdown risk, but may be normal for businesses with long production or aging cycles. DIO should be compared against a company's own historical trend and against close industry peers, since typical values vary enormously between a grocery chain, a car dealership, and a wine producer.