| Company Name: | Home Depot, Incorporated | | Ticker Symbol: | HD | | | WWW Address: | www.homedepot.com | | CEO: | Francis S. Blake | | No. of Employees: | 322,000 | | Common Issue Type: | CS | | Business Description: | The Company is a home improvement retailer, which operates The Home Depot stores.
|
| | | Industry Information: | RETAIL - Home Improvement Stores [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 27.36 |  0.18 | 27.36 | 27.37 | 27.37 | 27.27 | 26.74 | 11523416 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 46,637.9 | 1,704.6 | 0.66 | 1.34 | 0.90 | 20.3 | 3.3 | 28.44 - 17.49 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 27.18 | $ | | PE Ratio - LTM | 20.3 | |
| Market Capitalisation | 46,329.9 | mil |
| Latest Shares Outstanding | 1,704.6 | mil |
| Earnings pS (EPS) | 1.34 | $ |
| Dividend pS (DPS) | 0.90 | ¢ |
| Dividend Yield | 3.3 | % |
| Dividend Payout Ratio | 67 | % |
| Revenue per Employee | 221,391 | $ |
| Effective Tax Rate | 35.6 | % |
| Float | 1,701.8 | mil |
| Float as % of Shares Outstanding | 99.8 | % |
| Foreign Sales | 0 | mil |
| Domestic Sales | 0 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 24.60 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 33.9 | % |
| EBITDA Margin | 9.3 | % |
| Pre-Tax Profit Margin | 5.3 | % |
| Assets Turnover | 1.5 | % |
| Return on Assets (ROA) | 5.3 | % |
| Return on Equity (ROE) | 12.2 | % |
| Return on Capital Invested (ROCI) | 8.1 | % |
| Current Ratio | 1.3 | |
| Leverage Ratio (Assets/Equity) | 2.3 | |
| Interest Cover | 6.6 | |
| Total Debt/Equity (Gearing Ratio) | 0.60 | |
| LT Debt/Total Capital | 34.0 | % |
| Working Capital pS | 2.35 | $ |
| Cash pS | 1.82 | $ |
| Book-Value pS | 11.25 | $ |
| Tangible Book-Value pS | 10.56 | $ |
| Cash Flow pS | 2.46 | $ |
| Free Cash Flow pS | 1.41 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 2.42 | |
| Price/Tangible Book Ratio | 2.57 | |
| Price/Cash Flow | 11.1 | |
| Price/Free Cash Flow | 19.2 | |
| P/E as % of Industry Group | 76.0 | % |
| P/E as % of Sector Segment | 122.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 08/20/2009 |
| Dividend Ex-Date | 08/31/2009 |
| Dividend Record Date | 09/02/2009 |
| Dividend Pay Date | 09/16/2009 |
| Dividend Amount | 225 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.90 |
| Current Dividend Yield | 3.3 |
| 5-Y Average Dividend Yield | 2.2 |
| Payout Ratio | 67.0 |
| 5-Y Average Payout Ratio | 32.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | | | | | PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | -0.6 | 100 | 175,277 | 960,936 |
| 4 Weeks | 27.95 | 24.47 | 26.27 | 3.5 | 102 | 171,927 | 3,438,530 |
| 13 Weeks | 28.44 | 24.47 | 27.50 | -1.2 | 93 | 144,681 | 9,259,577 |
| 26 Weeks | 28.44 | 22.27 | 22.86 | 18.9 | 97 | 149,623 | 19,002,087 |
| 52 Weeks | 28.44 | 17.49 | 19.29 | 40.9 | 103 | 182,188 | 45,729,133 |
| YTD | 28.44 | 17.49 | - | 18.1 | 98 | 179,678 | 40,427,589 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 27.24 | 27.17 | 26.78 | 25.69 | 24.82 | 0.66 | 0.60 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | -2.00 | 13.3 | -9.15 |
| Income | -11.25 | 50.9 | -22.98 |
| Dividend | 26.87 | 89.1 | 15.71 |
| Capital Spending | 0.00 | NA | 0.00 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | -9.01 | NA | -21.42 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -9.0 | -8.0 | -7.8 |
| Earnings % | 0.2 | -8.9 | -48.6 |
| EPS % | 0.0 | -8.9 | -43.5 |
| EPS $ | 0.00 | -0.04 | -1.03 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 5.37 |
| Current Ratio | 1.2 |
| Quick Ratio (Acid Test) | 0.1 |
| Liquidity Ratio (Cash) | 0.05 |
| Receivables Turnover | 63.9 |
| Average Collection Period | 6 |
| Working Capital/Equity | 12.4 |
| Working Capital pS | 1.30 |
| Cash-Flow pS | 2.45 |
| Free Cash-Flow pS | 1.27 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 3.42 |
| Financial Leverage Ratio (Assets/Equity) | 2.3 |
| Debt Ratio | 56.8 |
| Total Debt/Equity (Gearing Ratio) | 0.64 |
| LT Debt/Equity | 0.54 |
| LT Debt/Capital Invested | 44.6 |
| LT Debt/Total Liabilities | 41.3 |
| Interest Cover | 6.8 |
| Interest/Capital Invested | 2.08 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 8.48 |
| Tobin's Q Ratio | 1.13 |
| Current P/E Ratio - LTM | 20.30 |
| Enterprise Value (EV)/EBITDA | 11.05 |
| Enterprise Value (EV)/Free Cash Flow | 54.21 |
| Dividend Yield | 3.3 |
| Price/Tangible Book Ratio - LTM | 2.57 |
| Price/Book Ratio - LTM | 2.42 |
| Price/Cash Flow Ratio | 11.1 |
| Price/Free Cash Flow Ratio - LTM | 19.2 |
| Price/Sales Ratio | 0.70 |
| P/E Ratio (1 month ago) - LTM | 20.1 |
| P/E Ratio (26 weeks ago) - LTM | 15.9 |
| P/E Ratio (52 weeks ago) - LTM | 10.7 |
| 5-Y High P/E Ratio | 22.9 |
| 5-Y Low P/E Ratio | 10.0 |
| 5-Y Average P/E Ratio | 15.4 |
| Current P/E Ratio as % of 5-Y Average P/E | 132 |
| P/E as % of Industry Group | 76.0 |
| P/E as % of Sector Segment | 122.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 19.3 |
| PER SHARE FIGURES |
| LT Debt pS | 5.70 |
| Current Liabilities pS | 6.58 |
| Tangible Book Value pS - LTM | 10.56 |
| Book Value pS - LTM | 11.25 |
| Capital Invested pS | 16.10 |
| Cash pS - LTM | 1.82 |
| Cash Flow pS - LTM | 2.46 |
| Free Cash Flow pS - LTM | 1.41 |
| Earnings pS (EPS) | 1.34 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 3.03 |
| Free Cash Flow Margin 5YEAR AVG | 2.75 |
| Net Profit Margin | 3.2 |
| Net Profit Margin - 5YEAR AVRG. | 5.9 |
| Equity Productivity | 4.01 |
| Return on Equity (ROE) | 12.7 |
| Return on Equity (ROE) - 5YEAR AVRG. | 20.8 |
| Capital Invested Productivity | 2.60 |
| Return on Capital Invested (ROCI) | 8.2 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 15.6 |
| Assets Productivity | 1.70 |
| Return on Assets (ROA) | 5.5 |
| Return on Assets (ROA) - 5YEAR AVRG. | 10.5 |
| Gross Profit Margin | 33.9 |
| Gross Profit Margin - 5YEAR AVRG. | 33.8 |
| EBITDA Margin - LTM | 9.3 |
| EBIT Margin - LTM | 6.3 |
| Pre-Tax Profit Margin | 5.0 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 9.3 |
| Effective Tax Rate | 35.6 |
| Effective Tax Rate - 5YEAR AVRG. | 36.8 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 90 |
| Revenue per Employee | 221,391 |
| Net Income per Employee | 7,019 |
| Average Collection Period | 5 |
| Receivables Turnover | 63.9 |
| Day's Inventory Turnover Ratio | 85 |
| Inventory Turnover | 4.2 |
| Inventory/Sales | 15.0 |
| Accounts Payble/Sales | 6.76 |
| Assets/Revenue | 0.59 |
| Net Working Capital Turnover | 32.27 |
| Fixed Assets Turnover | 2.56 |
| Total Assets Turnover | 1.7 |
| Revenue per $ Cash | 137.36 |
| Revenue per $ Plant | 2.72 |
| Revenue per $ Common Equity | 4.01 |
| Revenue per $ Capital Invested | 2.60 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 25.0 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 21.9 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |