In an earlier post, we examined The Home Depot's (NYSE: HD) Income Statement for the second quarter of 2009 and compared it to our "look-ahead" estimates. Earnings in this period, which ended 2 August, fell from $0.71 to $0.66 per share.Home Depot is the largest retailer of do-it-yourself merchandise, which includes building materials, home improvement supplies, and lawn and garden products.
We have since mined Home Depot's financial statements in the earnings announcement to update the metrics we use to assess Cash Management, Growth, Profitability and Value. This post reports on these metrics and the Financial Gauge scores.
The press release included an Income Statement, a condensed Balance Sheet, and some limited Cash Flow data, but no Cash Flow Statement. Since some undisclosed details are needed to compute the gauge scores, we had to make certain estimates for this analysis.We will adjust the scores after Home Depot files a complete 10-Q report with the SEC.
In the mean time, Home Depot's preliminary GCFR gauge scores are as follows:
- Cash Management: 6 of 25 (down from 7 in April)
- Growth: 3 of 25 (up from 0)
- Profitability: 8 of 25 (unchanged)
- Value: 7 of 25 (unchanged)
- Overall: 28 of 100 (up from 27)
Because Home Depot restructured substantially in 2007, our gauge scores should be treated with an extra dose of skepticism. The GCFR approach includes comparisons between current financial data with historic results, but the validity of these comparisons degrades when the subject company reorganizes.
The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.
| Cash Management | Aug 2009 | May 2009 | Aug 2008 | 5-Yr Avg |
| Current Ratio | 1.3 | 1.2 | 1.3 | 1.2 |
| LTD/Equity | 50.4% | 53.7% | 60.9% | 36.6% |
| Debt/CFO (years) (*) | 2.3 | 2.2 | 2.4 | 1.4 |
| Inventory/CGS (days) | 92.2 | 95.1 | 88.0 | 84.4 |
| Finished Goods/Inventory | N/A | N/A | N/A | N/A |
| Days of Sales Outstanding (days) | 7.4 | 7.5 | 7.4 | 10.0 |
| Working Capital/Invested Capital | 14.6% | 10.2% | 10.9% | 11.2% |
| Cash Conversion Cycle Time (days) | 44.8 | 42.7 | 41.0 | 42.2 |
| Gauge Score (0 to 25) | 6 | 7 | 6 | 5 |
Long-term Debt has decreased slowly, but steadily, since it jumped in 2007 to finance a massive share repurchase. Although the Inventory reduction, relative to last quarter, is a positive, Inventory still appears too high.
The quarter's increase in Working Capital was the result of a reduction in Current Liabilities, especially Accounts Payable and Accrued Expenses. The lack of improvement in Days of Sales Outstanding and the Cash Conversion Cycle Time, which degraded, kept the gauge score in check.
The up-tick in Debt/CFO needs to be confirmed with data in the 10-Q.
| Growth | Aug 2009 | May 2009 | Aug 2008 | 5-Yr Avg |
| Revenue growth | -10.4% | -9.3% | -2.9% | -2.8% |
| Revenue/Assets | 151.8% | 155.7% | 148.1% | 161.4% |
| Operating Profit growth | -20.1% | -19.3% | -8.0% | -11.6% |
| CFO growth (*) | -1.9% | -6.4% | -28.5% | 19.7% |
| Net Income growth | -27.8% | -31.7% | -28.9% | -15.6% |
| Gauge Score (0 to 25) | 3 | 0 | 0 | 4 |
(*) Based on estimated Cash Flow from Operations in the most recent quarter.
Revenue, Cash Flow, and Net Income are all down substantially. The score moved off zero because the rates of decline have tepidly improved.
| Profitability | Aug 2009 | May 2009 | Aug 2008 | 5-Yr Avg |
| Operating Expenses/Revenue | 92.7% | 92.6% | 91.6% | 90.2% |
| ROIC | 11.5% | 11.8% | 12.5% | 16.6% |
| Free Cash Flow/Invested Capital (*) | 13.4% | 12.7% | 6.1% | 9.5% |
| Accrual Ratio (*) | -3.2% | -3.1% | -20.1% | 1.3% |
| Gauge Score (0 to 25) | 7 | 8 | 8 | 9 |
The Operating Expense ratio only rose by 0.1 percent, which seems promising in this difficult retailing environment. We await an updated Cash Flow statement to get a better read on Profitability, but for a company in the midst of the housing slump, the estimated ROIC and FCF figures don't look too bad.
| Value | Aug 2009 | May 2009 | Aug 2008 | 5-Yr Avg |
| P/E | 18.8 | 18.4 | 12.1 | 14.7 |
| P/E vs. S&P 500 P/E | 0.8 | 0.9 | 0.7 | 0.9 |
| PEG | N/A | N/A | N/A | 1.1 |
| Price/Revenue | 0.6 | 0.6 | 0.5 | 0.9 |
| Enterprise Value/Cash Flow (EV/CFO) (*) | 10.4 | 10.4 | 10.3 | 12.0 |
| Gauge Score (0 to 25) | 7 | 7 | 15 | 8 |
Home Depot's stock price slipped 1.4 percent, from $26.32 to $25.94, from the end of April through the end of July. PEG doesn't apply when earnings growth is negative.
The P/E ratio was inflated because we didn't exclude some special charges that weighed down in earnings.
| Overall | Aug 2009 | May 2009 | Aug 2008 | 5-Yr Avg |
| Gauge Score (0 to 100) | 28 | 27 | 38 | 30 |
The gauges held their ground in the second fiscal quarter, but the score is too low to stir any interest. The financial statements in the 10-Q might lead to some scoring adjustments, but we doubt they will be significant.
Full disclosure: Long HD at time of writing.
Posts
No comments:
Post a Comment