Days Inventory Outstanding (DIO) Calculator

Use the Days Inventory Outstanding (DIO) Calculator to see how fast inventory is turning into cost and, ultimately, into cash. Spot excess stock, benchmark inventory velocity, and quantify how much faster you could recycle working capital into growth and [[/roic-calculator|ROIC]].

By CalcMastery Editorial Team

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.

Select the time basis for your COGS/sales and inventory inputs. DIO scales to this period.

Exact number of days in your measurement period.

COGS (recommended)Net Sales (approx)

COGS-based DIO is standard. Sales basis is a helpful approximation if you do not have COGS.

Average Inventory (recommended)Single Inventory (period end)

Average inventory smooths swings and is preferred for turnover/DIO.

$

COGS for the selected period.

$

Sales net of returns/allowances for the period.

$

Inventory at the start of the period.

$

Inventory at the end of the period.

$

Single inventory balance for the period end.

Scenarios
Quick presets to see how inventory balances and cost basis affect DIO across common profiles.
Lean retailBalanced manufacturingJIT supplierSeasonal stock build

Results

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

Enter your inputs above to calculate the results.

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):

DIO = Average Inventory / COGS × Period Days

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:
Inventory Turnover = COGS / Average Inventory
DIO = Period Days / Inventory Turnover
If only Net Sales is available and COGS is missing, some practitioners approximate DIO by using sales instead of COGS:
DIOapprox = Average Inventory / Net Sales × Period Days

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:
    2. Average Inventory = (50,000 + 55,000) / 2 = 52,500
  1. Compute inventory turnover:
    2. Inventory Turnover = 500,000 / 52,500 approx 9.52 times
  1. Compute DIO (days inventory outstanding):
    2. DIO = 52,500 / 500,000 × 365 approx 38.33 days

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.

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.

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.

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:
    Average Inventory = (Beginning Inventory + Ending Inventory) / 2
    and
    DIO = (Average Inventory / Numerator) × Period Days
    to compute your days outstanding and turnover.

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.

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

How do I calculate Days Inventory Outstanding (DIO) from my financial statements?

Take your beginning and ending inventory for the period, compute average inventory, then divide it by your cost of goods sold (COGS) and multiply by the number of days in the period:

DIO = (Average Inventory / COGS) × Period Days

. The calculator automates this once you enter COGS, beginning inventory, ending inventory, and the period length.

Should I use average inventory or a single ending inventory balance in this calculator?

Use average inventory whenever possible because it smooths out fluctuations across the period and gives a more accurate DIO. Only switch to the “Single inventory (period end)” option if you don’t have a reliable beginning balance or your inventory is relatively stable.

When does it make sense to switch from COGS to Net Sales as the calculation basis?

COGS is the standard because DIO is meant to measure how long inventory sits at cost before it’s sold; use it whenever those numbers are available. Choose “Net Sales (approx)” only when COGS is missing or unreliable—this gives you a directional DIO, but it’s less precise and should be treated as an approximation.

What is a “good” DIO value and how should I interpret high vs. low results?

A lower DIO means inventory is turning faster and cash is tied up for fewer days, but if it’s too low you might be risking stockouts. A higher DIO can signal excess stock, weak demand, or operational issues; the real signal comes from comparing your DIO to past periods and to peers in your specific industry, since acceptable ranges vary widely.

Sources & Methodology