Here at The Motley Fool, I've long cautioned investors to keep a close eye on inventory levels. It's a part of my standard diligence when searching for the market's best stocks. I think a quarterly checkup can help you spot potential problems. For many companies, products that sit on the shelves too long can become big trouble. Stale inventory may be sold for lower prices, hurting profitability. In extreme cases, it may be written off completely and sent to the shredder.
In this series, I examine inventory using a simple rule of thumb: Inventory increases ought to roughly parallel revenue increases. If inventory bloats more quickly than sales grow, this might be a sign that expected sales haven't materialized.
Is the current inventory situation at Dell (NAS: DELL) out of line? To figure that out, start by comparing the company's figures to those from peers and competitors:
Apple (NAS: AAPL)
Alcatel-Lucent (NYS: ALU)
NetApp (NAS: NTAP)
Source: S&P Capital IQ. Data is current as of latest fully reported quarter. TTM = trailing 12 months.
How is Dell doing by this quick checkup? At first glance, not so great. Trailing-12-month revenue increased 1.7%, and inventory increased 8%. Over the sequential quarterly period, the trend looks OK but not great. Revenue dropped 1.9%, and inventory grew 3.8%.
I don't stop my checkup there, because the type of inventory can matter even more than the overall quantity. There's even one type of inventory bulge we sometimes like to see. You can check for it by examining the quarterly filings to evaluate the different kinds of inventory: raw materials, work-in-progress inventory, and finished goods. (Some companies report the first two types as a single category.)
A company ramping up for increased demand may increase raw materials and work-in-progress inventory at a faster rate when it expects robust future growth. As such, we might consider oversized growth in those categories to offer a clue to a brighter future, and a clue that most other investors will miss. We call it "positive inventory divergence."
On the other hand, if we see a big increase in finished goods, that often means product isn't moving as well as expected, and it's time to hunker down with the filings and conference calls to find out why.
What's going on with the inventory at Dell? I chart the details below for both quarterly and 12-month periods.
Source: S&P Capital IQ. Data is current as of latest fully reported quarter. Dollar amounts in millions. FY = fiscal year. TTM = trailing 12 months.
Source: S&P Capital IQ. Data is current as of latest fully reported quarter. Dollar amounts in millions. FQ = fiscal quarter.
Let's dig into the inventory specifics. On a trailing-12-month basis, raw materials inventory was the fastest-growing segment, up 30.6%. On a sequential-quarter basis, finished goods inventory was the fastest-growing segment, up 7.7%. That can be a warning sign, so investors should check in with Dell's filings to make sure there's a good reason for packing the storeroom for this period. Although Dell shows inventory growth that outpaces revenue growth, the company may also display positive inventory divergence, suggesting that management sees increased demand on the horizon.
Foolish bottom line
When you're doing your research, remember that aggregate numbers such as inventory balances often mask situations that are more complex than they appear. Even the detailed numbers don't give us the final word. When in doubt, listen to the conference call, or contact investor relations. What at first looks like a problem may actually signal a stock that will provide the market's best returns. And what might look hunky-dory at first glance could actually be warning you to cut your losses before the rest of the Street wises up.
I run these quick inventory checks every quarter. To stay on top of the inventory story at your favorite companies, just use the handy links below to add companies to your free watchlist, and we'll deliver our latest coverage right to your inbox.
Add Dell to My Watchlist.
Add Apple to My Watchlist.
Add Alcatel-Lucent to My Watchlist.
Add NetApp to My Watchlist.
At the time thisarticle was published
Copyright © 1995 - 2011 The Motley Fool, LLC. All rights reserved. The Motley Fool has a disclosure policy.