Home › Finance › Inventory Turnover Calculator

Inventory Turnover Calculator

This inventory turnover calculator shows how many times a business sells through its stock in a period and how many days, on average, stock sits before it's sold.

Formulas

Average inventory = (opening + closing) ÷ 2
Inventory turnover = COGS ÷ average inventory
Days sales of inventory = days in period ÷ turnover

Example

A shop with $500,000 cost of goods sold and inventory of $80,000 at the start and $120,000 at the end has average inventory of $100,000, so turnover is 5 times a year and stock sits for about 73 days.

Tips

  • Use cost of goods sold, not sales revenue; revenue includes your markup and overstates turnover.
  • Compare turnover with businesses in the same industry; groceries turn much faster than furniture.
  • Check pricing with the margin calculator.

Frequently asked questions

What is a good inventory turnover ratio?

It depends on the industry. Higher usually means stock sells quickly, but very high turnover can mean you're running out of stock.

Why use COGS instead of sales?

Inventory is recorded at cost, so dividing cost by cost keeps the ratio consistent.

How do I calculate monthly turnover?

Use one month's COGS and set days in period to 30.

Written and checked by Vijay. Last updated .