DIO Calculator

Calculate days inventory outstanding to measure how long inventory takes to sell.

Cost of Goods Sold (COGS) Beginning Inventory Ending Inventory Days in Period

What Is Days Inventory Outstanding (DIO)?

Days Inventory Outstanding (DIO) is a financial metric that measures the average number of days a company holds inventory before selling it. It is a key efficiency ratio used in working capital management and inventory analysis. A lower DIO generally indicates faster inventory turnover, while a higher DIO may suggest overstocking or slower sales.

DIO is also referred to as Days Sales of Inventory (DSI) or Days in Inventory. It is commonly used alongside Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO) to assess the full cash conversion cycle.

How DIO Is Calculated

The standard formula for Days Inventory Outstanding is:

DIO = (Average Inventory ÷ Cost of Goods Sold) × Number of Days

Where:

Average Inventory is the mean value of inventory over a period, typically calculated as (Beginning Inventory + Ending Inventory) ÷ 2.
Cost of Goods Sold (COGS) represents the direct costs attributable to the production of goods sold during the period.
Number of Days is the length of the period being analyzed, commonly 365 days for an annual calculation or 90 days for a quarterly view.

The result tells you how many days, on average, inventory sits before being sold. This calculation assumes a consistent rate of inventory consumption and does not account for seasonal fluctuations unless the period is adjusted accordingly.

How to Use the DIO Calculator

Enter your average inventory value. If you have beginning and ending inventory figures, add them together and divide by two to get the average.
Enter your Cost of Goods Sold (COGS). This figure is typically found on your income statement for the same period.
Select the number of days. Use 365 for an annual calculation, 90 for a quarter, or 30 for a month depending on your reporting period.
Review the result. The calculator will output the average number of days your inventory is held before being sold.

Example Calculation

A retail company has the following figures for the fiscal year:

Beginning Inventory: $200,000
Ending Inventory: $300,000
Cost of Goods Sold: $1,000,000
Period: 365 days

Average Inventory = ($200,000 + $300,000) ÷ 2 = $250,000

DIO = ($250,000 ÷ $1,000,000) × 365 = 91.25 days

This means the company holds its inventory for approximately 91 days on average before selling it. Whether this is efficient depends on the industry benchmark and the nature of the products being sold.

Interpreting Your DIO Result

DIO should always be evaluated in context. A single number without comparison provides limited insight.

Low DIO suggests inventory moves quickly, which reduces holding costs and the risk of obsolescence. However, an extremely low DIO may indicate stockouts or insufficient inventory to meet demand.
High DIO may indicate overstocking, slow-moving products, or declining demand. It also ties up working capital and increases storage and insurance costs.
Industry norms matter. A grocery store typically has a very low DIO (perishable goods), while a luxury car manufacturer may have a much higher DIO. Compare your result against industry averages rather than arbitrary targets.

Common Mistakes When Calculating DIO

Using revenue instead of COGS. DIO must use Cost of Goods Sold, not total revenue. Revenue includes markup, which would distort the result.
Mismatched time periods. Ensure your inventory figures and COGS cover the same period. Using annual COGS with a monthly inventory average will produce misleading results.
Ignoring inventory composition. DIO treats all inventory as homogeneous. If your business carries raw materials, work-in-progress, and finished goods, the metric may mask issues within specific categories.
Using a single point in time. Inventory levels fluctuate. Using a single month-end figure instead of an average can produce an inaccurate DIO.

Limitations of DIO

DIO is a useful efficiency metric, but it has limitations. It does not account for inventory write-downs, obsolescence, or changes in product mix. Seasonal businesses may see significant swings in DIO throughout the year, making annual averages less meaningful. Additionally, companies using different inventory valuation methods (FIFO vs. LIFO) may report different DIO figures even with identical physical inventory levels.

For a complete picture of working capital efficiency, DIO should be analyzed alongside Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO) as part of the cash conversion cycle.

Practical Use Cases

Inventory management review: Track DIO over multiple periods to identify trends in inventory efficiency.
Working capital analysis: Assess how much cash is tied up in inventory and identify opportunities to free up capital.
Supplier and purchasing decisions: Adjust order quantities and timing based on how quickly inventory turns.
Financial benchmarking: Compare your DIO against industry peers to evaluate operational performance.

Frequently Asked Questions

What is a good DIO?

There is no universal "good" DIO. It varies significantly by industry. Perishable goods retailers may aim for under 30 days, while capital equipment manufacturers may have DIO exceeding 100 days. The best benchmark is your own historical performance and industry averages.

What is the difference between DIO and inventory turnover?

Inventory turnover measures how many times inventory is sold and replaced over a period (COGS ÷ Average Inventory). DIO converts that into days (365 ÷ Inventory Turnover). Both measure the same efficiency, just expressed differently.

Can DIO be negative?

No. DIO represents a number of days, so it cannot be negative. A negative result would indicate an error in the input data, such as negative inventory values or incorrect COGS figures.

Should I use 365 or 360 days?

365 days is standard for annual calculations. Some financial analysts use 360 days for simplicity or to align with certain accounting conventions. The important thing is to be consistent across periods and comparisons.

Does DIO include work-in-progress inventory?

Yes, if you include all inventory categories in your average inventory figure. For more precise analysis, you may calculate separate DIO for raw materials, work-in-progress, and finished goods to identify where bottlenecks exist.