FOOL'S SCHOOL DAILY Q&A

Understanding Inventory Turnover

Email this article Email this page
Format for Printing Format for printing
Request Reprints Reuse/Reprint
By Selena Maranjian (TMF Selena)
July 8, 2003

Q. What's "inventory turnover"?

A. It's a measure that will give you a sense of how quickly a company's products are flying off the shelves. Here's how you'd crunch this number:

From the company's income statement, find the "cost of goods sold" (or COGS), which is usually listed near the top, below "sales" (which are also called "revenues"). You'll want the last 12 months' worth. If the fiscal year has just ended, you can use the figures in the annual report or 10-K report. If it's mid-year, just re-create the last year's results by adding together the numbers from the last four quarters. Once you have this number, jot it down.

Next, you need to calculate the average value of inventory for the 12-month period you're looking at. If, for example, you're using the cost of goods sold for the 2002 fiscal year, you'd want to take the inventory value from the end of fiscal 2001 and average it with the inventory value from the end of 2002. This way, your numbers address the same time period -- the duration of fiscal 2002.

Once you have the cost of goods sold, divide it by the average inventory, and you'll get the inventory turnover rate. A company with high and growing inventory turnover rates would appear to be well managed, freeing up its working capital for other uses.

As an example, consider Wal-Mart (NYSE: WMT). For fiscal 2002, it reported on its income statement a total cost of goods sold of $192 billion (yes, billions -- yowza). Moving to its balance sheet, we see inventory at the end of fiscal 2002 of $24.9 billion, and $22.6 billion for 2001. Average those together and we get $23.75 billion. Now, dividing COGS by average inventory, we get 8.1. That's Wal-Mart's inventory turnover for the period, showing us that essentially, the company filled and sold everything on its shelves about eight times in the year.

To make more sense of that number, compare it with a competitor. Target's (NYSE: TGT) inventory turnover, for example, was 6.5 -- which seems solid but isn't as strong as Wal-Mart's.

To learn more about how to make sense of financial statements in our "Crack the Code: Read Financial Statements Like a Pro" how-to guide (also known as an online seminar). Give any of our how-to guides a whirl. More than 90% of those who've taken them have consistently given them high marks -- and besides, we offer a satisfaction guarantee, or your money back.

Also of interest might be our Fool's School. And at our Broker Center, you can learn all about brokerages and find one that's right for you.

If you have any questions, thoughts or opinions on this column, share them with others on our Ask the Fool discussion board.

This question and answer is adapted from The Motley Fool Money Guide: Answers to Your Questions About Saving, Spending and Investing. For answers to this and 499 other common money questions, check it out -- it's a handy resource.