Financial Laboratory · Ratios

Stock turnover

How quickly does stock sell? (Also called inventory turnover.)

Back to 3.6 Efficiency ratio analysis

  • IB 3.6 Efficiency ratio analysis
  • HL only
  • Formula as on the guide’s formula sheet
  • Simulated data Example: Emberly Roasters, fictional

As printed on the guide’s formula sheet (p. 64), in both its forms, number of times and number of days, with average stock = (opening stock + closing stock) ÷ 2. The guide calls it stock turnover; inventory turnover is the same ratio. The 365 in the formula assumes a full year’s figures.

The calculator

Example figures: Emberly Roasters, a fictional business. Simulated data.

Previous year
Latest year
Currency

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars.

The figures

Cost of sales, previous year
$462,000
Opening stock, previous year
$38,900
Closing stock, previous year
$47,200
Cost of sales, latest year
$541,500
Opening stock, latest year
$47,200
Closing stock, latest year
$66,800

Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.

Result

These results are for the last complete figures. Correct the figure marked in the inputs to update them.

Stock turnover (number of times), latest year

9.50 times

38.42 days on average; −1.23 times on the previous year; worse

Stock turnover (times), previous year
10.73 times
Stock turnover (days), latest year
38.42 days+4.41 days on the previous year
Stock turnover (days), previous year
34.01 days
Change, other things equal
Worsehigher is better

Section 01: The formula and the working

Each formula in the guide’s words, then the working with the figures above, step by step.

Stock turnover (number of times) = (cost of sales) ÷ (average stock)

As printed on the guide’s formula sheet (p. 64).

Stock turnover (number of days) = (average stock) ÷ (cost of sales) × 365

where average stock = (opening stock + closing stock) ÷ (2)

As printed on the guide’s formula sheet (p. 64).

Stock turnover (number of times), latest year

Given
  • Cost of sales ($): 541,500
  • Opening stock ($): 47,200
  • Closing stock ($): 66,800
Formula
Stock turnover (number of times) = cost of sales ÷ average stock, where average stock = (opening stock + closing stock) ÷ 2
Substitution
= 541,500 ÷ ((47,200 + 66,800) ÷ 2)
Working
Average stock = (47,200 + 66,800) ÷ 2 = 57,000
541,500 ÷ 57,000 = 9.5000
Answer
9.50 times
Unit
times a year
Interpretation
Stock is used and replaced 9.50 times a year on average.
Business implication
Stock turnover (number of times) fell from 10.73 times in the previous year to 9.50 times in the latest year, a change of 1.23.

Stock turnover (number of days), latest year

Given
  • Cost of sales ($): 541,500
  • Opening stock ($): 47,200
  • Closing stock ($): 66,800
Formula
Stock turnover (number of days) = (average stock ÷ cost of sales) × 365
Substitution
= (((47,200 + 66,800) ÷ 2) ÷ 541,500) × 365
Working
Average stock = (47,200 + 66,800) ÷ 2 = 57,000
57,000 ÷ 541,500 = 0.105263
0.105263 × 365 = 38.42
Answer
38.42 days
Unit
days
Interpretation
Stock is used and replaced 38.42 times a year on average.
Business implication
Stock turnover (number of days) rose from 34.01 days in the previous year to 38.42 days in the latest year, a change of 4.41 days.
Stock turnover (number of times), previous year
Given
  • Cost of sales ($): 462,000
  • Opening stock ($): 38,900
  • Closing stock ($): 47,200
Formula
Stock turnover (number of times) = cost of sales ÷ average stock, where average stock = (opening stock + closing stock) ÷ 2
Substitution
= 462,000 ÷ ((38,900 + 47,200) ÷ 2)
Working
Average stock = (38,900 + 47,200) ÷ 2 = 43,050
462,000 ÷ 43,050 = 10.7317
Answer
10.73 times
Unit
times a year
Interpretation
Stock is used and replaced 10.73 times a year on average.
Business implication
Compare it with the latest year’s working above.
Stock turnover (number of days), previous year
Given
  • Cost of sales ($): 462,000
  • Opening stock ($): 38,900
  • Closing stock ($): 47,200
Formula
Stock turnover (number of days) = (average stock ÷ cost of sales) × 365
Substitution
= (((38,900 + 47,200) ÷ 2) ÷ 462,000) × 365
Working
Average stock = (38,900 + 47,200) ÷ 2 = 43,050
43,050 ÷ 462,000 = 0.093182
0.093182 × 365 = 34.01
Answer
34.01 days
Unit
days
Interpretation
Stock is used and replaced 34.01 times a year on average.
Business implication
Compare it with the latest year’s working above.

Section 02: The chart

Drawn from the figures above, with every value also in a table.

Stock turnover (number of times) in each yearStock turnover (number of times): Previous year 10.73 times; Latest year 9.50 times. Higher is better, other things equal.0×5×10×15×Previous yearPrevious year: 10.73 times10.73 timesLatest yearLatest year: 9.50 times9.50 timesHigher is better, other things equal.
Chart Stock turnover (number of times) in each year, measured from zero. The latest year is the darker bar.
The chart’s figures as a table
Stock turnover (number of times) by year
YearStock turnover (number of times)Stock turnover (number of days)
Previous year10.73 times34.01 days
Latest year9.50 times38.42 days

Section 03: What moves the ratio

The latest year’s stock turnover (number of times) (9.50 times) when one figure, or one pair of figures, changes by 10 per cent and the rest stay as entered.

Stock turnover (number of times), latest year, after a 10% change
Change10% lower10% higher
Cost of sales8.55 times10.45 times
Closing stock10.09 times8.97 times
Opening stock9.91 times9.12 times

Reading. Of these, a change in cost of sales moves it most: from 8.55 times at 10% lower to 10.45 times at 10% higher. The guide uses average stock, so a change in either opening or closing stock moves the ratio.

Section 04: What it means

For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.

What the number means

Stock is used and replaced 9.50 times a year on average. On average an item sits in stock for 38.42 days before it is used or sold.

What to compare it with

Stock turnover (number of times) fell from 10.73 times in the previous year to 9.50 times in the latest year, a change of 1.23. Compare it across years and with similar businesses, and with how long the product lasts: a slower turnover than before can mean slow-selling or ageing stock, or a deliberate build-up before a busy season.

Why benchmarks vary

A business selling perishable goods, such as a bakery or a grocer, turns its stock over many times a year; a jeweller or a car dealer may turn it over only a few times. A service business may hold almost no stock, so the ratio tells it little.

What a manager might do

Options for a manager, not IB requirements; each has a cost or a risk to weigh.

  • Hold less stock: order more often in smaller amounts, or move towards just-in-time where suppliers are reliable.
  • Clear slow-moving lines, even at a discount, to release cash.
  • Improve demand forecasting; the risk of cutting stock too far is running out and losing sales.

Section 05: Learn more