DIO, DSI and days inventory on hand
Days inventory outstanding measures the inventory balance relative to the cost of goods sold during a period. It is also called days sales of inventory, inventory holding days, days inventory on hand or, in some contexts, DOH. These labels often describe the same financial ratio, although operational stock-cover reports can use forward demand and therefore differ.
A DIO of 50 means the selected inventory balance represents roughly fifty days of the selected cost flow. It does not mean every product remains in a warehouse for exactly fifty days. Raw materials, work in progress and finished goods can have different physical lead times. The financial ratio blends those categories into one monetary measure.
Calculate inventory days from a comparable average
DIO = average inventory ÷ cost of goods sold × period days. Enter the average directly or use opening and closing inventory. The two-point average is (opening + closing) ÷ 2. Closing-only input is available as a simplified estimate. For seasonal stock, frequent average balances can be more representative than two reporting dates.
Use a consistent accounting perimeter. If COGS relates to the consolidated business, avoid including inventory from only one warehouse or excluding a product category without making a matching cost adjustment. The calculator accepts decimals and consistent units, so the same formula works in euros, thousands or millions. Changing the display labels does not convert or rescale the entered amounts.
Why the denominator is COGS, not sales
Inventory is generally recorded at a cost-based amount, subject to applicable measurement rules. Revenue includes the margin earned on sale. Dividing a cost-based inventory balance by revenue would usually produce fewer days than dividing it by COGS, even if the underlying stock policy were unchanged. Changes in gross margin would then contaminate the comparison.
Keep the cost definitions stable. Changes in production overhead allocation, inventory valuation or write-downs can affect the relationship between inventory and expense. Outsourcing production may remove some stock from the balance sheet while changing supplier terms. The resulting DIO shift can reflect accounting scope and business design as well as physical inventory efficiency.
Worked example: 50 days and 7.3 turns
Average inventory of 500 and COGS of 3,650 over 365 days produce daily cost of sales of 10. DIO is 500 ÷ 3,650 × 365, or 50 days. Inventory turnover is 3,650 ÷ 500, or 7.3 times during that year. Dividing 365 by 7.3 returns the same 50 days.
If the opening balance is 400 and the closing balance is 600, their average is 500 and the result is unchanged. Entering closing inventory alone would instead produce 60 days. Neither result should be silently substituted for the other: the first describes a two-point average, while the second measures the year-end balance against the annual cost flow.
Convert inventory turnover in either direction
For a positive average inventory balance, turnover = COGS ÷ average inventory and DIO = period days ÷ turnover. The dedicated turnover method allows either conversion. Use the same period for both measures. A quarterly turnover of two times over 90 days corresponds to 45 days; it is not an annual turnover of two.
Zero inventory with positive COGS gives zero inventory days, but turnover is not a meaningful finite number. The historical calculation keeps the valid day result and explains the limitation. Converting directly from zero turnover or zero DIO would require division by zero, so the conversion method asks for a positive denominator instead of displaying infinity.
Forecast the balance from target inventory days
Implied inventory = COGS ÷ period days × target DIO. At annual COGS of 3,650 and a target of 50 days, implied inventory is 500. This gives finance and operations a common bridge between a stock policy and the balance sheet. It also makes the funding effect of growth visible when the day assumption stays unchanged.
A forecast based on annual cost of sales is a simplifying convention. Operational replenishment often uses future demand, supplier lead times, service levels and item-specific safety stock. For a fast-growing or seasonal business, a forward cost run rate may better explain closing inventory than a trailing annual average. State which convention the model uses and avoid mixing them in a trend chart.
Current versus target inventory and cash
At daily COGS of 10, moving from 70 to 50 inventory days reduces implied stock from 700 to 500. The change in inventory is −200, producing an approximate positive cash impact of 200. Increasing the target from 50 to 70 days absorbs 200. The comparison holds the cost flow constant so it isolates the stock-days assumption.
A physical inventory reduction is not always the same as cash release. A write-down reduces the carrying value but does not itself create a receipt. Scrapping obsolete goods can reduce stock without recovering its cost. Sales, purchasing and cash settlement need to support the movement. Remove non-cash changes when using inventory balances to build an operating cash-flow bridge.
Safety stock and supply-chain choices matter
Lower inventory can reduce storage and financing needs, but it can also increase stockout risk. A company may deliberately carry more critical components when replenishment times are long or uncertain. Minimum order quantities, batch economics and customer service commitments also influence the appropriate balance. A higher DIO is therefore not automatically evidence of poor management.
Examine categories rather than treating all inventory as interchangeable. Raw materials may protect production continuity, work in progress may reflect a long manufacturing process, and finished goods may support rapid delivery. An aggregate improvement can hide deterioration in slow-moving products. Operational aging and service metrics complement the financial ratio; this calculator does not replace an inventory-management system.
Seasonality, obsolete stock and growth
Inventory often builds before the related sales occur. A holiday retailer can look inefficient just before its busiest month and unusually lean just after it. Opening and closing averages may miss the highest funding requirement between those dates. Monthly balances and cost flows help distinguish a planned seasonal build from a persistent accumulation of unsold stock.
Growth also changes the interpretation. If daily COGS rises from 10 to 12 while DIO improves from 70 to 60, implied inventory increases from 700 to 720. The business turns stock faster but still needs additional funding. Separately investigate obsolete stock, returns and valuation adjustments before attributing every change to purchasing or warehouse performance.
Connect inventory to the operating cash cycle
Inventory days are added to collection days and offset by supplier days in the Cash Conversion Cycle Calculator. The combined model is useful because a stock reduction can coincide with changed supplier terms or customer payment patterns. Looking only at DIO may miss the net cash effect of the wider commercial decision.
In a three-statement forecast, inventory is a balance-sheet asset, COGS is an income-statement expense and the relevant inventory increase is a cash use. Keep purchase payments and non-cash stock movements separate. Document the average method, period length, valuation basis and target rationale so future users can reproduce the result and understand why it changed.
Frequently asked questions
Are DIO and DSI identical?
They commonly refer to the same cost-based inventory-days ratio. Check the definition: a forward operational days-of-cover measure based on future demand may differ from historical financial-statement DIO.
Can inventory days exceed 365?
Yes. A large inventory balance relative to annual COGS can imply more than one year of stock. Investigate the business model, slow-moving items and input consistency rather than automatically rejecting the result.
Does reducing inventory improve EBITDA?
Not automatically. The balance change affects working capital and cash timing. Write-downs, purchasing discounts, storage savings or stockouts may affect profit separately and need their own assumptions.