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.

$$\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2}$$

Step 2: Inventory Turnover.

$$\text{Inventory Turnover} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}}$$

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.

$$\text{DIO} = \frac{\text{Days in Period}}{\text{Inventory Turnover}}$$

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.

• 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.

• 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"