(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

EPS (Earnings per Share)

EPS (Earnings per Share) of HD over the last years for every Quarter: "2020-10": 3.18, "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.56, "2025-07": 4.58, "2025-10": 3.74,

Revenue

Revenue of HD over the last years for every Quarter: 2020-10: 33536, 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,

Dividends

Dividend Yield 2.67%
Yield on Cost 5y 3.86%
Yield CAGR 5y 10.67%
Payout Consistency 97.2%
Payout Ratio 61.7%
Risk via 5d forecast
Volatility 24.3%
Value at Risk 5%th 38.5%
Relative Tail Risk -3.78%
Reward TTM
Sharpe Ratio -0.52
Alpha -21.38
CAGR/Max DD 0.26
Character TTM
Hurst Exponent 0.447
Beta 0.603
Beta Downside 0.303
Drawdowns 3y
Max DD 21.79%
Mean DD 8.54%
Median DD 8.93%

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

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

What is the price of HD shares?

As of December 24, 2025, the stock is trading at USD 344.97 with a total of 3,025,168 shares traded.
Over the past week, the price has changed by -2.19%, over one month by +3.16%, over three months by -15.50% and over the past year by -9.91%.

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 399.3 15.8%
Analysts Target Price 399.3 15.8%
ValueRay Target Price 338.7 -1.8%

HD Fundamental Data Overview December 20, 2025

Market Cap USD = 353.40b (353.40b USD * 1.0 USD.USD)
P/E Trailing = 24.2149
P/E Forward = 23.4192
P/S = 2.1265
P/B = 29.3124
P/EG = 4.9773
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 = 410.66b USD (353.40b + Debt 58.95b - CCE 1.68b)
Interest Coverage Ratio = 8.81 (Ebit TTM 21.65b / Interest Expense TTM 2.46b)
FCF Yield = 3.39% (FCF TTM 13.93b / Enterprise Value 410.66b)
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.86 (Enterprise Value 410.66b / 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.18% (E(353.40b)/V(412.34b) * Re(8.24%) + D(58.95b)/V(412.34b) * Rd(1.07%) * (1-Tc(0.24)))
Discount Rate = 8.24% (= CAPM, Blume Beta Adj.)
Shares Correlation 3-Years: -33.33 | Cagr: -0.25%
[DCF Debug] Terminal Value 77.46% ; FCFE base≈15.01b ; Y1≈14.88b ; Y5≈15.51b
Fair Price DCF = 266.1 (DCF Value 264.95b / Shares Outstanding 995.5m; 5y FCF grow -1.62% → 3.0% )
EPS Correlation: -9.88 | EPS CAGR: 4.16% | SUE: -2.85 | # QB: 0
Revenue Correlation: 37.83 | Revenue CAGR: 3.98% | SUE: 0.32 | # QB: 0
EPS next Quarter (2026-04-30): EPS=3.64 | Chg30d=-0.223 | Revisions Net=-15 | Analysts=25
EPS next Year (2027-01-31): EPS=15.16 | Chg30d=-1.047 | Revisions Net=-33 | Growth EPS=+4.1% | Growth Revenue=+4.4%

Additional Sources for HD Stock

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