Skip to content

Calculations

Inventory turnover: calculate turns and inventory days

Inventory turnover compares period cost of sales with average carrying value of inventory. Our example uses a simple beginning-and-ending average. The calculation describes an aggregate measure rather than how long each individual item stayed on a shelf.

What you will learn

  • Choose cost of sales as numerator under the stated definition.
  • Calculate a two-point inventory average.
  • State the period when converting turns into illustrative inventory days.

Choose the same period and valuation basis

The fictional company has annual revenue of SEK 1,000 million and cost of sales of 600 million. Inventory carrying value is 80 million at the year’s beginning and 120 million at its end. The year is twelve months and our time conversion uses 365 days. All amounts are invented teaching data.

Our inventory definition uses cost of sales rather than sales revenue. Inventory is carried as an asset, while sales revenue may include a margin. Choosing revenue as numerator would therefore create a different relationship. Read the inventory note and cost line when comparing a real company, and check that units match.

If the table does not fit, scroll it sideways.

Fictional full year; all amounts in SEK million
FieldAmount
RevenueSEK 1,000 million
Cost of salesSEK 600 million
Inventory at the year’s startSEK 80 million
Inventory at the year’s endSEK 120 million

An average of SEK 100 million gives six turns

The two-point average is (80 + 120) / 2 = SEK 100 million. Inventory turnover is 600 / 100 = 6 times during the year. Dividing only by ending inventory gives 600 / 120 = 5 times. The latter uses a different base from the one we selected.

Revenue of 1,000 million divided by the same average would give ten times. That is not the measure under our definition. Record the cost line and averaging method beside the answer. If average inventory is zero, division is undefined; a company without this kind of inventory needs other relevant supporting data.

Inventory days are a derived estimate

Our annual model produces illustrative average inventory days of 365 / 6 ≈ 60.83 days. This converts the aggregate measure. We have not followed individual items from purchase to sale and cannot state that every item stayed in inventory for exactly 60.83 days.

In a separate six-month example, cost of sales is SEK 300 million and average inventory 75 million. The ratio is four turns during those six months. With that period specified as 182 days, conversion gives 182 / 4 = 45.5 days. It is not four turns per full year and does not establish the next half-year’s pace.

Investigate why the ratio changes

A two-point average can miss large seasonal inventory peaks. A changed ratio may also need explanation through product mix, deliveries and reported write-downs. We state no generally desirable level. A higher number alone does not establish sufficient stock, increasing profit or timely customer delivery.

Investiq’s company guide helps check identity and period for your material. This inventory calculation uses report components and does not promise an inventory-analysis feature in the app. Continue with gross margin for the relationship between revenue and cost of sales, or working capital for inventory’s place in the wider balance sheet.

Try it yourself

Another full-year dataset shows cost of sales of SEK 420 million and inventory of 60 million at the beginning and 80 million at the end. Use a two-point average and 365 days. Calculate turnover and illustrative inventory days.

Show the solution and explanation

Average inventory is SEK 70 million. Turnover is six times during the year and illustrative inventory days approximately 60.83.

(60 + 80) / 2 = 70; 420 / 70 = 6; 365 / 6 ≈ 60.83. The result describes the specified year rather than each individual item.

Check your understanding

Why is sales revenue excluded from this ratio?

The definition compares cost of sales with carrying value of inventory. Sales revenue may include a margin and produces another measure.

Can four six-month turns be directly compared with six annual turns as the same period measure?

No. The periods differ. State the period and make an explicit time conversion if the comparison requires it.

Practise with virtual money

Try what you just learned in a practice portfolio with virtual money. You don't deposit any real money.

How the practice portfolio works

More lessons on this topic

Sources and examples

The sources support the factual explanations. Calculations and exercises were created for this lesson. Amounts and price changes are invented unless stated otherwise.

This material is educational and does not recommend securities to buy. A simulated result does not guarantee a future result.

Practice now. Invest later.

Investiq is live

Download on the App Store

Free · For iPhone · Now on the App Store