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.
The calculator could not start. The worked example below uses the example figures.
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,000541,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,00057,000 ÷ 541,500 = 0.1052630.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,050462,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,05043,050 ÷ 462,000 = 0.0931820.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.
The chart’s figures as a table
| Year | Stock turnover (number of times) | Stock turnover (number of days) |
|---|---|---|
| Previous year | 10.73 times | 34.01 days |
| Latest year | 9.50 times | 38.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.
| Change | 10% lower | 10% higher |
|---|---|---|
| Cost of sales | 8.55 times | 10.45 times |
| Closing stock | 10.09 times | 8.97 times |
| Opening stock | 9.91 times | 9.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
- Notes 3.6 Efficiency ratio analysis The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- Practice Stock turnover (number of times), a practice question Fresh fictional figures, checked as you answer, with the working and the usual slips. Paper 2 style, the platform’s own.
- On a case Ratio desk (Halden Distribution) The same idea worked on a fictional case at the Finance Desk.
- Register Stock turnover (number of times), worked on a case The calculation in eight parts, with the errors that cost marks.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/stock-turnover/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.