# Inventory Turnover Ratio  ## What is the Inventory Turnover Ratio?

Inventory Turnover Ratio measures how fast the company replaces a current batch of inventories and transforms them into sales. Higher ratio indicates that the company’s product is in high demand and sells quickly, resulting in lower inventory management costs and more earnings.

The inventory turnover ratio varies from industry to industry. For example, a clothing retailer company may have a turnover of 5 to 8, whereas an automotive parts company may have an inventory turnover of 45 to 50.

### Inventory Turnover Ratio Formula

Inventory Turnover Ratio Formula = Cost of Goods Sold / Average Inventory

For eg:
Source: Inventory Turnover Ratio (wallstreetmojo.com)

### Example

Let’s take a simple example to illustrate this.

You can download this Inventory Turnover Ratio Excel Template here – Inventory Turnover Ratio Excel Template

Cool Gang Inc. has the following information –

• Cost of Goods Sold – \$600,000
• The beginning inventory – \$110,000
• The ending inventory – \$130,000

Find out the inventory ratios.

The average inventory of Cool Gang Inc. would be = (The beginning inventory + the ending inventory)/2 = (\$110,000 + \$130,000)/2 = \$240,000/2 = \$120,000.

Using the inventory ratio, we get –

• Inventory ratio = Cost of Goods Sold / Average Inventories
• Or, Inventory ratio= \$600,000 / \$120,000 = 5.

By comparing the inventory turnover ratios of similar companies in the same industry, we would be able to conclude whether the inventory ratio of Cool Gang Inc. is higher or lower.

### Colgate’s Example

In this example, we take a real-life example of Colgate. Below is the snapshot of Inventory Turnover Calculations. You may download this excel sheet from . Colgate’s inventory consists of three – Raw material and supplies, work in progress, and finished goods.

Historically, Colgate’s inventory turnover has been in the range of 5x-6x. If we observe closely, Colgate’s Inventory turnover was a bit lower in the period of 2013-2015. This indicates that Colgate is taking a bit longer to process its .

### Interpretation

Inventory turnover is a great indicator of how a company is handling its inventory. If an investor wants to check how well a company is managing its inventory, she would look at how higher or lower the inventory turnover ratio of the company is.

When Inventory Turnover Ratio is High – It means that the company has been managing its inventory quite well, and there are lesser and fewer chances of obsolescence.

When Inventory Turnover Ratio is Low – If the inventory turnover of a company is very low, it indicates that the company’s products are not often sold in the market, and inventory of the company becomes a slow-moving inventory, which leads to higher inventory costs and fewer profits.

To improve its ratio, the company can adopt the following strategies:

• Review strategies relating to the pricing of products.
• Try to improve sales by using marketing techniques.
• Analyze the fast-moving inventory and slow-moving inventory
• Improve bargain power and review the purchase price regularly
• Understand the customers’ needs and try to get an order from customers well in advance.

But how would you understand whether the ratio is higher or lower?

You would understand it by looking at the inventory ratio of similar companies in the same industry. If you take an average of the inventory turnover ratio, you would understand the base. On this base, you can measure whether the inventory ratio of a company is higher or lower.

### Recommended Articles

This article has been a guide to the Inventory Turnover Ratio and its meaning. Here we discuss the formula to calculate the Inventory Turnover along with examples & excel templates. You may also have a look at these articles below to learn more about Financial Analysis