Friday, September 28, 2012

How Fast Is the Cash at Home Depot?

It takes money to make money. Most investors know that, but with business media so focused on the "how much," very few investors bother to ask, "How fast?"

When judging a company's prospects, how quickly it turns cash outflows into cash inflows can be just as important as how much profit it's booking in the accounting fantasy world we call "earnings." This is one of the first metrics I check when I'm hunting for the market's best stocks. Today, we'll see how it applies to Home Depot (NYSE: HD  ) .

Let's break this down
In this series, we measure how swiftly a company turns cash into goods or services and back into cash. We'll use a quick, relatively foolproof tool known as the cash conversion cycle, or CCC for short.

Why does the CCC matter? The less time it takes a firm to convert outgoing cash into incoming cash, the more powerful and flexible its profit engine is. The less money tied up in inventory and accounts receivable, the more available to grow the company, pay investors, or both.

To calculate the cash conversion cycle, add days inventory outstanding to days sales outstanding, then subtract days payable outstanding. Like golf, the lower your score here, the better.

Here's the CCC for Home Depot alongside the comparable figures from a few competitors and peers.

Company

TTM Revenue

TTM CCC

Home Depot $69,507 �48
Amazon.com (Nasdaq: AMZN  ) $43,593 �(14)
Best Buy (NYSE: BBY  ) $50,433 �20
Sears Holdings (Nasdaq: SHLD  ) $42,747 �82

Source: S&P Capital IQ. Dollar amounts in millions. Data is current as of last fully reported fiscal quarter. TTM = trailing 12 months.

For younger, fast-growth companies, the CCC can give you valuable insight into the sustainability of that growth. A company that's taking longer to make cash may need to tap financing to keep its momentum. For older, mature companies, the CCC can tell you how well the company is managed. Firms that begin to lose control of the CCC may be losing their clout with their suppliers (who might be demanding stricter payment terms) and customers (who might be demanding more generous terms). This can sometimes be an important signal of future distress -- one most investors are likely to miss.

While I find peer comparisons useful, I'm most interested in comparing a company's CCC to its prior performance. Here's where I believe all investors need to become trend-watchers. Sure, there may be legitimate reasons for an increase in the CCC, but all things being equal, I want to see this number stay steady or move downward over time.

Source: S&P Capital IQ. Dollar amounts in millions. FY = fiscal year. TTM = trailing 12 months.

Because of the seasonality in some businesses, the CCC for the TTM period may not be strictly comparable to the fiscal-year periods shown in the chart. Even the steadiest-looking businesses on an annual basis will experience some quarterly fluctuations in the CCC. To get an understanding of the usual ebb and flow at Home Depot, consult the quarterly period chart below.

Source: S&P Capital IQ. Dollar amounts in millions. FQ = fiscal quarter.

On a 12-month basis, the trend at Home Depot looks good. At 48.0 days, it is 3.3 days better than the five-year average of 51.3 days. The biggest contributor to that improvement was DPO, which improved 2.8 days compared to the five-year average. That was partially offset by a 0.5-day increase in DIO.

Considering the numbers on a quarterly basis, the CCC trend at Home Depot looks OK. At 46.7 days, it is 4.8 days worse than the average of the past eight quarters. Investors will want to keep an eye on this for the future to make sure it doesn't stray too far in the wrong direction. With quarterly CCC doing worse than average and the latest 12-month CCC coming in better, Home Depot gets a mixed review in this cash-conversion checkup.

Though the CCC can take a little work to calculate, it's definitely worth watching every quarter. You'll be better informed about potential problems, and you'll improve your odds of finding the underappreciated home run stocks that provide the market's best returns.

To stay on top of the CCC for your favorite companies, just use the handy links below to add companies to your free watchlist.

  • Add Home Depot to My Watchlist.
  • Add Amazon.com to My Watchlist.
  • Add Best Buy to My Watchlist.
  • Add Sears Holdings to My Watchlist.

No comments:

Post a Comment