Inventory Turnover Ratio

Inventory turnover is an efficiency/activity ratio which estimates the number of times per period a business sells and replaces its entire batch of inventories. It is the ratio of cost of goods sold by a business during an accounting period to the average inventories of the business during the period (usually a year).

Formula

Inventory turnover ratio is calculated using the following formula:

Inventory Turnover =Cost of Goods Sold
Average Inventories

Cost of goods sold figure is reported on income statement. A quick estimate of average inventories may be made as follows:

Average Inventories
=Beginning Inventories + Ending Inventories
2

The values of beginning and ending inventories appear on a business’ balance sheets at the start and at the end of the accounting period.

Alternatively, inventory turnover may be calculated based on the closing inventories balance where the opening inventories balance is not available or where the inventories balance has not changed significantly over the period.

Inventory turnover ratio is also an input in calculation of days' inventories on hand.

Analysis

Inventory turnover ratio is used to assess how efficiently a business is managing its inventories.

In general, a high inventory turnover indicates efficient operations. A low inventory turnover compared to the industry average and competitors means poor inventories management. It may be an indication of either a slow-down in demand or over-stocking of inventories. Overstocking poses risk of obsolescence and results in increased inventory holding costs.

However, a very high value of this ratio may result in stock-out costs, i.e. when a business is not able to meet sales demand due to non-availability of inventories.

Inventory turnover is a very industry-specific ratio. Businesses which trade perishable goods have higher turnover compared to those dealing in durables. Therefore, a comparison would only be fair if made between businesses in the same industry.

Examples

Example 1:

Calculate inventory turnover and days inventories on hand for ABC, Inc. based on the information given below:

Opening inventories$25,000
Closing inventories$30,000
Cost of goods manufactured$245,000

Solution

Cost of goods sold
= $25,000 + $245,000 – $30,000
= $240,000

Average inventories
= ($25,000 + $30,000) ÷ 2
= $27,500

Inventory turnover ratio
= $240,000 ÷ $27,500
= 8.73

Days inventories outstanding
= 365 ÷ 8.73
= 41.8

Example 2:

Analyze the inventories turnover ratio for Wal-Mart Stores Inc. (NYSE: WMT), Costco Wholesale Corporation (NASDAQ: COST), Caterpillar Inc. (NYSE: CAT) and Deere & Company (NYSE: DE) based on their inventory turnover ratio (as obtained from Morningstar) for the financial year 20X2, 20X3 and 20X4.

20X220X320X4
Walmart8.348.088.11
Costco12.6412.2712.04
Caterpillar3.132.893.2
Deere & Co.5.275.085.42

Solution

This example illustrates the fact that ratio analysis is useful when companies’ ratios are compared with other firms in the same industry or across different periods for a single company.

Inventory turnover ratio of Walmart is comparable with Costco but not with Caterpillar or Deere. Walmart & Costco are retailers of general merchandise while Caterpillar & Deere are manufacturers of heavy machinery. Retailers are required to hold very large volume of inventories, a major portion of which is perishable, which justifies their higher inventory turnover ratio as compared to manufacturers of heavy machinery.

Walmart has been more efficient in its inventories management than Costco. However, Costco’s trend of improvement over the three-year period is more pronounced.

Caterpillar is better than Deere & Co. in inventory management as evident from their inventory turnover ratio. However, their relative trend in inventory turnover ratio corresponds with each other. Inventory turnover ratio for both decreased in 20X3 and then increased again in 20X4. Such trends are attributable to the overall economic growth expectations.

by Irfanullah Jan, ACCA and last modified on

XPLAIND.com is a free educational website; of students, by students, and for students. You are welcome to learn a range of topics from accounting, economics, finance and more. We hope you like the work that has been done, and if you have any suggestions, your feedback is highly valuable. Let's connect!

Copyright © 2010-2024 XPLAIND.com