Days Inventory Outstanding Calculator and Formula

A days inventory outstanding (DIO) calculator estimates how many days, on average, a company holds inventory before selling it. Enter average inventory and cost of goods sold (COGS) for the same period, plus the period length, to get DIO in days and the inventory turnover rate.

Formula

DIO = average inventory ÷ cost of goods sold × days in the period. In symbols, DIO = (I ÷ COGS) × D. Here, I is average inventory in a currency amount, COGS is the cost of inventory sold during the same period in that same currency, and D is the number of days in the period. The currency units cancel, leaving days.

The companion turnover calculation is inventory turnover = COGS ÷ average inventory, measured in times per period. DIO is the period length divided by turnover. Use average inventory rather than ending inventory when you want a measure representative of the whole period.

Worked Example

Using the calculator’s default values:

• Average inventory, I = 50,000 currency units
• COGS = 300,000 currency units
• Period length, D = 90 days

DIO = (50,000 ÷ 300,000) × 90 = 0.1666667 × 90 = 15.00 days.

Inventory turnover = 300,000 ÷ 50,000 = 6.00 times per 90-day period. The two outputs are consistent: 90 ÷ 6 = 15 days.

What Days Inventory Outstanding Measures

DIO, sometimes called days sales of inventory (DSI), is a working-capital metric. It describes the average time inventory remains on hand before it is sold, based on the accounting values supplied. A lower result often means inventory is moving more quickly, while a higher result can indicate slower movement or more stock held relative to sales costs.

It is an estimate, not a literal count of how long each individual item sits in a warehouse. It combines inventory and COGS totals across a period, so it can conceal differences between products, locations, or seasons. It also does not say whether inventory is available in the right place or in the right mix.

How to Choose the Inputs

• Average inventory: Use inventory measured at cost, not its expected selling price. A simple estimate is (beginning inventory + ending inventory) ÷ 2. If inventory fluctuates significantly, averaging monthly or weekly balances can better reflect the period.
• COGS: Use the cost of goods sold for precisely the period used for inventory. COGS is an expense measure, not sales revenue. Using revenue in the denominator usually understates DIO because revenue includes a sales margin.
• Period length: Enter the actual number of days represented by the figures. A 90-day quarter, 365-day year, and 366-day leap year should not be treated as interchangeable. For a company’s fiscal period, use its actual dates.

Inventory and COGS need consistent accounting scope and currency. For example, do not combine a subsidiary’s inventory with consolidated COGS, or mix balances from one currency with costs recorded in another without converting them consistently. If COGS is zero, DIO cannot be calculated by this formula; if average inventory is zero, the turnover calculation is undefined.

How to Interpret and Compare DIO

Interpret the result against the business’s own history, product mix, and operating model. A grocery business, a furniture maker, and a company selling seasonal equipment can have very different normal inventory cycles. Comparing unrelated sectors without context can mislead, even when both use the same formula.

For a useful comparison, calculate DIO consistently over several periods and check whether the change reflects a real operational shift. A rise might follow deliberate preparation for a seasonal peak, longer supplier lead times, falling demand, or excess and obsolete stock. A fall could reflect better inventory management, but it can also result from holding too little stock and risking missed sales. Review the underlying details before treating either direction as good or bad.

DIO is often considered alongside days sales outstanding (DSO) and days payable outstanding (DPO) when examining the cash conversion cycle: cash conversion cycle = DIO + DSO − DPO. This broader measure includes time to collect customer payments and time taken to pay suppliers. DIO alone does not measure cash flow or profitability.

Common Calculation Mistakes and Limits

• Using sales instead of COGS: The standard DIO formula uses COGS because inventory is carried at cost. Revenue and inventory are not comparable bases for this ratio.
• Using only ending inventory: A single date can be unusual, particularly around a seasonal peak or year-end. Average balances reduce—but do not eliminate—this distortion.
• Mismatching periods: Pairing annual COGS with quarterly inventory or using 365 days for a short reporting period makes the result unreliable.
• Overinterpreting precision: The calculator rounds to two decimal places, but the source figures are estimates or accounting balances. More decimal places do not make the underlying measure more precise.
• Ignoring inventory valuation: Write-downs, accounting policies, product mix, and changes in cost can affect inventory and COGS. DIO is not a direct physical measurement of stock age.

The formula assumes the selected period’s COGS is a meaningful measure of inventory consumed or sold and that average inventory represents the period. Unusual one-off purchases, fast growth, price changes, or sharp seasonal swings can weaken those assumptions. For older or slow-moving stock, an inventory-aging report by item is more informative than one company-wide DIO figure.

Frequently Asked Questions

What is a good days inventory outstanding number?
There is no universally good DIO. Appropriate levels depend on the industry, product shelf life, supply chain, seasonality, and customer demand. Compare like with like and investigate what is driving the trend.

Is DIO the same as days sales of inventory?
They are commonly used for the same measure: average inventory divided by COGS, multiplied by the period’s days. Organizations may use different labels or conventions, so confirm the formula when comparing published figures.

Can I use ending inventory instead of average inventory?
You can calculate an approximate version using ending inventory, but it may be distorted by the balance on that particular date. Average inventory is generally more representative; use more frequent balances when stock changes substantially through the period.

Why is my DIO increasing?
A higher result means inventory is larger relative to COGS for the selected period. Possible reasons include seasonal stocking, slower sales, purchasing changes, or obsolete stock; the ratio alone cannot identify the cause.

How do I calculate DIO for a year?
Divide average inventory by annual COGS and multiply by the number of days in the year used for that reporting period. Keep both financial figures on the same accounting basis and use the actual period length.

Related

• Absolute Change and Relative Change Calculator
• Daily Data Usage Calculator: How Much Do You Need?
• Churn Rate Calculator and Formula

in inv | Average inventory | currency units | 50000 | 0 | 1000000000000
in cogs | Cost of goods sold | currency units | 300000 | 0 | 1000000000000
in days | Period length | days | 90 | 1 | 366
out dio | Days inventory outstanding | days | inv / cogs * days | 2
out turn | Inventory turnover | times per period | cogs / inv | 2