How do I calculate the inventory turnover ratio?

By Ryan C. Fuhrmann AAA
A:

Managing inventory levels is important for most businesses and this is especially true for retailers and any company that sells physical goods. The inventory turnover ratio is a key measure for evaluating just how efficient management is at managing company inventory and generating sales from it.

Inventory Turnover

Like a typical turnover ratio, inventory turnover details how much inventory is sold over a period of time. It is calculated as:

Cost of Goods Sold ÷ Average Inventory

Or

Sales ÷ Inventory

Usually, a higher inventory turnover ratio is preferred, as it indicates that more sales are being generated given a certain amount of inventory. Alternatively, for a given amount of sales, using less inventory to do so will improve the ratio.

Sometimes a very high inventory ratio could result in lost sales, as there is not enough inventory to meet demand. It is always important to compare the inventory turnover ratio to the industry benchmark to asses if a company is successfully managing its inventory. 

Days Sales of Inventory (DSI) or Days Inventory

The inventory turnover ratio on its own takes some time to put into perspective. Going a step further, days sales of inventory, also known as days inventory, is simply the inverse of the inventory turnover ratio multiplied by 365. This puts the figure into a daily context, as follows:

(Average Inventory ÷ Cost of Goods Sold) x 365   

DSI significantly changes between industries and it is important to compare it against peer companies. Businesses that sell perishable products like supermarkets or groceries stores have lower inventory days than business that sell furniture or appliances. 

Example

For the fiscal year ended Jan. 2014, Wal-Mart Stores Inc (WMT) reported annual sales of $476.3 billion, year-end inventory of $44.9 billion, and annual cost of goods sold (or cost of sales) of $358.1 billion. 

Its inventory turnover for the year equals:

$358.1 billion ÷ $44.9 billion = 8.0

Its days inventory equals:

(1 ÷ 8) x 365 = 46 days.

This indicates that Wal-Mart sells its entire inventory within a 46-day period, which is quite impressive for such a large, global retailer.

The Bottom Line

The inventory turnover ratio is one of the best indicators of how efficiently a company is turning its inventory into sales. Even better, the days inventory ratio puts it into a daily context.

At the time of writing, Ryan C. Fuhrmann did not own shares in any of the companies mentioned in this article.

RELATED FAQS

  1. What does a mutual fund's beta coefficient measure?

    Evaluate the risk associated with a particular mutual fund by determining its beta coefficient, which illustrates the fund's ...
  2. What are some examples of how cash flows can be manipulated or distorted?

    Read about some of the most common accounting techniques that can be used to manipulate the operating cash flow on a company's ...
  3. Where can I find the balance sheet of a country?

    Learn where to find balance sheets for different countries. Explore how different accounting standards may affect the quality ...
  4. What are some examples of industries that cannot claim cost of goods sold (COGS)?

    Discover which types of businesses are not allowed to list cost of goods sold on their income statement or claim their COGS ...
RELATED TERMS
  1. Overall Turnover

    A synonym for total revenues, commonly used in Europe and Asia. ...
  2. Working Capital Turnover

    A measurement comparing the depletion of working capital to the ...
  3. Inventory Turnover

    A ratio showing how many times a company's inventory is sold ...
  4. Turnover

    1. In accounting, the number of times an asset is replaced during ...
  5. Days Sales Of Inventory - DSI

    A financial measure of a company's performance that gives investors ...
  6. Best's Capital Adequacy Relativity (BCAR)

    A rating of an insurance company’s balance sheet strength. Best’s ...
Related Articles
  1. Fundamental Analysis

    SIC Vs. NAIC -An Introduction To Industry ...

  2. Mutual Funds & ETFs

    Investing In New York City REITs

  3. With so many credit cards in daily use, credit card issuers have grown with their businesses.
    Stock Analysis

    The Big Credit Card Companies Have Room ...

  4. Investing Basics

    Why Wall Street Is A Key Player In The ...

  5. You may not be able to trade penny-stock options, but small-caps and micro-caps could be close enough. Here's a primer on accessing penny stocks.
    Options & Futures

    Penny Stocks, Options and Trading on ...

Trading Center