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
Days inventory outstandingdays
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.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Beginning inventory, in dollars: enter 0 or more.
- Ending inventory, in dollars: enter 0 or more.
- Cost of goods sold for the period, in dollars: enter 0.01 or more.
- Days in the period: enter 1 or more.
- 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
| Symbol | Meaning | Unit |
|---|---|---|
| Beginning inventory | $ | |
| Ending inventory | $ | |
| Cost of goods sold for the period | $ | |
| Days in the period | ||
| Average inventory | $ | |
| Days inventory outstanding | days |
Worked example
| Beginning inventory | $80,000 |
|---|---|
| Ending inventory | $100,000 |
| Cost of goods sold for the period | $600,000 |
| Days in the period | 365 |
| Average inventory ($) | $90,000 |
|---|---|
| Inventory turnover (times per period) | 6.67 |
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.