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 Rockwell Collins (NYS: COL) out of line? To figure that out, start by comparing the company's figures to those from peers and competitors:
Northrop Grumman (NYS: NOC)
Honeywell International (NYS: HON)
Precision Castparts (NYS: PCP)
Source: S&P Capital IQ. Data is current as of latest fully reported quarter. TTM = trailing 12 months.
How is Rockwell Collins doing by this quick checkup? At first glance, not so great. Trailing-12-month revenue increased 3.8%, and inventory increased 19%. Over the sequential quarterly period, the trend looks healthy. Revenue grew 8.9%, and inventory dropped 1.4%.
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 Rockwell Collins? 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, finished goods inventory was the fastest-growing segment, up 11.1%. That can be a warning sign, so investors should check in with Rockwell Collins's filings to make sure there's a good reason for packing the storeroom for this period. On a sequential-quarter basis, each segment of inventory decreased. With inventory segments moving opposite directions for the periods we're considering, this one is a toss-up.
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 Rockwell Collins to My Watchlist.
Add Northrop Grumman to My Watchlist.
Add Honeywell International to My Watchlist.
Add Precision Castparts to My Watchlist.
At the time thisarticle was published Seth Jayson had no position in any company mentioned here at the time of publication. You can view his stock holdings here. He is co-advisor ofMotley Fool Hidden Gems, which provides new small-cap ideas every month, backed by a real-money portfolio. The Motley Fool owns shares of Northrop Grumman. Motley Fool newsletter services have recommended buying shares of Precision Castparts. Try any of our Foolish newsletter services free for 30 days. We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. The Motley Fool has a disclosure policy.
Copyright © 1995 - 2011 The Motley Fool, LLC. All rights reserved. The Motley Fool has a disclosure policy.