Back to HD Overview
NYQ · Valuation Lab
HD
Home Depot, Inc. (The)
Last$353.14
Market cap—
EV/EBITDA16.1x
Intrinsic value
$266835673301.85
MoS +100.0% · Undervalued
Assuming 6.1% FCF margin and 4.8% Y1–5 growth.
Upside to price
EV (DCF)329B
Terminal share72%
Expected IV$274556172269.51
Probability weights
Projected free cash flows
Stage FCF path with present values · terminal 72% of EV
PV of stage FCFs92.4B
PV of terminal value236.5B
Enterprise value329B
Net cash / (debt)-62.1B
Equity value266.8B
Intrinsic value / share$266835673301.85
| Year | Revenue | FCF | PV | DF |
|---|---|---|---|---|
| Y1 | 174.6B | 10.6B | 10B | 94.3% |
| Y2 | 183B | 11.2B | 9.9B | 89.0% |
| Y3 | 191.8B | 11.7B | 9.8B | 84.0% |
| Y4 | 201B | 12.3B | 9.7B | 79.2% |
| Y5 | 210.6B | 12.8B | 9.6B | 74.7% |
| Y6 | 215.7B | 13.2B | 9.3B | 70.5% |
| Y7 | 220.8B | 13.5B | 9B | 66.5% |
| Y8 | 226.1B | 13.8B | 8.7B | 62.7% |
| Y9 | 231.6B | 14.1B | 8.4B | 59.2% |
| Y10 | 237.1B | 14.5B | 8.1B | 55.8% |
| Terminal | — | — | 236.5B | — |
Educational DCF model only — not financial advice. Terminal value and assumptions dominate results; verify filings and run your own diligence.