Inventory Turnover Calculator

There is no universal benchmark — the ratio is strongly sector-dependent. Supermarkets and discount retailers run 8–12 (fast-moving, low-margin, short shelf-life). Apparel and consumer electronics cluster around 4–6. Automotive parts and OEMs sit around 5–8. Heavy industrial machinery and capital equipment run 2–4 because the units themselves are large and slow-moving. Luxury goods and high-end jewellery can run as low as 1–2 — high margin per unit compensates for slow sales. Always compare a company against its sector peers and its own multi-year trend, never against a universal threshold; the right reference is "how does this firm compare to firms with the same business model?".

Inventory is carried on the balance sheet at cost, not at sales price. Pairing a sales-price numerator with a cost-price denominator inflates the ratio by the gross margin and gives a misleading reading of how fast the stock actually moves. The textbook formula uses COGS specifically so that both sides of the fraction are measured in the same units (dollars of cost). Some older sources substitute net sales when COGS is not reported separately — this is an approximation only, and the resulting figure is always higher than the true turnover by the multiple 1 / (1 − gross margin). Use COGS whenever it is available, which on US 10-Ks and international IFRS filings is almost always.

Days Inventory Outstanding restates the turnover ratio as a time period instead of a frequency. DIO = 365 / Inventory Turnover; equivalently DIO = (Average Inventory / COGS) × 365. The two measures contain identical information — they are reciprocals scaled by 365 — but DIO is often easier to reason about and plugs directly into the Cash Conversion Cycle formula: CCC = DIO + DSO − DPO, where DSO is Days Sales Outstanding (receivables) and DPO is Days Payable Outstanding (payables). The cash conversion cycle measures how long capital is tied up between paying suppliers and collecting from customers, and DIO is usually its largest single component for any inventory-heavy business.

COGS is a flow figure accumulated across the entire reporting period, while inventory is a stock figure measured at a single point in time. Pairing a year of COGS with one endpoint balance — either the opening or the closing balance alone — biases the ratio whenever the inventory base grows, shrinks, or has a seasonal peak during the year. Averaging the two endpoints gives a rough mid-year inventory base, which lines up much better with the timing of COGS. Some analysts use a 13-point monthly average or even a daily average for higher precision, particularly for highly seasonal businesses; the simple two-point average is the convention in published financial statement analysis and is sufficient for most read-throughs.

A declining inventory turnover usually flags one of three problems. First, slowing demand — if sales (and therefore COGS) drop faster than purchasing adjusts, inventory builds up and turnover falls. Second, deliberate or accidental overbuying — purchasing got ahead of forecast, often visible alongside flat sales. Third, obsolescence — stale stock is still on the balance sheet but no longer selling, and management has not yet written it down. Trend matters more than any single year: a one-year dip can reflect a seasonal mismatch or a strategic build for an upcoming launch, while three or four consecutive years of decline usually means real trouble in the assortment.

Yes, although the problem is rarer than a turnover that is too low. A ratio well above sector norms can indicate stockouts — the firm is selling product faster than it can replenish, leaving customers facing empty shelves or backorders. The lost-sales cost of stockouts does not appear anywhere on the income statement, so a "great" turnover number can sit alongside a stealthy revenue ceiling that management never sees directly. It can also indicate underinvestment in working capital, with the firm running so lean that any supply-chain disruption causes immediate damage. As with most ratios, the right read is comparative: a turnover well above peers warrants a question about how it is being produced, not automatic celebration.