Accounting Profit Calculator
Calculate accounting profit with full income statement breakdown — gross profit, EBITDA, operating profit, EBT, and net income with margin percentages.
Days Inventory Outstanding (DIO) Calculator
Calculate days inventory outstanding, inventory turnover, holding costs, and compare against industry benchmarks. Includes sensitivity analysis and efficiency metrics.
Days Inventory Outstanding⧉
50.2 days
Average days to sell inventory
Inventory Turnover⧉
7.3×
0.61× per month
Average Inventory⧉
$165,000.00
(Beginning + Ending) ÷ 2
Daily COGS⧉
$3,287.67
Cost of goods sold per day
Gross Margin⧉
40.0%
Gross profit: $800,000.00
Inventory / Revenue⧉
8.3%
Inventory as % of revenue
Est. Holding Cost⧉
$41,250.00
~25% of avg inventory (industry est.)
Inventory Efficiency
DIO:
50 days
● <30 Excellent● 30-60 Average● >60 Review needed
Industry Benchmarks
| Industry | DIO Range | Turnover |
|---|---|---|
| Grocery / Perishables | 5 – 15 days | 25 – 75× |
| Fast Fashion | 20 – 45 days | 8 – 18× |
| Consumer Electronics | 30 – 60 days | 6 – 12× |
| Automotive | 45 – 75 days | 5 – 8× |
| Wholesale Distribution | 30 – 50 days | 7 – 12× |
| E-commerce | 20 – 40 days | 9 – 18× |
| Luxury Goods | 60 – 120 days | 3 – 6× |
| Industrial/Heavy Equipment | 90 – 180 days | 2 – 4× |
Inventory Level Sensitivity
| Avg Inventory | DIO | Turnover | Est. Holding Cost |
|---|---|---|---|
| $82,500.00 | 25.1 days | 14.5× | $20,625.00 |
| $123,750.00 | 37.6 days | 9.7× | $30,937.50 |
| $165,000.00 | 50.2 days | 7.3× | $41,250.00 |
| $206,250.00 | 62.7 days | 5.8× | $51,562.50 |
| $247,500.00 | 75.3 days | 4.8× | $61,875.00 |
| $330,000.00 | 100.4 days | 3.6× | $82,500.00 |
Planning notes, formulas, and examples
About the Days Inventory Outstanding (DIO) Calculator
Days Inventory Outstanding (DIO) measures the average number of days a company holds inventory before selling it. It's one of the three components of the Cash Conversion Cycle and a critical metric for working capital management, supply chain efficiency, and cash flow optimization. A lower DIO generally means faster inventory turnover and less capital tied up in unsold stock.
DIO varies enormously by industry. Grocery stores turn inventory in 5-15 days, while luxury goods companies may hold stock for 60-120 days. What matters is your trend and your performance relative to peers. A rising DIO might signal demand problems, overordering, or product obsolescence. A falling DIO could indicate improved efficiency, but if too aggressive, might mean frequent stockouts and lost sales.
This calculator computes DIO from your COGS and inventory data, shows inventory turnover, estimates annual holding costs (typically 25% of inventory value), and benchmarks your performance against industry standards. The sensitivity table shows exactly how inventory level changes affect your efficiency metrics.
When This Page Helps
Monitoring DIO helps you spot inventory problems early, reduce holding costs, and free up cash for growth. This calculator gives you the metrics, benchmarks, and sensitivity analysis needed to optimize inventory levels and improve the cash conversion cycle.
How to Use the Inputs
- Enter your cost of goods sold for the period
- Enter beginning and ending inventory values
- Add annual revenue for gross margin calculation
- Select the time period (annual, quarterly, or monthly)
- Review DIO, turnover, and holding cost estimates
- Compare your DIO against industry benchmarks
Formula used
Average Inventory = (Beginning + Ending Inventory) ÷ 2
Daily COGS = Total COGS ÷ Days in Period
DIO = Average Inventory ÷ Daily COGS
Inventory Turnover = COGS ÷ Average Inventory
Estimated Holding Cost = Average Inventory × 25%Example Calculation
Result: DIO 50.2 days — turnover 7.3×
Average inventory = ($150K + $180K) ÷ 2 = $165K. Daily COGS = $1.2M ÷ 365 = $3,288. DIO = $165K ÷ $3,288 = 50.2 days. Turnover = $1.2M ÷ $165K = 7.3× per year. Estimated holding cost = $165K × 25% = $41,250/year.
Tips & Best Practices
- Compare DIO quarter-over-quarter — a rising trend is a warning sign even if the absolute number looks fine
- Every day of DIO reduction frees up cash equal to daily COGS — measure the dollar impact
- Seasonal businesses should compare same-quarter DIO year-over-year, not sequential quarters
- ABC analysis: focus on reducing DIO for A-items (80% of value) first
- Target DIO in the better half of industry benchmarks — too low risks stockouts, too high ties up cash
Inventory Cycle Checks
Use COGS, not revenue, when estimating DIO, and compare like periods when seasonality matters. A lower number is not always better if it creates stockouts or missed sales.
Working Capital Risks
The most common errors are using ending inventory only, comparing mismatched periods, or ignoring obsolete stock. For a cleaner working-capital picture, review DIO alongside DSO and DPO.
Sources & Methodology
Last updated:
Methodology
This worksheet calculates average inventory from the beginning and ending balances, divides cost of goods sold by the selected number of days to estimate daily COGS, and then computes DIO as `average inventory / daily COGS`. It also reports inventory turnover, gross margin, inventory-to-revenue ratio, and a holding-cost estimate using a flat 25% carrying-cost assumption.
The formula-driven outputs use the entered inventory, COGS, revenue, and period values directly. The industry ranges and 25% holding-cost assumption are reference aids only; they are not authoritative regulatory thresholds or company-specific cost studies.
Sources
- Beginners' Guide to Financial Statements (U.S. Securities and Exchange Commission) — SEC guide covering income statement, balance sheet, and cash flow statement line items such as inventory, revenue, and cost of goods sold.
- How to Read a 10-K (U.S. Securities and Exchange Commission) — SEC investor reference explaining how public-company filings present inventory, costs, and working-capital disclosures.
Frequently Asked Questions
It depends entirely on your industry. Under 30 days is excellent for retail/e-commerce, 30-60 is average for most businesses, and industrial/equipment companies may reasonably be 90-180 days. Always benchmark against your specific industry and competitors.
CCC = DIO + DSO − DPO. DIO measures inventory days, DSO measures receivables days, and DPO measures payables days. A lower CCC means faster conversion of inventory to cash. Reducing DIO is often the most impactful lever.
Rising DIO can signal: slowing demand, overordering/overstocking, product obsolescence, seasonal buildup, or supply chain issues. It means more cash is tied up in inventory for longer, which hurts liquidity.
Industry research suggests 20-30% of inventory value annually, including: warehousing/rent (5-10%), insurance (1-3%), shrinkage/damage (2-5%), opportunity cost (5-10%), and obsolescence (3-8%). We use 25% as a standard estimate.
Always use COGS. Inventory is carried at cost, not at selling price. Using revenue would understate DIO because it includes your markup. COGS provides an apples-to-apples comparison with inventory values.
Implement just-in-time (JIT) inventory, use demand forecasting to order more accurately, run promotions on slow-moving stock, reduce supplier lead times, improve demand planning, and regularly review and liquidate obsolete items. Focus first on the SKUs that tie up the most cash.
More in this topic
Accumulated Depreciation Calculator
Calculate accumulated depreciation using straight-line, double declining balance, sum-of-years digits, or units of production methods with full schedule.
Average Fixed Cost Calculator
Calculate average fixed cost (AFC) per unit, average total cost, break-even units, contribution margin, and see how economies of scale reduce per-unit costs.