House of Calculator

Enter cost of goods sold and opening and closing inventory to see turnover.

Results are estimates for planning. Check the figures before you make a financial or health decision.

Embed this calculator on your website

Free to use. Copy the code and paste it into your page. Please keep the link under the calculator in place: it is how we keep the tool free.

How the Inventory Turnover Calculator works

Inventory turnover = cost of goods sold ÷ average inventory. Average inventory is the opening plus closing stock divided by two.

Days to sell stock = 365 ÷ turnover. A higher turnover means stock sells faster and less cash is tied up, while a very high one can mean stock-outs.

Worked example

With these inputs: Cost of goods sold for the year: 600000; Inventory at the start of the year: 90000; Inventory at the end of the year: 110000.

ResultValue
Inventory turnover6 times a year
Average inventory100,000
Days to sell stock61 days
Stock held for a month of sales2 months

Tips and common mistakes

  • Use cost of goods sold, not sales, so the ratio compares like with like.
  • Compare with your industry. Grocery stock turns over far faster than furniture.
  • Seasonal businesses should average several points in the year, not just two.

Frequently asked questions

What is a good inventory turnover ratio?

It depends on the industry. Retail often sees 4 to 8, while fast-moving grocery items are far higher.

How do I calculate days of inventory?

Divide 365 by the turnover ratio.

What does low turnover mean?

Stock is selling slowly, which ties up cash and risks it going out of date.

Can turnover be too high?

Yes. It may mean you run out of stock and lose sales.

Related calculators