Inventory Days Calculator
Calculate inventory days or Days Inventory Outstanding (DIO) using average inventory and cost of goods sold to estimate how long inventory remains in your business before being sold.
Calculate Inventory Days
Enter beginning inventory, ending inventory, COGS, and the reporting period.
What Is an Inventory Days Calculator?
An Inventory Days Calculator estimates the average number of days inventory remains in a business before being sold or used.
Inventory days are also commonly called Days Inventory Outstanding (DIO) or Days Sales of Inventory.
When beginning and ending inventory balances are available, average inventory can be calculated as:
How to Use the Inventory Days Calculator
1. Enter Inventory
Enter beginning and ending inventory balances for the same reporting period.
2. Enter COGS
Add cost of goods sold and the number of days covered by the reporting period.
3. Calculate DIO
Review inventory days, average inventory, turnover, and daily COGS.
How Does the Inventory Days Calculation Work?
The calculator first calculates average inventory from the beginning and ending inventory balances.
Average inventory is then divided by cost of goods sold and multiplied by the number of days in the reporting period.
Inventory Days Example
| Financial Item | Example Value |
|---|---|
| Beginning Inventory | $100,000 |
| Ending Inventory | $140,000 |
| Cost of Goods Sold | $900,000 |
| Reporting Period | 365 Days |
In this example, inventory remains in the business for approximately 48.67 days before being sold or consumed.
Inventory Days and Inventory Turnover
Inventory days and inventory turnover measure the same inventory activity from different perspectives.
A higher inventory turnover generally corresponds with fewer inventory days, while a lower turnover generally corresponds with more inventory days.
For example, if inventory turns approximately 7.5 times during a 365-day year, inventory days would be approximately 48.67 days.
How to Interpret Inventory Days
Inventory days show how long capital is tied up in inventory before those goods are sold. Lower values generally indicate faster inventory movement.
| Inventory Days Trend | General Interpretation |
|---|---|
| Lower Inventory Days | Inventory is generally moving through the business more quickly. |
| Stable Inventory Days | Inventory movement is relatively consistent compared with previous periods. |
| Rising Inventory Days | Inventory may be selling more slowly or stock levels may be increasing relative to COGS. |
| Very High Inventory Days | May indicate excess inventory, slower demand, obsolete stock, or an intentionally inventory-heavy business model. |
Lower vs. Higher Inventory Days
Lower Inventory Days
Lower inventory days generally indicate that inventory is converted into sales more quickly. This may reduce storage costs, working-capital requirements, and the risk of stock becoming obsolete.
However, inventory levels that are too low can increase the risk of stockouts, lost sales, and supply-chain disruptions.
Higher Inventory Days
Higher inventory days mean inventory remains in storage for longer. This can occur because of slower demand, excess purchasing, seasonal inventory buildup, production requirements, or long operating cycles.
Inventory Days and the Cash Conversion Cycle
Days Inventory Outstanding is one of the three components used to calculate the cash conversion cycle.
DIO represents the portion of the cash conversion cycle during which cash is tied up in inventory before a sale takes place.
All else being equal, reducing inventory days can shorten the company's cash conversion cycle.
Why Are Inventory Days Important?
Inventory often represents a significant use of working capital. Money invested in stock may remain unavailable for other business purposes until inventory is sold.
Monitoring inventory days can help business owners and finance teams evaluate purchasing, demand forecasting, inventory planning, warehouse efficiency, and working-capital management.
A rising DIO over several periods may indicate inventory accumulation, while a declining DIO may indicate faster stock movement.