Inventory turnover ratio formula with a worked example

Inventory turnover compares the cost of goods sold during a period with the average cost value of inventory held during that same period. It expresses how many times that average stock investment moved through sales. The result only makes sense when the dates, product scope and valuation basis match.

Use the free turnover calculator once you have those inputs. This guide concentrates on preparing them and interpreting the arithmetic. For the share of available units sold, use the separate sell-through guide; a unit percentage and a cost-based ratio answer different questions.

How to calculate inventory turns

Divide period cost of goods sold by average inventory value at cost. Express the answer as turns for that period. For example, a result from quarterly figures is a quarterly result; it should not be described as annual performance without an explicit additional calculation and assumptions.

Shopify's turnover guide describes the cost-based relationship. Keep the calculation alongside its date range and the source of each input. A number such as 4.0 is difficult to assess when the reader cannot tell whether it refers to a month, quarter or year, or which products were included.

Use cost of goods sold consistently

Use the cost of the goods sold during the period, rather than their ticket prices or sales revenue. Keep the amount on the same accounting basis as the inventory value used below. Mixing a retail-price numerator with a cost-based denominator changes the meaning of the result.

Obtain the cost figure from the records your business uses for that purpose. Do not estimate it by subtracting unrelated expenses from revenue. If the source figure includes a different product group or date window, resolve that mismatch first. A precise calculator cannot correct inputs that describe different parts of the business.

Calculate average inventory at cost

A simple average adds opening inventory value to closing inventory value and divides by two. Both values should represent the same product scope and valuation basis. This approach is straightforward when the period is reasonably stable and those observations are representative.

If stock swings substantially within the period, consider whether more frequent observations provide a better picture. A large delivery between the opening and closing dates may be almost invisible in a two-point average. Keep the method consistent when comparing periods, and state it clearly when a change in the averaging method affects the result.

Work through a stock turnover example

Consider an illustrative annual period with opening stock at cost of $24,000 and closing stock at cost of $36,000. The simple average is ($24,000 + $36,000) ÷ 2 = $30,000. Suppose the matching annual cost of goods sold is $120,000.

The calculation is $120,000 ÷ $30,000 = 4 turns for that year. These are fictional figures to demonstrate the arithmetic, not a benchmark for a particular store. Change either input in the calculator to explore its effect, while keeping in mind that the real business reasons for a change need separate investigation.

Interpret a low turnover result

A lower result can reflect more average stock relative to the cost of goods sold. Investigate buying quantities, product mix, seasonal stock building and items that have stopped moving. The ratio points toward a question; it does not explain the cause on its own.

Check whether the comparison period included a planned opening assortment, a supplier minimum or a temporary buildup before a busy season. Those circumstances differ from repeatedly buying products that customers do not want. Use the inactive-stock review to investigate individual items rather than making a broad assortment decision from one aggregate number.

Interpret a high turnover result

A higher result can reflect stronger movement, less average inventory or both. It is not automatically better if the store repeatedly runs out of products that customers want. Look at availability and the work required to keep receiving small deliveries alongside the ratio.

Review whether the same products were in stock throughout the period. If the business reduced inventory sharply near the closing date, a simple average may affect the comparison. A useful interpretation connects the calculation to actual stock and purchasing conditions, rather than celebrating a larger number without checking how it arose.

Compare seasonal inventory periods fairly

Compare like periods with a consistent calculation method and product scope. A holiday quarter and a quiet quarter may have deliberately different stock levels. A change in store count or a new category can alter the business-wide result even when established products behave similarly.

Keep a short note of major differences next to your comparison. Separate a change in inputs from a change in method. Shopify's inventory formula overview provides broader context for stock measures, but your own dates and assumptions determine whether two calculated values support a fair comparison.

Convert annual turns into inventory days

For an annual calculation using a 365-day basis, dividing 365 by annual turns gives a corresponding average-days measure. In the fictional four-turn example, 365 ÷ 4 = 91.25 days. State the day basis and period rather than silently treating every calculation as annual.

This is different from dividing today's units on hand by recent daily unit sales. The stock-coverage tool performs that current-quantity estimate. The measures use different inputs and time perspectives, so avoid presenting one as a replacement for the other simply because both answers are expressed in days.

Keep sales reports separate from valuation

The headoffis workspace is coming soon. Its Analytics page compares recorded sales and shows current operational snapshots; it does not calculate inventory valuation, cost of goods sold or profit. A sales-value export is therefore not a ready-made numerator for this cost-based measure.

Use the standalone calculator with figures from your own cost records and keep the result with its assumptions. Read the Analytics instructions to understand what the app reports, then join the waitlist for launch updates. Reliable inputs matter more than extra decimal places in the final ratio.

← All posts