HD · The Home Depot, Inc.
$321.632026-05-17Sector: Consumer Cyclical; Industry: Home Improvement; Sub-Industry: Home Improvement Retail
Intrinsic Value Range Comparison · Mulya.ai
Base · active
$273
-15.3% vs market
Mulya.ai vs Analyst IV Comparison?
Mulya.ai IV range ($262 · $338) Analysts Range ($320 · $454) Fundamentals · historical + forward · baseitalics = DCF projection
| Period | Revenue | Rev Gr ? | Ops M% ? | Tax Rate ? | NOPAT ? | Reinvest ? | FCFF ? | WACC% ? | PV FCFF ? | ROIC ? | Inv. Cap ? | EPS ? | P/E |
|---|
| 2021.Q4 | $151.2B | — | 15.2% | 24.4% | $17.4B | −$3.0B | $14.4B | 7.6% | — | 47.2% | $36.9B | $16.48 | — |
| 2022.Q4 | $157.4B | 4.1% | 15.3% | 23.9% | $18.3B | −$6.2B | $12.0B | 8.5% | — | 45.8% | $42.9B | $17.16 | — |
| 2023.Q4 | $152.7B | -3.0% | 14.2% | 24.0% | $16.5B | $810MM | $17.3B | 8.2% | — | 38.6% | $42.4B | $15.19 | — |
| 2024.Q4 | $159.5B | 4.5% | 13.5% | 23.7% | $16.4B | −$16.7B | −$251MM | 8.8% | — | 32.2% | $59.6B | $14.85 | — |
| 2025.Q4 | $164.7B | 3.2% | 12.7% | 23.9% | $15.9B | −$8.1B | $7.8B | 8.8% | — | 24.8% | $68.6B | $14.20 | 15.4 |
| italics below = DCF projection · 10yr Rev CAGR: 3.8% |
| 2026.Q4 | $164.6B | +-0.1% | 14.3% | 23.5% | $17.9B | $0MM | $17.9B | 8.7% | $16.5B | 26.1% | $68.6B | $17.99 | 17.9 |
| 2027.Q4 | $171.2B | +4.0% | 14.3% | 23.1% | $18.8B | −$642MM | $18.1B | 8.7% | $15.3B | 27.2% | $69.3B | $18.81 | 17.1 |
| 2028.Q4 | $178.4B | +4.2% | 14.3% | 22.7% | $19.6B | −$1.1B | $18.5B | 8.7% | $14.4B | 28.1% | $70.4B | $19.70 | 16.3 |
| 2029.Q4 | $186.5B | +4.6% | 14.3% | 22.3% | $20.6B | −$7.5B | $13.2B | 8.7% | $9.5B | 27.9% | $77.8B | $20.70 | 15.5 |
| 2030.Q4 | $194.9B | +4.5% | 14.3% | 21.9% | $21.7B | −$6.1B | $15.6B | 8.7% | $10.3B | 26.8% | $84.0B | $21.74 | 14.8 |
|
| Term. Yr+ | $250.0B | 4.1% | 13.2% | 20.0% | $26.3B | −$4.6B | $21.8B | 8.6% | $210.8B | 23.6% | — | — | — |
Active scenario IV: $273 (-15.3% vs market)