Days Inventory Outstanding (DIO) Calculator

Calculate how many days inventory sits before sale using COGS or (optionally) net sales, with average vs single-period inventory. See turnover, velocity, and quick scenarios.

DIO = (Average Inventory / COGS) * Days.
(Beginning + Ending) / 2
$
$
$
$
$

Results

  • Days Inventory Outstanding (DIO) days
  • Inventory Turnover
  • Average Inventory $
  • Avg daily COGS/Sales $
  • Numerator used
  • Inventory velocity

What is Days Inventory Outstanding (DIO)?

Days Inventory Outstanding (DIO) shows the average number of days inventory stays on the balance sheet before flowing through cost of goods sold.

It links inventory management to the cash conversion cycle by translating inventory turnover into time, making it clear how long cash is locked up in stock instead of funding growth, debt reduction, or dividends.

A lower DIO generally signals:

  • Faster inventory turnover
  • Leaner working capital and higher free cash flow
  • Less risk of obsolescence, discounting, or write-downs

A higher DIO usually points to:

  • Slow-moving or obsolete items
  • Over-ordering relative to demand
  • Capital tied up in stock instead of in higher-return uses

Formula

Standard, COGS-based definition (most common in corporate finance):

Where:

  • Average Inventory = (Beginning Inventory + Ending Inventory) / 2
  • COGS = Cost of Goods Sold over the period (at cost, not selling price)
  • Period Days = Number of days in the period (often 365, 360, 90, or 30)

Equivalent form using the inventory turnover ratio:


If only Net Sales is available and COGS is missing, some practitioners approximate DIO by using sales instead of COGS:

This Net Sales version gives an approximate “days of inventory” and should be interpreted with caution, since it mixes cost-based inventory with revenue.

Example

A company wants to understand how efficiently it is managing stock over a full year (365 days):

  • Beginning inventory: $50,000
  • Ending inventory: $55,000
  • COGS for the year: $500,000
  1. Compute average inventory:
  1. Compute inventory turnover:
  1. Compute DIO (days inventory outstanding):

Interpretation: the business holds, on average, about 38 days of inventory before it is consumed as COGS. Compared with peers or internal targets, management can decide whether to reduce safety stock, shorten reorder cycles, or improve demand planning to free up working capital and strengthen the overall cash conversion cycle.

How to Use the Days Inventory Outstanding (DIO) Calculator

Use this calculator to see how many days, on average, your inventory sits before it’s sold by plugging in your period length, inventory balances, and either COGS or Net Sales based on your financials.

  1. Set the analysis period

    • Choose the period that matches your financial statements (for example, “Annual (365 days)” by default). This tells the calculator how many days to use when converting turnover into days outstanding.
  2. Choose calculation and inventory basis

    • Under “Calculation Basis,” keep “COGS (recommended)” selected for a proper cost-based DIO, or switch to “Net Sales (approx)” only if you don’t have COGS. Under “Inventory Basis,” leave “Average Inventory (recommended)” on, unless you specifically want to use a single end-of-period inventory balance.
  3. Enter inventory and numerator values

    • Fill in “Beginning Inventory,” “Ending Inventory,” and the relevant numerator field (either COGS or Net Sales for the same period). The calculator then applies: and to compute your days outstanding and turnover.
  4. Review the results panel

    • Check “Days Inventory Outstanding (DIO)” in days, “Inventory Turnover,” “Average Inventory,” the average daily COGS/Sales figure, the “Numerator used” label, and the “Inventory velocity” band (for example, Fast vs. Very fast) to see how quickly your stock is moving.
  5. Interpret insights and iterate with scenarios

    • Use the “What It Means” text and the summary bar at the bottom to understand whether your DIO suggests healthy flow or potential over/under-stocking. Adjust inputs, test different periods or assumptions, and optionally turn on charts to visualize how changes in sales, COGS, or inventory levels would affect your inventory days.

Frequently Asked Questions

Methodology & Sources

Bibliography

  1. (2016). Working Capital and Cash Conversion Cycle — MIT Center for Transportation & Logistics
    Accessed 2025-12-03
  2. (2021). On the Nature of Working Capital – Understanding its Mysteries and Complexities — Yale School of Management
    Accessed 2025-12-03
  3. (2023). Days in Inventory — Wikipedia Foundation
    Accessed 2025-12-03