Skip to content

Accurate calculators, built for Africa.

Inventory Turnover Calculator

Type your cost of goods sold and your stock at the start and end of the period.

Any currency: type its 3-letter code, e.g. USD, NGN, KES, ZAR.

Not sales: the cost of the goods you sold.

Stock at cost at the start of the period.

Stock at cost at the end of the period.

365 for a year.

Amounts in USD.

Stock turnover3.38 times
Days in stock108.1 days

Inventory turnover
Average stock225,000.00
Turnover in the period3.38
Days in stock108.1
  • Formulas (ACCA): average stock = (opening + closing) ÷ 2; turnover = cost of goods sold ÷ average stock; days in stock = average stock ÷ cost of goods sold × days in the period.
  • Days are worked out from unrounded figures.

Results are estimates to help you plan.

A guide to inventory turnover

What the calculator is for

Stock that sits on the shelf ties up cash that could pay suppliers or buy faster-selling goods. Inventory turnover shows how many times your average stock was sold and replaced in a period; days in stock shows how long, on average, an item waits before it is sold.

How it is worked out

  • Average stock = (opening stock + closing stock) ÷ 2.
  • Turnover = cost of goods sold ÷ average stock.
  • Days in stock = average stock ÷ cost of goods sold × the number of days in the period.

These follow ACCA's guides to ratio analysis and working capital, which use cost of sales rather than sales, because stock is valued at cost.

How to use it: an example

A shop's cost of goods sold for the year is KES 760,000. It started the year with KES 200,000 of stock and ended with KES 250,000, so average stock is KES 225,000. Its stock turned over3.38 times, and items sat in stock for 108.1 days on average.

If you only know closing stock

Tick "I only know closing stock". The calculator then uses closing stock in place of the average, as ACCA allows when only year-end stock is known. With the same shop's figures, that gives 3.04 times and 120.1 days. A typed 0 for opening stock is treated as a real 0, not as unknown.

Reading the results

A higher turnover means stock sells faster. What is normal depends on the trade: fresh food can turn over much more often than furniture or spare parts. Compare with your own past figures and with similar businesses. To work out cost of goods sold first, use the Cost of Goods Sold Calculator.

What is not included

Turnover of each product line, and seasonal swings within the period. Results are estimates to help you plan.

Questions

Why cost of goods sold and not sales?

Stock is valued at cost, so comparing it with cost of goods sold keeps both figures on the same basis.

Can I use a shorter period?

Yes. Type the number of days, for example 90 for a quarter, with that quarter's cost of goods sold and stock.

Why don't turnover and days multiply exactly to 365?

They do before rounding. The shown figures are rounded, so working back from them can be a little off.

Related calculators