Skip to content
FiftyCalc Free calculators for all 50 states

Days Inventory Outstanding Calculator

Test cases replayed : 2 of 2 match · Methodology · No outside source listed

Enter inventory at the start and end of the period and the cost of goods sold to see how many days, on average, stock sits before it is sold.

Result

Sample figures

Days inventory outstanding—days

Average inventory ($) —

  • Inventory turnover (times per period)—

Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.

Days Inventory Outstanding Calculator

Beginning inventory, in dollars: enter 0 or more. Prefilled example: 80,000.

Ending inventory, in dollars: enter 0 or more. Prefilled example: 100,000.

Cost of goods sold for the period, in dollars: enter 0.01 or more. Prefilled example: 600,000.

Days in the period: enter 1 or more. Prefilled example: 365.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Beginning inventory, in dollars: enter 0 or more.
  2. Ending inventory, in dollars: enter 0 or more.
  3. Cost of goods sold for the period, in dollars: enter 0.01 or more.
  4. Days in the period: enter 1 or more.
  5. Read the result: Days inventory outstanding; the panel also shows Average inventory ($) and Inventory turnover (times per period).

How this calculator works

Days inventory outstanding = average inventory ÷ cost of goods sold × days in the period, with average inventory = (beginning + ending inventory) ÷ 2.

Inventory turnover = COGS ÷ average inventory, so DIO = days ÷ turnover. DIO is one leg of the cash conversion cycle (DIO + DSO − DPO).

The formula

  1. Avg=ib+ie2
  2. Dio=Avgc×d
Symbols used in the formula
SymbolMeaningUnit
ibBeginning inventory$
ieEnding inventory$
cCost of goods sold for the period$
dDays in the period
AvgAverage inventory$
DioDays inventory outstandingdays

Worked example

Beginning inventory$80,000
Ending inventory$100,000
Cost of goods sold for the period$600,000
Days in the period365
Average inventory ($)$90,000
Inventory turnover (times per period)6.67
  1. Avg=80,000+100,0002=90,000
  2. Dio=90,000600,000×365=54.75

Days inventory outstanding 54.75 days

Each step uses the unrounded value of the step before it; figures on this page are rounded for display.

Frequently asked questions

What is DIO with $80,000 and $100,000 of inventory and $600,000 of COGS for the year?

54.75 days, an inventory turnover of 6.67 times a year.

Why use cost of goods sold and not sales?

Inventory is carried at cost, so dividing by COGS compares like with like. Using sales would make the days look shorter.

Related calculators