| Company Name: | Home Depot, Inc. | | Ticker Symbol: | HD | | | WWW Address: | www.homedepot.com |
| CEO: | Francis S. Blake | | No. of Employees: | 21,000 |
| Common Issue Type: | CS | | Business Description: | Home Depot, Inc., is a home improvement retailer. Its stores sell an assortment of building materials, home improvement and lawn and garden products and provide a number of services.
|
| | | Industry Information: | RETAIL - Home Improvement Stores [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 78.83 |  -0.86 | - | - | 78.89 | 81.56 | 79.18 | 8261525 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 117,103.3 | 1,485.5 | 0.86 | 3.00 | 1.16 | 25.3 | 2.0 | 81.56 - 47.75 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 79.69 | $ | | PE Ratio - LTM | 25.3 | |
| Market Capitalisation | 117,103.3 | mil |
| Latest Shares Outstanding | 1,485.5 | mil |
| Earnings pS (EPS) | 3.00 | $ |
| Dividend pS (DPS) | 1.16 | ¢ |
| Dividend Yield | 2.0 | % |
| Dividend Payout Ratio | 39 | % |
| Revenue per Employee | 3,559,714 | $ |
| Effective Tax Rate | 37.2 | % |
| Float | 1,297.0 | mil |
| Float as % of Shares Outstanding | 87.5 | % |
| Foreign Sales | 8,400 | mil |
| Domestic Sales | 66,600 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 22.10 | % |
| Research & Devlopment (R&D) as % of Revenue | 0.00 | % |
| Gross Profit Margin | 34.7 | % |
| EBITDA Margin | 12.6 | % |
| Pre-Tax Profit Margin | 9.7 | % |
| Assets Turnover | 1.8 | % |
| Return on Assets (ROA) | 11.0 | % |
| Return on Equity (ROE) | 25.5 | % |
| Return on Capital Invested (ROCI) | 16.6 | % |
| Current Ratio | 1.3 | |
| Leverage Ratio (Assets/Equity) | 2.3 | |
| Interest Cover | 12.4 | |
| Total Debt/Equity (Gearing Ratio) | 0.61 | |
| LT Debt/Total Capital | 35.0 | % |
| Working Capital pS | 2.63 | $ |
| Cash pS | 1.68 | $ |
| Book-Value pS | 11.97 | $ |
| Tangible Book-Value pS | 11.18 | $ |
| Cash Flow pS | 4.19 | $ |
| Free Cash Flow pS | 2.52 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 6.66 | |
| Price/Tangible Book Ratio | 7.13 | |
| Price/Cash Flow | 19.0 | |
| Price/Free Cash Flow | 31.6 | |
| P/E as % of Industry Group | 108.0 | % |
| P/E as % of Sector Segment | 90.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 02/25/2013 |
| Dividend Ex-Date | 03/11/2013 |
| Dividend Record Date | 03/13/2013 |
| Dividend Pay Date | 03/27/2013 |
| Dividend Amount | 390 |
| Type of Payment | Cash Payment |
| Dividend Rate | 1.56 |
| Current Dividend Yield | 2.0 |
| 5-Y Average Dividend Yield | 2.8 |
| Payout Ratio | 39.0 |
| 5-Y Average Payout Ratio | 50.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 | - | - | - | 3.7 | 104 | 83,588 | 377,921 |
| 4 Weeks | 81.56 | 72.53 | 73.35 | 8.6 | 104 | 70,442 | 1,267,952 |
| 13 Weeks | 81.56 | 63.82 | 65.58 | 21.5 | 111 | 73,402 | 4,550,935 |
| 26 Weeks | 81.56 | 60.21 | 64.82 | 22.9 | 105 | 69,391 | 8,535,134 |
| 52 Weeks | 81.56 | 47.75 | 49.44 | 61.2 | 128 | 83,005 | 20,502,288 |
| YTD | 81.56 | 62.38 | - | 28.8 | 111 | 68,417 | 6,704,888 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 77.75 | 77.25 | 73.03 | 67.68 | 64.83 | 0.86 | 1.01 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 0.20 | 0.5 | 3.76 |
| Income | 13.74 | 64.6 | 19.51 |
| Dividend | 5.13 | 80.6 | 8.95 |
| Capital Spending | 0.00 | NA | 14.59 |
| R&D | 0.00 | NA | 0.00 |
| Normalized Inc. | 10.45 | NA | 24.56 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 7.4 | 7.4 | 6.2 |
| Earnings % | 18.5 | 18.5 | 16.8 |
| EPS % | 22.1 | 22.1 | 21.5 |
| EPS $ | 0.15 | 0.15 | 0.53 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 9.52 |
| Current Ratio | 1.3 |
| Quick Ratio (Acid Test) | 0.3 |
| Liquidity Ratio (Cash) | 0.22 |
| Receivables Turnover | 56.6 |
| Average Collection Period | 6 |
| Working Capital/Equity | 22.0 |
| Working Capital pS | 2.63 |
| Cash-Flow pS | 4.19 |
| Free Cash-Flow pS | 2.53 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 5.80 |
| Financial Leverage Ratio (Assets/Equity) | 2.3 |
| Debt Ratio | 56.7 |
| Total Debt/Equity (Gearing Ratio) | 0.61 |
| LT Debt/Equity | 0.53 |
| LT Debt/Capital Invested | 43.5 |
| LT Debt/Total Liabilities | 40.7 |
| Interest Cover | 12.4 |
| Interest/Capital Invested | 2.13 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 26.91 |
| Tobin's Q Ratio | 2.87 |
| Current P/E Ratio - LTM | 25.30 |
| Enterprise Value (EV)/EBITDA | 14.70 |
| Enterprise Value (EV)/Free Cash Flow | 50.77 |
| Dividend Yield | 2.0 |
| Price/Tangible Book Ratio - LTM | 7.13 |
| Price/Book Ratio - LTM | 6.66 |
| Price/Cash Flow Ratio | 19.0 |
| Price/Free Cash Flow Ratio - LTM | 31.6 |
| Price/Sales Ratio | 1.56 |
| P/E Ratio (1 month ago) - LTM | 23.4 |
| P/E Ratio (26 weeks ago) - LTM | 23.0 |
| P/E Ratio (52 weeks ago) - LTM | 18.7 |
| 5-Y High P/E Ratio | 22.9 |
| 5-Y Low P/E Ratio | 11.1 |
| 5-Y Average P/E Ratio | 18.5 |
| Current P/E Ratio as % of 5-Y Average P/E | 137 |
| P/E as % of Industry Group | 108.0 |
| P/E as % of Sector Segment | 90.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 26.6 |
| PER SHARE FIGURES |
| LT Debt pS | 6.38 |
| Current Liabilities pS | 7.72 |
| Tangible Book Value pS - LTM | 11.18 |
| Book Value pS - LTM | 11.97 |
| Capital Invested pS | 18.35 |
| Cash pS - LTM | 1.68 |
| Cash Flow pS - LTM | 4.19 |
| Free Cash Flow pS - LTM | 2.52 |
| Earnings pS (EPS) | 3.00 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 5.02 |
| Free Cash Flow Margin 5YEAR AVG | 4.06 |
| Net Profit Margin | 6.1 |
| Net Profit Margin - 5YEAR AVRG. | 4.8 |
| Equity Productivity | 4.21 |
| Return on Equity (ROE) | 25.5 |
| Return on Equity (ROE) - 5YEAR AVRG. | 18.2 |
| Capital Invested Productivity | 2.74 |
| Return on Capital Invested (ROCI) | 16.6 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 12.0 |
| Assets Productivity | 1.80 |
| Return on Assets (ROA) | 11.0 |
| Return on Assets (ROA) - 5YEAR AVRG. | 8.2 |
| Gross Profit Margin | 34.7 |
| Gross Profit Margin - 5YEAR AVRG. | 34.3 |
| EBITDA Margin - LTM | 12.6 |
| EBIT Margin - LTM | 10.5 |
| Pre-Tax Profit Margin | 9.7 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 7.5 |
| Effective Tax Rate | 37.2 |
| Effective Tax Rate - 5YEAR AVRG. | 35.9 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 85 |
| Revenue per Employee | 3,559,714 |
| Net Income per Employee | 215,952 |
| Average Collection Period | 7 |
| Receivables Turnover | 56.6 |
| Day's Inventory Turnover Ratio | 78 |
| Inventory Turnover | 4.6 |
| Inventory/Sales | 14.3 |
| Accounts Payble/Sales | 7.19 |
| Assets/Revenue | 0.56 |
| Net Working Capital Turnover | 19.12 |
| Fixed Assets Turnover | 2.91 |
| Total Assets Turnover | 1.8 |
| Revenue per $ Cash | 29.97 |
| Revenue per $ Plant | 3.11 |
| Revenue per $ Common Equity | 4.21 |
| Revenue per $ Capital Invested | 2.74 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 22.1 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 23.4 |
| Research & Devlopment (R&D) as % of Revenue | 0.0 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 0.0 |
|
|  
| | |  |  | |
| |
