Inventory Turnover Calculator

Inventory turnover is the working-capital counterpart to accounts receivable turnover, except it measures how efficiently a company moves goods off the shelf instead of how quickly it collects cash from customers. A high turnover ratio means the company is selling through stock quickly, generally a sign of strong demand and disciplined purchasing. A low turnover ratio means inventory is piling up faster than it's selling, tying up cash in goods that may eventually need to be marked down or written off.

Retailers, distributors, and manufacturers all watch this ratio closely because inventory is often the single largest working-capital investment on the balance sheet for these businesses, larger even than accounts receivable in many cases. A grocery chain and a heavy machinery manufacturer will have naturally very different turnover ratios because of the products they sell, so the ratio is most useful compared against direct competitors or against the same company's own historical trend, not against a universal benchmark.

The companion metric, Days Inventory Outstanding (DIO), expresses the same information in days rather than a turns-per-year figure, which is often more intuitive when thinking about how long cash is tied up in the inventory cycle before a sale converts it back to cash (or, combined with days payable and days receivable, the full cash conversion cycle).

Step 1: Average Inventory.

Step 2: Inventory Turnover.

Cost of Goods Sold, not revenue, is the correct numerator, because inventory is carried on the balance sheet at cost, not at its eventual selling price. Using revenue instead of COGS would mix a cost-basis denominator with a price-basis numerator and inflate the ratio by the gross margin percentage.

Step 3: Days Inventory Outstanding.

A specialty retailer reports the following for its fiscal year:

• Cost of Goods Sold: $3,600,000
• Beginning Inventory: $280,000
• Ending Inventory: $320,000
• Days in Period: 365

Step 1: Average Inventory = ($280,000 + $320,000) / 2 = $300,000

Step 2: Inventory Turnover = $3,600,000 / $300,000 = 12.00x

Step 3: DIO = 365 / 12.00 = 30.4 days

The retailer sells through and replaces its average inventory 12 times per year, or roughly once every 30.4 days. For a specialty retail business, that's a reasonably healthy pace, sitting between the very fast turnover expected of perishable-goods retailers and the much slower turnover typical of capital-equipment sellers.

This calculator has no twelve-row sweep, but it does have a boundary, and it is one most turnover pages do not mention because it lives in the code rather than in accounting doctrine. The health label is set by two hard tests on Days Inventory Outstanding: 30.0 days or fewer is "Fast-Moving Inventory", more than 90 days is "Slow-Moving Inventory (Tie-Up Risk)", and everything between is "Typical Turnover Pace".

Walking the fast boundary. Holding average inventory at $300,000 and moving COGS: at $3,640,000 the calculator returns 12.13x and 30.1 days, labelled Typical Turnover Pace. At $3,660,000 it returns 12.20x and 29.9 days, labelled Fast-Moving Inventory. Twenty thousand dollars of COGS, about half a percent, moves the label. At exactly $3,650,000 the answer is 12.17x and 30.0 days, which the code treats as fast, because the test is "less than or equal to 30".

Walking the slow boundary. At $1,210,000 of COGS the calculator returns 4.03x and 90.5 days, labelled Slow-Moving Inventory (Tie-Up Risk). At $1,220,000 it returns 4.07x and 89.8 days, labelled Typical Turnover Pace. Ten thousand dollars of COGS separates a tie-up warning from an unremarkable one.

Those two thresholds are arbitrary and industry-blind, and that is worth saying plainly. A grocery chain at 30.4 days is slow; a machine tool distributor at 89 days is fast. The calculator applies the same 30 and 90 to both, because it has no industry input. The label is a rough band, not a judgement, and the ratio itself is the number to compare against a competitor or against your own prior year.

Marginal cost of the next unit, in both directions. From the defaults, each additional $10,000 of ending inventory raises average inventory by $5,000 and drops the ratio: pushing ending inventory from $320,000 to $400,000 raises average inventory to $340,000, cuts turnover to 10.59x and lifts DIO to 34.5 days. In the other direction, a 10% COGS increase to $3,960,000 lifts turnover to 13.20x and cuts DIO to 27.7 days, crossing into the fast band.

