Ratios
The Home Depot, Inc. (HD.N) (New York Stock Exchange)
Valuation Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| P/E Ratio (TTM) | 20.12 | 8.29 | 0.37 | 122.25 |
| P/E High - Last 5 Yrs. | 20.28 | 2.11 | 0.10 | 24.52 |
| P/E Low - Last 5 Yrs. | 10.44 | 0.89 | 0.02 | 5.65 |
| Beta | 0.69 | 0.74 | 0.80 | 1.37 |
| Price to Sales (TTM) | 0.71 | 0.25 | 0.12 | 2.04 |
| Price to Book (MRQ) | 2.42 | 1.36 | 0.39 | 2.53 |
| Price to Tangible Book (MRQ) | 2.58 | 1.51 | 0.58 | 6.45 |
| Price to Cash Flow (TTM) | 11.52 | 2.28 | 2.48 | 15.54 |
| Price to Free Cash Flow (TTM) | -- | 18.36 | 4.32 | 21.77 |
| % Owned Institutions | -- | -- | -- | -- |
Dividends
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Dividend Yield | 3.27 | 0.17 | 0.01 | 1.50 |
| Dividend Yield - 5 Year Avg. | 1.86 | 1.10 | 1.36 | 2.75 |
| Dividend 5 Year Growth Rate | 28.19 | 12.23 | 3.54 | 9.49 |
| Payout Ratio(TTM) | 66.11 | 12.15 | 0.55 | 88.36 |
Growth Rates
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Sales (MRQ) vs Qtr. 1 Yr. Ago | -8.00 | 1.63 | -5.32 | -4.02 |
| Sales (TTM) vs TTM 1 Yr. Ago | -10.93 | 0.98 | -4.79 | -5.08 |
| Sales - 5 Yr. Growth Rate | 1.92 | 3.72 | 11.04 | 15.64 |
| EPS (MRQ) vs Qtr. 1 Yr. Ago | -9.18 | -30.63 | -24.53 | 73.70 |
| EPS (TTM) vs TTM 1 Yr. Ago | -22.70 | -- | -- | -- |
| EPS - 5 Yr. Growth Rate | -6.12 | 2.75 | -2.79 | 1.27 |
| Capital Spending - 5 Yr. Growth Rate | -14.77 | 1.49 | 12.85 | 19.55 |
Financial Strength
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Quick Ratio (MRQ) | 0.41 | 1.31 | 0.33 | 0.84 |
| Current Ratio (MRQ) | 1.28 | 1.99 | 0.42 | 0.99 |
| LT Debt to Equity (MRQ) | 44.66 | 20.38 | 16.34 | 130.01 |
| Total Debt to Equity (MRQ) | 53.79 | 42.83 | 26.68 | 200.27 |
| Interest Coverage (TTM) | 8.05 | 3.65 | 0.06 | 26.43 |
Profitability Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Gross Margin (TTM) | 33.77 | 7.53 | 2.90 | 27.08 |
| Gross Margin - 5 Yr. Avg. | 33.59 | 37.13 | 26.71 | 26.75 |
| EBITD Margin (TTM) | 9.22 | -- | -- | -- |
| EBITD - 5 Yr. Avg | 12.19 | 11.23 | 13.58 | 15.46 |
| Operating Margin (TTM) | 6.56 | 1.56 | -0.70 | -- |
| Operating Margin - 5 Yr. Avg. | 9.91 | 8.15 | 7.33 | 20.04 |
| Pre-Tax Margin (TTM) | 5.35 | 1.63 | -0.86 | 7.66 |
| Pre-Tax Margin - 5 Yr. Avg. | 9.42 | 8.41 | 7.61 | 19.75 |
| Net Profit Margin (TTM) | 3.50 | 0.99 | -0.71 | 6.18 |
| Net Profit Margin - 5 Yr. Avg. | 5.94 | 4.61 | 5.85 | 14.00 |
| Effective Tax Rate (TTM) | 34.64 | 6.79 | 0.35 | -7.43 |
| Effecitve Tax Rate - 5 Yr. Avg. | 36.98 | 89.64 | 25.66 | 28.27 |
Management Effectiveness
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Return on Assets (TTM) | 5.31 | 0.85 | -0.44 | 3.65 |
| Return on Assets - 5 Yr. Avg. | 10.30 | 4.82 | 6.39 | 5.28 |
| Return on Investment (TTM) | 7.49 | 1.22 | -0.78 | 4.99 |
| Return on Investment - 5 Yr. Avg. | 14.14 | 7.16 | 10.47 | 6.79 |
| Return on Equity (TTM) | 12.27 | 1.07 | -1.60 | 8.72 |
| Return on Equity - 5 Yr. Avg. | 19.69 | 9.29 | 12.34 | 15.25 |
Efficiency
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Revenue/Employee (TTM) | 316,359 | 956,680 | 7,827,670 | 473,836 |
| Net Income/Employee (TTM) | 11,070 | 83,303 | -314,586 | 30,890 |
| Receivable Turnover (TTM) | 49.45 | 4.26 | 1.62 | 6.89 |
| Inventory Turnover (TTM) | 3.87 | 0.73 | 1.43 | 5.36 |
| Asset Turnover (TTM) | 1.52 | 0.21 | 0.12 | 0.46 |

