Intrinsic Value of S&P & Nasdaq Contact Us

The Home Depot, Inc. HD NYSE

NYSE • Consumer Cyclical • Home Improvement • US • USD

SharesGrow Score
61/100
3/7 Pass
SharesGrow Intrinsic Value
$247.63
-27.7%
Analyst Price Target
$408.08
+19.1%
SharesGrow 7-Criteria Score All 7 criteria scored · valuation-related highlighted on this page

The Home Depot, Inc. (HD) trades at a trailing P/E of 23.2, forward P/E of 23.7. Trailing earnings yield is 4.31%, forward earnings yield 4.23%. PEG 13.14. Graham Number is $64.33.

Criteria proven by this page:

  • VALUE (58/100, Partial) — mixed signals — some valuation metrics are favorable while others are stretched.
  • PEG Ratio 13.14 — above 2.0 suggests expensive relative to earnings growth.
  • Trailing Earnings Yield 4.31% — roughly competitive with bond yields (~4.3%), moderate risk-reward.
  • Analyst consensus target $408.08 (+19.1% upside) — significant upside potential according to Wall Street analysts.

Overall SharesGrow Score: 61/100 with 3/7 criteria passed.

SharesGrow 7-Criteria Score
61/100
SG Score
View full scorecard →
~
VALUE
58/100
Price-to-Earnings & upside
Proven by this page
FUTURE
67/100
Analyst consensus
→ Forecast
PAST
100/100
→ Income
~
HEALTH
50/100
Debt-to-Equity & liquidity
→ Health
MOAT
76/100
→ Income
GROWTH
30/100
→ Income
~
INCOME
45/100
→ Income

Valuation Snapshot — HD

Valuation Multiples
P/E (TTM)23.2
Forward P/E23.7
PEG Ratio13.14
Forward PEG13.14
P/B Ratio25.61
P/S Ratio2.00
EV/EBITDA16.2
Per Share Data
EPS (TTM)$14.26
Forward EPS (Est.)$14.49
Book Value / Share$12.90
Revenue / Share$165.84
FCF / Share$12.74
Yields & Fair Value
Earnings Yield4.31%
Forward Earnings Yield4.23%
Dividend Yield2.79%
Graham Number$64.33
SharesGrow IV$247.63 (-27.7%)
Analyst Target$408.08 (+19.1%)

Historical Valuation

Year P/E (TTM) PEG Ratio P/B Ratio P/S Ratio Dividend Yield
2017 21.2 1.19 39.02 1.79 2.01%
2018 27.4 2.06 162.76 2.35 1.78%
2019 18.8 0.56 -111.11 1.93 2.25%
2020 22.2 4.25 -80.01 2.26 2.39%
2021 22.5 1.37 87.92 2.20 2.22%
2022 23.5 0.78 -228.06 2.56 1.81%
2023 19.4 2.63 212.10 2.10 2.35%
2024 23.3 -2.47 337.75 2.31 2.38%
2025 27.5 -20.88 61.42 2.56 2.19%
2026 26.5 -5.75 29.30 2.28 2.44%

EPS: Actual vs Estimates

P/E Ratio & Earnings Yield

Earnings Per Share (EPS) History

Year EPS (Diluted) Revenue Net Income Net Margin
2020 $11.94 $132.11B $12.87B 9.7%
2021 $15.53 $151.16B $16.43B 10.9%
2021 $15.53 $151.16B $16.43B 10.9%
2022 $16.69 $157.4B $17.11B 10.9%
2022 $16.69 $157.4B $17.11B 10.9%
2023 $15.11 $152.67B $15.14B 9.9%
2023 $15.11 $152.67B $15.14B 9.9%
2024 $14.91 $159.51B $14.81B 9.3%
2024 $14.91 $159.51B $14.81B 9.3%
2025 $14.23 $164.68B $14.16B 8.6%

Analyst Estimates

Year EPS (Avg) EPS Range Revenue (Avg) Revenue Range Analysts
2026 $14.49 $14.42 – $14.63 $164.6B $164.23B – $165.37B 24
2027 $15.05 $14.52 – $15.29 $171.15B $169.16B – $172.16B 22
2028 $16.30 $15.95 – $16.83 $178.35B $175.58B – $181.43B 22
2029 $17.78 $16.90 – $19.13 $186.53B $186.35B – $186.7B 10
2030 $19.17 $18.78 – $19.51 $192.97B $189.95B – $195.6B 4
Contact Us
🎓
SharesGrow Academy
Learn how to calculate Intrinsic Value and find undervalued stocks.
Weekly live sessions
Send us a message