Right numerator against wrong numerator, priced. The single most common error is dividing revenue by average inventory instead of COGS. Inventory is carried at cost, so revenue in the numerator inflates the ratio by the gross margin. On these defaults, a business with a 40% gross margin has revenue of $6,000,000 against $3,600,000 of COGS: entering revenue returns 20.00x and 18.3 days against the correct 12.00x and 30.4 days. That is a 67% overstatement of turnover and it would also flip the health label from Typical to Fast-Moving, which is the kind of error that survives a review because the output looks plausible.

One input combination the label handles badly. Set both beginning and ending inventory to zero and the calculator returns 0.00x, 0.0 days, and the label Fast-Moving Inventory. Zero turnover is not fast, it is undefined; the guard that returns zero when average inventory is zero runs before the label test, and the label test then reads 0.0 days as being under 30. Treat any result with zero average inventory as no result at all.

Period sensitivity. Days in period is a straight numerator on DIO and does not touch the turnover ratio. A quarterly view, 90 days with $900,000 of COGS against the same $300,000 average inventory, returns 3.00x and 30.0 days: the ratio falls by four because the period is a quarter of the year, while DIO is essentially unchanged. Comparing a quarterly turnover figure against an annual one without noticing is the second most common error here.

• Obsolescence and write-downs already embedded in the balance. If a company has already written down slow-moving or obsolete inventory before the period-end snapshot, the ratio will not reflect the risk that originally caused the write-down, since the depressed balance now looks smaller and healthier.
• Product mix within a single turnover figure. A single blended turnover ratio hides enormous variation between fast-moving SKUs and slow-moving SKUs sitting in the same warehouse; a retailer could show acceptable overall turnover while carrying significant dead stock in specific categories.
• Seasonality. A business that stocks up heavily ahead of a seasonal peak (holiday retail, agricultural inputs ahead of planting season) can show a distorted turnover ratio if the beginning and ending balances don't bracket the seasonal cycle representatively.
• Consignment and drop-ship arrangements. Inventory a company doesn't actually own, or never physically holds, doesn't appear on its balance sheet, which can make turnover look artificially strong for businesses using these models compared to a traditional retailer holding its own stock.
• The difference between raw materials, work-in-process, and finished goods. A manufacturer's total inventory balance blends all three stages, each of which turns at a different natural rate; the aggregate figure obscures where in the production cycle inventory is actually accumulating.

• Using revenue instead of cost of goods sold in the numerator. This is the most common calculation error and inflates the ratio by roughly the company's gross margin percentage, since revenue is always larger than COGS for a profitable company.
• Comparing turnover across industries without adjustment. A grocery chain might turn inventory 15-20 times per year; an aerospace parts manufacturer might turn inventory 2-3 times per year, and both can be perfectly healthy within their respective industries.
• Ignoring the trend in favor of a single snapshot. A turnover ratio declining quarter over quarter, even if still within a "normal" range for the industry, often signals a demand slowdown or purchasing discipline problem worth investigating before it shows up in gross margin.
• Treating high turnover as unambiguously good. Turnover that's too high relative to competitors can indicate a company is running lean enough to risk stockouts, losing sales to unmet demand rather than genuinely superior inventory management.
• Forgetting the denominator should be an average. Using only the ending inventory balance instead of the average overstates turnover in periods where inventory was rising through the year and understates it where inventory was falling.

• U.S. Small Business Administration, the official authority for the business this calculator relates to. sba.gov

Also consulted: Investopedia, "Inventory Turnover Ratio: What It Is, How It Works, and Formula"; Corporate Finance Institute (CFI), "Inventory Turnover Ratio"; Investopedia, "Days Inventory Outstanding (DIO): Definition and Formula".