(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

Home Improvement Retail
Market Cap in USD: 357,946m
IPO / Inception: 1981-09-22
12m vs SPY: -18.2%

EPS (Earnings per Share)

EPS (Earnings per Share) of HD over the last years for every Quarter: "2021-01": 2.74, "2021-04": 3.86, "2021-07": 4.53, "2021-10": 3.92, "2022-01": 3.21, "2022-04": 4.09, "2022-07": 5.05, "2022-10": 4.24, "2023-01": 3.3, "2023-04": 3.82, "2023-07": 4.65, "2023-10": 3.81, "2024-01": 2.82, "2024-04": 3.63, "2024-07": 4.6, "2024-10": 3.67, "2025-01": 3.02, "2025-04": 3.45, "2025-07": 4.58, "2025-10": 3.74,
EPS CAGR: 4.16%
EPS Trend: -11.3%
Last SUE: -2.14
Qual. Beats: 0

Revenue

Revenue of HD over the last years for every Quarter: 2021-01: 32261, 2021-04: 37500, 2021-07: 41118, 2021-10: 36820, 2022-01: 35719, 2022-04: 38908, 2022-07: 43792, 2022-10: 38872, 2023-01: 35831, 2023-04: 37257, 2023-07: 42916, 2023-10: 37710, 2024-01: 34786, 2024-04: 36418, 2024-07: 43175, 2024-10: 40217, 2025-01: 39704, 2025-04: 39856, 2025-07: 45277, 2025-10: 41352,
Rev. CAGR: 3.98%
Rev. Trend: 37.8%
Last SUE: 0.32
Qual. Beats: 0

Dividends

Dividend Yield 2.49%
Yield on Cost 5y 3.80%
Yield CAGR 5y 8.66%
Payout Consistency 99.1%
Payout Ratio 62.2%
Risk via 5d forecast
Volatility 22.2%
Value at Risk 5%th 34.8%
Relative Tail Risk -4.72%
Reward TTM
Sharpe Ratio -0.14
Alpha -14.91
CAGR/Max DD 0.43
Character TTM
Hurst Exponent 0.470
Beta 0.612
Beta Downside 0.351
Drawdowns 3y
Max DD 21.79%
Mean DD 8.77%
Median DD 9.36%

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.00

1. Piotroski 6.0pt
2. FCF Yield 3.35%
3. FCF Margin 8.38%
4. Debt/Equity 4.87
5. Debt/Ebitda 2.28
6. ROIC - WACC (= 18.95)%
7. RoE 156.1%
8. Rev. Trend 37.83%
9. EPS Trend -11.35%

What is the price of HD shares?

As of January 15, 2026, the stock is trading at USD 375.95 with a total of 4,815,155 shares traded.
Over the past week, the price has changed by +7.70%, over one month by +5.31%, over three months by -2.41% and over the past year by -1.90%.

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 394.2 4.9%
Analysts Target Price 394.2 4.9%
ValueRay Target Price 396.3 5.4%

HD Fundamental Data Overview January 10, 2026

P/E Trailing = 24.5099
P/E Forward = 23.8663
P/S = 2.1538
P/B = 29.5433
P/EG = 5.0798
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 = 415.21b USD (357.95b + Debt 58.95b - CCE 1.68b)
Interest Coverage Ratio = 8.81 (Ebit TTM 21.65b / Interest Expense TTM 2.46b)
EV/FCF = 29.81x (Enterprise Value 415.21b / FCF TTM 13.93b)
FCF Yield = 3.35% (FCF TTM 13.93b / Enterprise Value 415.21b)
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.91 (Enterprise Value 415.21b / 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 = 14.33% (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.13% (E(357.95b)/V(416.89b) * Re(8.17%) + D(58.95b)/V(416.89b) * Rd(1.07%) * (1-Tc(0.24)))
Discount Rate = 8.17% (= CAPM, Blume Beta Adj.)
Shares Correlation 3-Years: -33.33 | Cagr: -0.25%
[DCF Debug] Terminal Value 81.28% ; FCFF base≈15.01b ; Y1≈14.88b ; Y5≈15.47b
Fair Price DCF = 272.3 (EV 328.31b - Net Debt 57.26b = Equity 271.05b / Shares 995.5m; r=7.13% [WACC]; 5y FCF grow -1.62% → 2.90% )
EPS Correlation: -11.35 | EPS CAGR: 4.16% | SUE: -2.14 | # QB: 0
Revenue Correlation: 37.83 | Revenue CAGR: 3.98% | SUE: 0.32 | # QB: 0
EPS next Quarter (2026-04-30): EPS=3.63 | Chg30d=-0.043 | Revisions Net=-15 | Analysts=25
EPS next Year (2027-01-31): EPS=15.10 | Chg30d=-0.305 | Revisions Net=-18 | Growth EPS=+3.8% | Growth Revenue=+4.4%

Additional Sources for HD Stock

News: Wall Street Journal | Benzinga | Yahoo Finance
Tweets: X | Stocktwits
Fund Manager Positions: Dataroma | Stockcircle