Inventory Turnover Ratio: Formula and Example

The inventory turnover ratio shows how many times a business sells and replaces its inventory during a period. Enter cost of goods sold and average inventory to calculate the ratio, expressed as turns per period.

Formula

Inventory turnover ratio = Cost of goods sold ÷ Average inventory. Average inventory is commonly calculated as (Beginning inventory + Ending inventory) ÷ 2. In the calculator, c is cost of goods sold for the selected period, in dollars; b is inventory value at the period’s beginning, in dollars; and e is inventory value at the period’s end, in dollars. The outputs are the turnover ratio in turns for that period and average inventory in dollars.

Both values in the main formula must use the same currency and inventory valuation basis. The ratio is dimensionless: dollars divided by dollars. Its time period is supplied by the cost-of-goods-sold figure. If COGS covers a year, the result is annual turns; if it covers a quarter, it is quarterly turns.

Worked Example

Using the calculator’s default values:

1. Beginning inventory = $20,000; ending inventory = $40,000.
2. Average inventory = ($20,000 + $40,000) ÷ 2 = $30,000.
3. Cost of goods sold = $120,000.
4. Turnover = $120,000 ÷ $30,000 = 4.00 turns for the period covered by COGS.

The calculator therefore returns 4.00 turns and average inventory of $30,000. If the $120,000 of COGS is for a full year, the business turned its average inventory about four times that year.

What the Ratio Measures

Inventory turnover relates the cost assigned to goods sold during a period to the average value of goods held. It is used to assess how quickly stock moves through a business and to compare results across periods or with comparable businesses. A higher ratio often means inventory is moving more quickly, while a lower ratio can indicate slower sales, excess stock, or a deliberate decision to keep more goods available.

Turnover is not a direct measure of sales revenue or profit. The numerator is COGS, not sales, because inventory is recorded as an asset at cost and is generally recognized as an expense when sold. Using revenue instead can inflate the ratio and make it inconsistent with the inventory valuation in the denominator.

Choosing the Period and Inventory Figures

Choose a period that matches the business question. Annual figures are useful for a broad view; monthly or quarterly calculations can reveal changes sooner, but seasonal businesses may show large swings. When comparing periods, use the same length of time and accounting approach.

The simple average of beginning and ending inventory is widely used, but it can miss substantial fluctuations inside the period. If inventory records are available at regular intervals, a more representative average can be calculated from monthly or daily balances. For example, a business that builds stock before a holiday season may have a much higher midyear inventory than its two endpoint balances suggest.

• Use inventory values measured on the same basis, such as consistent treatment of costs and write-downs.
• Include the inventory relevant to the COGS figure; avoid mixing product categories or business units without a clear reason.
• Use beginning inventory from the start of the period and ending inventory from its end.
• Make sure COGS and inventory figures are in the same currency and accounting units.

How to Interpret the Result

A ratio of 4 for a year means COGS was four times the average inventory value during that year. It does not mean every individual item was sold exactly four times, nor that stock was replenished on a perfectly even schedule. The ratio summarizes the whole inventory pool.

There is no universally ideal turnover figure. Grocery goods, industrial equipment, and seasonal clothing have different sales patterns, lead times, shelf lives, and stocking needs. A useful interpretation compares a company with its own history, its operating plan, and businesses with similar products and supply chains.

Very high turnover may reflect strong sales and efficient stock management, but it can also mean inventory is too lean. Frequent stockouts can cause lost sales or delay orders. Very low turnover may tie up cash in slow-moving goods, but a planned buffer may be sensible where replenishment is uncertain. Check the ratio alongside stock availability, margins, sales trends, and aging reports rather than treating it as a standalone performance score.

Common Mistakes and Limits

• Using revenue instead of COGS: the standard inventory turnover formula uses COGS.
• Using ending inventory alone: this can distort the result when stock changes over the period; average inventory is usually more informative.
• Comparing unlike periods: a quarterly ratio is not directly comparable to an annual ratio unless you account for the different period length.
• Ignoring seasonality: two endpoint balances may not reflect typical inventory during the period.
• Rounding too early: keep precise figures through the calculation and round the final ratio for presentation.

The ratio also depends on accounting estimates and how costs are assigned to inventory and COGS. Differences in product mix, business models, and accounting practices can limit comparisons. It describes past activity; by itself, it does not predict future sales or identify why stock moved at a particular pace.

Frequently Asked Questions

What is a good inventory turnover ratio?
There is no single good figure for every business. Compare it with the company’s past results and with similar businesses, while considering stockouts, lead times, and product characteristics.

Should I use sales or cost of goods sold?
Use cost of goods sold in the standard formula. COGS measures inventory at cost, making it more consistent with inventory values than sales revenue.

How do I calculate average inventory?
A common method is to add beginning and ending inventory for the period and divide by two. If balances fluctuate significantly, use more frequent inventory figures to estimate the average.

How do I convert turnover into days?
Divide the number of days in the period by the turnover ratio. For example, for an annual ratio, use the chosen year length (often 365 days); the result estimates average days’ inventory, not the exact age of every item.

Can the ratio be calculated for a quarter?
Yes. Divide quarterly COGS by average inventory for that quarter. Label the result as quarterly turns, and do not compare it directly with annual turns without adjusting for period length.

Related

• 3D Printing Price Calculator: Estimate Print Cost
• Calculator Gas Cost: Estimate a Trip’s Fuel Expense
• Calculating Real GDP: Formula and Example

in c | Cost of goods sold | $ | 120000 | 0
in b | Beginning inventory | $ | 20000 | 0
in e | Ending inventory | $ | 40000 | 0
out t | Inventory turnover ratio | turns | c / ((b + e) / 2) | 2
out d | Average inventory | $ | (b + e) / 2 | 2