Working Capital and Inventory Efficiency

Days Inventory Outstanding: Calculation, Comparisons and Limits

Days inventory outstanding (DIO) estimates inventory holding time as average inventory / cost of goods sold × days in the period. It is an aggregate accounting estimate, not the observed age of each item or the time until cash collection. Use a day count that matches the COGS period, rather than always multiplying by 365.

See the decision guide

What is Days Inventory Outstanding and How Does It Work?

DIO compares recorded inventory with the cost of goods sold during a period. It helps investigate stock levels, but it does not trace individual goods or payments. Supplier credit can finance inventory before cash leaves the business, and credit sales can leave receivables after goods are sold.

Metric ComponentFinancial Statement SourceRole in CalculationAnalytical Significance
Average InventoryBalance Sheet (Current Assets)Numerator (Beginning + Ending Inventory) / 2Arithmetic average of the two endpoint balances; not a median or a full-period observation
Cost of Goods Sold (COGS)Income StatementDenominatorReflects actual production or acquisition cost of products sold
Period day countChosen fiscal periodMultiplierUse the days matching COGS; disclose any 360-day convention

How to Calculate Days Inventory Outstanding: Step-by-Step Formula

Use inventory at cost and COGS for the same entity and period. Quarterly reports may be unaudited. A 52- or 53-week fiscal year and different calendar quarters have different day counts; do not assume every quarter has 90 days.

  • Step 1: Locate ending inventory for the current and prior periods on the balance sheet, then calculate the average: (Beginning Inventory + Ending Inventory) / 2.
  • Step 2: Locate Cost of Goods Sold (COGS) on the income statement for the corresponding timeframe.
  • Step 3: Divide Average Inventory by COGS to obtain the inventory-to-cost ratio.
  • Step 4: Multiply by the days in the measured period. Hypothetically, opening inventory of $100m and closing inventory of $140m average $120m. With $600m COGS over a 90-day quarter, DIO = 120 / 600 × 90 = 18 days.
  • Use more frequent inventory averages when two endpoints miss seasonality. Zero or missing COGS makes DIO undefined; investigate negative figures and acquisition or disposal changes before comparing.

Make inventory comparisons on a consistent basis

There is no universal target DIO. Compare similar products and production cycles, with matching periods and accounting policies. The following checks replace unsupported industry ranges.

Comparison issueWhat to inspectWhy it matters
Perishable versus long-cycle goodsShelf life, lead times and work-in-progressA short shelf life and a long production cycle impose different inventory needs
Seasonal stockSame quarter in prior years and monthly balancesTwo year-end points can miss a peak
Accounting basisCost method, reserves and write-downsA lower carrying value can reduce DIO without a sale
Supplier and customer termsDPO, DSO and advancesInventory turnover alone does not measure cash funding

Investigate a DIO change without assuming misconduct

Review several comparable periods and the inventory note. Rising DIO is a prompt to investigate, not proof of margin contraction, weak demand or distorted earnings.

  • Separate raw materials, work in progress and finished goods where disclosed; their changes can have different causes.
  • Compare sales volumes, production schedules, product launches and supply buffers before concluding that stock is unsold.
  • Inspect cost allocation, inventory reserves and write-downs. Ordinary production-overhead capitalization is not itself evidence of improper accounting.
  • Check the cash-flow bridge and supplier payments. Inventory growth need not be financed entirely by new borrowing.
Where Pineify fits

AI Finance Agent

Retrieve supported inventory and income-statement data with the AI Finance Agent, then verify cost definitions and inventory notes in the filing before comparing DIO.

Analyze company inventory trends

Frequently asked questions

Educational financial information only, not investment advice. Working capital metrics must be evaluated in the context of industry norms, seasonality, and corporate strategy before making investment decisions.

Sources and verification