About the Days Inventory Outstanding (DIO)
Days Inventory Outstanding (DIO) is a free financial statement calculator for efficiency analysis. Average number of days inventory stays on hand before being sold. This is a component of the cash conversion cycle. Enter values from the source reports shown alongside each field and receive a calculated figure with contextual interpretation. The tool operates locally in your browser.
Formula or method
Formula: Average inventory ÷ Cost of goods sold × Period days. Find the required amounts on the reporting company’s Balance Sheet, Income Statement, Cash Flow Statement or supporting notes. Beginning and ending balance sheet amounts should cover the same period as the income statement numbers. Beginning inventory (Prior-period Balance Sheet): Inventory balance at the start of the period, not the purchases or expense amount. Ending inventory (Current Balance Sheet): Inventory balance at the end of the period. Use the same measurement conventions as opening inventory. Cost of goods sold / cost of revenue (Income Statement): Direct costs of goods or services sold during the period. Do not confuse this flow with the Inventory balance-sheet stock. Days in reporting period (Report dates): 365 for a standard full year, 366 for a leap year, or actual days for a quarter or other reporting period.
Worked example
Illustrative example inputs: Beginning inventory = 25,000; Ending inventory = 35,000; Cost of goods sold / cost of revenue = 180,000; Days in reporting period = 365. Replace these sample figures with values from your financial statements to see the calculation. Use consistent units and period lengths; numbers in thousands and millions cannot be combined without conversion.
How to use the tool
- Locate the named accounts on the financial statements and read the accompanying footnotes.
- Enter each amount using one currency, scale and consistent reporting dates or reporting period.
- Read the value together with its low, high and negative interpretation. Compare with past years and industry peers.
Common uses
Financial statement review, small business monitoring, credit analysis, investor education.
Assumptions and limitations
With zero COGS, inventory days cannot be computed meaningfully. Results must use a consistent reporting period. Long inventory days can tie up cash and increase the risk of obsolete stock. Shorter days can indicate efficient inventory management, but extremely short times may risk stockouts. Never decide whether a business is healthy from a single ratio alone. Sector norms, revenue recognition, reporting periods, one-time items and the cash-flow statement all matter.
Frequently asked questions
What does a days inventory outstanding (dio) result mean?
Average number of days inventory stays on hand before being sold. This is a component of the cash conversion cycle. Long inventory days can tie up cash and increase the risk of obsolete stock. Shorter days can indicate efficient inventory management, but extremely short times may risk stockouts. If a denominator is zero, or book equity is nonpositive for ratios that depend on it, treat the result as undefined rather than zero.
Where to find the numbers on your financial statements
Use amounts from the same business, in the same currency and reporting period. Balance Sheet figures are amounts at particular dates; Income Statement and Cash Flow Statement figures cover a period.
Beginning inventory
Source: Prior-period Balance Sheet
Inventory balance at the start of the period, not the purchases or expense amount.
Ending inventory
Source: Current Balance Sheet
Inventory balance at the end of the period. Use the same measurement conventions as opening inventory.
Cost of goods sold / cost of revenue
Source: Income Statement
Direct costs of goods or services sold during the period. Do not confuse this flow with the Inventory balance-sheet stock.
Days in reporting period
Source: Report dates
365 for a standard full year, 366 for a leap year, or actual days for a quarter or other reporting period.
What does the ratio tell you?
Average number of days inventory stays on hand before being sold. This is a component of the cash conversion cycle.
How to read a lower result
Long inventory days can tie up cash and increase the risk of obsolete stock.
How to read a higher result
Shorter days can indicate efficient inventory management, but extremely short times may risk stockouts.
What if the ratio is negative, zero or undefined?
With zero COGS, inventory days cannot be computed meaningfully. Results must use a consistent reporting period. A zero denominator is mathematically undefined. Assess profitability, cash generation and balance-sheet quality together.
Calculate the ratio using the formula
Average inventory ÷ Cost of goods sold × Period days
Privacy and support
Your inputs are processed locally in your browser. ToolMosaic does not upload or store the values you enter in this tool. Our tools are free, and we appreciate your support.