(HD) The Home Depot - Ratings and Ratios
Exchange: NYSE •
Country: United States •
Currency: USD •
Type: Common Stock •
ISIN: US4370761029
Building Materials, Home Improvement, Lawn Garden, Décor, Installation
Dividends
| Dividend Yield | 2.62% |
| Yield on Cost 5y | 3.91% |
| Yield CAGR 5y | 10.67% |
| Payout Consistency | 97.2% |
| Payout Ratio | 61.3% |
| Risk via 10d forecast | |
|---|---|
| Volatility | 25.3% |
| Value at Risk 5%th | 39.9% |
| Relative Tail Risk | -4.19% |
| Reward TTM | |
|---|---|
| Sharpe Ratio | -0.82 |
| Alpha | -27.30 |
| CAGR/Max DD | 0.20 |
| Character TTM | |
|---|---|
| Hurst Exponent | 0.387 |
| Beta | 0.634 |
| Beta Downside | 0.352 |
| Drawdowns 3y | |
|---|---|
| Max DD | 21.79% |
| Mean DD | 8.46% |
| Median DD | 8.59% |
Description: HD The Home Depot December 01, 2025
The Home Depot, Inc. (NYSE: HD) is the largest U.S. home-improvement retailer, offering a broad assortment of building materials, décor, lawn-and-garden items, and a suite of professional installation and equipment-rental services. Its customer base spans DIY homeowners, professional remodelers, contractors, and specialty tradespeople, with sales delivered through a network of over 2,300 big-box stores and multiple e-commerce platforms (e.g., homedepot.com, homedepot.ca, homedepot.com.mx, and niche sites such as blinds.com).
Key recent metrics (FY 2024): revenue of $156 billion, comparable-store sales up 5.2% YoY, operating margin of 13.4%, and a dividend yield near 2.5%. The company generated $12 billion of free cash flow, supporting a $30 billion share-repurchase program and a 10-year dividend increase streak.
Sector drivers that materially affect HD’s outlook include: (1) residential construction activity, which is highly sensitive to mortgage rates and housing starts; (2) DIY spending trends, historically buoyed by consumer confidence and the “stay-at-home” effect; and (3) supply-chain resilience, as inventory turnover and freight cost volatility directly impact same-store sales performance.
For a deeper quantitative dive, you might explore ValueRay’s analyst tools to model HD’s earnings sensitivity to housing-market and rate-scenario assumptions.
Piotroski VR‑10 (Strict, 0-10) 6.0
| Net Income (14.58b TTM) > 0 and > 6% of Revenue (6% = 9.97b TTM) |
| FCFTA 0.13 (>2.0%) and ΔFCFTA -3.99pp (YES ≥ +1.0pp, WARN ≥ +0.5pp) |
| NWC/Revenue 1.05% (prev 2.49%; Δ -1.44pp) (YES ≤20% & Δ≤-1pp; WARN ≤25% & Δ≤0 oder ≤40% & Δ≤-3pp) |
| CFO/TA 0.17 (>3.0%) and CFO 17.65b > Net Income 14.58b (YES >=105%, WARN >=100%) |
| Net Debt (57.26b) to EBITDA (25.08b) ratio: 2.28 <= 3.0 (WARN <= 3.5) |
| Current Ratio 1.05 (target 1.5–3.0; WARN 1.2–<1.5 or >3.0–5.0; CFO/TA gate active) |
| Outstanding Shares last Quarter (994.0m) change vs 12m ago 0.10% (target <= -2.0% for YES) |
| Gross Margin 33.36% (prev 33.50%; Δ -0.14pp) >=18% & Δ>=+0.5pp (WARN >=15% & Δ>=0) |
| Asset Turnover 163.3% (prev 158.9%; Δ 4.36pp) >=50% & Δ>=+2pp (WARN >=35% & Δ>=0) |
| Interest Coverage Ratio 8.81 (EBITDA TTM 25.08b / Interest Expense TTM 2.46b) >= 6 (WARN >= 3) |
Altman Z'' 5.47
| (A) 0.02 = (Total Current Assets 36.12b - Total Current Liabilities 34.37b) / Total Assets 106.27b |
| (B) 0.89 = Retained Earnings (Balance) 94.25b / Total Assets 106.27b |
| warn (B) unusual magnitude: 0.89 — check mapping/units |
| (C) 0.21 = EBIT TTM 21.65b / Avg Total Assets 101.77b |
| (D) 0.99 = Book Value of Equity 93.53b / Total Liabilities 94.16b |
| Total Rating: 5.47 = (6.56 * A) + (3.26 * B) + (6.72 * C) + (1.05 * D) |
ValueRay F-Score (Strict, 0-100) 69.16
| 1. Piotroski 6.0pt |
| 2. FCF Yield 3.42% |
| 3. FCF Margin 8.38% |
| 4. Debt/Equity 4.87 |
| 5. Debt/Ebitda 2.28 |
| 6. ROIC - WACC (= 18.82)% |
| 7. RoE 156.1% |
| 8. Rev. Trend 37.83% |
| 9. EPS Trend -8.78% |
What is the price of HD shares?
As of December 11, 2025, the stock is trading at USD 351.13 with a total of 4,081,882 shares traded.
Over the past week, the price has changed by -1.26%, over one month by -4.60%, over three months by -14.48% and over the past year by -14.84%.
Over the past week, the price has changed by -1.26%, over one month by -4.60%, over three months by -14.48% and over the past year by -14.84%.
Is HD a buy, sell or hold?
The Home Depot has received a consensus analysts rating of 4.18.
Therefore, it is recommended to buy HD.
- Strong Buy: 21
- Buy: 5
- Hold: 12
- Sell: 1
- Strong Sell: 0
What are the forecasts/targets for the HD price?
| Issuer | Target | Up/Down from current |
|---|---|---|
| Wallstreet Target Price | 402.8 | 14.7% |
| Analysts Target Price | 402.8 | 14.7% |
| ValueRay Target Price | 342.4 | -2.5% |
HD Fundamental Data Overview December 06, 2025
Market Cap USD = 349.59b (349.59b USD * 1.0 USD.USD)
P/E Trailing = 23.987
P/E Forward = 22.8833
P/S = 2.1036
P/B = 29.4077
P/EG = 3.8762
Beta = 1.051
Revenue TTM = 166.19b USD
EBIT TTM = 21.65b USD
EBITDA TTM = 25.08b USD
Long Term Debt = 46.34b USD (from longTermDebt, last quarter)
Short Term Debt = 4.62b USD (from shortTermDebt, last quarter)
Debt = 58.95b USD (from shortLongTermDebtTotal, last quarter)
Net Debt = 57.26b USD (from netDebt column, last quarter)
Enterprise Value = 406.86b USD (349.59b + Debt 58.95b - CCE 1.68b)
Interest Coverage Ratio = 8.81 (Ebit TTM 21.65b / Interest Expense TTM 2.46b)
FCF Yield = 3.42% (FCF TTM 13.93b / Enterprise Value 406.86b)
FCF Margin = 8.38% (FCF TTM 13.93b / Revenue TTM 166.19b)
Net Margin = 8.77% (Net Income TTM 14.58b / Revenue TTM 166.19b)
Gross Margin = 33.36% ((Revenue TTM 166.19b - Cost of Revenue TTM 110.76b) / Revenue TTM)
Gross Margin QoQ = 33.41% (prev 33.41%)
Tobins Q-Ratio = 3.83 (Enterprise Value 406.86b / Total Assets 106.27b)
Interest Expense / Debt = 1.07% (Interest Expense 628.0m / Debt 58.95b)
Taxrate = 24.30% (1.16b / 4.76b)
NOPAT = 16.39b (EBIT 21.65b * (1 - 24.30%))
Current Ratio = 1.05 (Total Current Assets 36.12b / Total Current Liabilities 34.37b)
Debt / Equity = 4.87 (Debt 58.95b / totalStockholderEquity, last quarter 12.12b)
Debt / EBITDA = 2.28 (Net Debt 57.26b / EBITDA 25.08b)
Debt / FCF = 4.11 (Net Debt 57.26b / FCF TTM 13.93b)
Total Stockholder Equity = 9.34b (last 4 quarters mean from totalStockholderEquity)
RoA = 13.72% (Net Income 14.58b / Total Assets 106.27b)
RoE = 156.1% (Net Income TTM 14.58b / Total Stockholder Equity 9.34b)
RoCE = 38.87% (EBIT 21.65b / Capital Employed (Equity 9.34b + L.T.Debt 46.34b))
RoIC = 26.08% (NOPAT 16.39b / Invested Capital 62.84b)
WACC = 7.26% (E(349.59b)/V(408.54b) * Re(8.35%) + D(58.95b)/V(408.54b) * Rd(1.07%) * (1-Tc(0.24)))
Discount Rate = 8.35% (= CAPM, Blume Beta Adj.)
Shares Correlation 3-Years: -33.33 | Cagr: -0.25%
[DCF Debug] Terminal Value 77.05% ; FCFE base≈15.01b ; Y1≈14.88b ; Y5≈15.51b
Fair Price DCF = 260.7 (DCF Value 259.54b / Shares Outstanding 995.5m; 5y FCF grow -1.62% → 3.0% )
EPS Correlation: -8.78 | EPS CAGR: 4.16% | SUE: -2.73 | # QB: 0
Revenue Correlation: 37.83 | Revenue CAGR: 3.98% | SUE: 0.32 | # QB: 0
EPS next Quarter (2026-04-30): EPS=3.68 | Chg30d=-0.210 | Revisions Net=-14 | Analysts=23
EPS next Year (2027-01-31): EPS=15.42 | Chg30d=-0.856 | Revisions Net=-32 | Growth EPS=+5.6% | Growth Revenue=+4.6%
P/E Trailing = 23.987
P/E Forward = 22.8833
P/S = 2.1036
P/B = 29.4077
P/EG = 3.8762
Beta = 1.051
Revenue TTM = 166.19b USD
EBIT TTM = 21.65b USD
EBITDA TTM = 25.08b USD
Long Term Debt = 46.34b USD (from longTermDebt, last quarter)
Short Term Debt = 4.62b USD (from shortTermDebt, last quarter)
Debt = 58.95b USD (from shortLongTermDebtTotal, last quarter)
Net Debt = 57.26b USD (from netDebt column, last quarter)
Enterprise Value = 406.86b USD (349.59b + Debt 58.95b - CCE 1.68b)
Interest Coverage Ratio = 8.81 (Ebit TTM 21.65b / Interest Expense TTM 2.46b)
FCF Yield = 3.42% (FCF TTM 13.93b / Enterprise Value 406.86b)
FCF Margin = 8.38% (FCF TTM 13.93b / Revenue TTM 166.19b)
Net Margin = 8.77% (Net Income TTM 14.58b / Revenue TTM 166.19b)
Gross Margin = 33.36% ((Revenue TTM 166.19b - Cost of Revenue TTM 110.76b) / Revenue TTM)
Gross Margin QoQ = 33.41% (prev 33.41%)
Tobins Q-Ratio = 3.83 (Enterprise Value 406.86b / Total Assets 106.27b)
Interest Expense / Debt = 1.07% (Interest Expense 628.0m / Debt 58.95b)
Taxrate = 24.30% (1.16b / 4.76b)
NOPAT = 16.39b (EBIT 21.65b * (1 - 24.30%))
Current Ratio = 1.05 (Total Current Assets 36.12b / Total Current Liabilities 34.37b)
Debt / Equity = 4.87 (Debt 58.95b / totalStockholderEquity, last quarter 12.12b)
Debt / EBITDA = 2.28 (Net Debt 57.26b / EBITDA 25.08b)
Debt / FCF = 4.11 (Net Debt 57.26b / FCF TTM 13.93b)
Total Stockholder Equity = 9.34b (last 4 quarters mean from totalStockholderEquity)
RoA = 13.72% (Net Income 14.58b / Total Assets 106.27b)
RoE = 156.1% (Net Income TTM 14.58b / Total Stockholder Equity 9.34b)
RoCE = 38.87% (EBIT 21.65b / Capital Employed (Equity 9.34b + L.T.Debt 46.34b))
RoIC = 26.08% (NOPAT 16.39b / Invested Capital 62.84b)
WACC = 7.26% (E(349.59b)/V(408.54b) * Re(8.35%) + D(58.95b)/V(408.54b) * Rd(1.07%) * (1-Tc(0.24)))
Discount Rate = 8.35% (= CAPM, Blume Beta Adj.)
Shares Correlation 3-Years: -33.33 | Cagr: -0.25%
[DCF Debug] Terminal Value 77.05% ; FCFE base≈15.01b ; Y1≈14.88b ; Y5≈15.51b
Fair Price DCF = 260.7 (DCF Value 259.54b / Shares Outstanding 995.5m; 5y FCF grow -1.62% → 3.0% )
EPS Correlation: -8.78 | EPS CAGR: 4.16% | SUE: -2.73 | # QB: 0
Revenue Correlation: 37.83 | Revenue CAGR: 3.98% | SUE: 0.32 | # QB: 0
EPS next Quarter (2026-04-30): EPS=3.68 | Chg30d=-0.210 | Revisions Net=-14 | Analysts=23
EPS next Year (2027-01-31): EPS=15.42 | Chg30d=-0.856 | Revisions Net=-32 | Growth EPS=+5.6% | Growth Revenue=+4.6%
Additional Sources for HD Stock
News:
Wall Street Journal |
Benzinga |
Yahoo Finance
Tweets: X | Stocktwits
Fund Manager Positions: Dataroma | Stockcircle
Tweets: X | Stocktwits
Fund Manager Positions: Dataroma | Stockcircle