The Home Depot, Inc. (HD)
DCF Valuation•Discounted Cash Flow intrinsic value with Bear, Base & Bull scenarios
Wide range: intrinsic value is highly sensitive to assumptions — use the scenario analysis to anchor your view.
The market is largely aligned with the base-case assumptions, pricing in a steady-state outcome.
Confidence reflects data quality and how far into the future most of the value sits. The main factors reducing it here are moderate reliance on terminal value and limited data coverage on some inputs.
Wide range: intrinsic value is highly sensitive to assumptions — use the scenario analysis to anchor your view.
Analyze the Bear, Base, and Bull case DCF scenarios. Compare how changes in revenue growth, operating margins, and wacc impact the final intrinsic value estimate and downside risk.
Why the values can still move a lot: DCF math is nonlinear, so even modest changes to growth, margins, discount rate, and terminal assumptions can swing present value sharply.
The forecast driving our intrinsic value estimate.
WACC
7.2%
Terminal Growth
3.0%
Revenue Growth (Y1-Y5)
3.0%
Operating Margin (Y1-Y5)
13.5%
Tax Rate
23.9%
D&A / Rev
2.1%
Capex / Rev
2.1%
NWC / Rev
17.4%
Shares
996.0M
Net Debt
$63.96B
Values shown in USD.
| Year | Revenue | Growth | EBIT | Op Margin | NOPAT | D&A | Capex | Delta WC | FCFF |
|---|---|---|---|---|---|---|---|---|---|
| Year 1 | $172.5B | 3.5% | $22.8B | 13.2% | $17.4B | $3.7B | $3.6B | $1.0B | $16.4B |
| Year 2 | $177.2B | 2.7% | $23.9B | 13.5% | $18.2B | $3.8B | $3.8B | -$637.8M | $18.7B |
| Year 3 | $182.2B | 2.8% | $24.8B | 13.6% | $18.9B | $3.9B | $4.1B | -$674.8M | $19.4B |
| Year 4 | $187.5B | 2.9% | $25.7B | 13.7% | $19.6B | $4.0B | $4.3B | -$716.0M | $20.0B |
| Year 5 | $193.0B | 3.0% | $26.2B | 13.6% | $20.0B | $4.1B | $4.5B | -$761.8M | $20.3B |
| Year 6 | $198.9B | 3.0% | $26.8B | 13.5% | $20.4B | $4.2B | $4.8B | -$812.6M | $20.6B |
| Year 7 | $205.1B | 3.1% | $27.3B | 13.3% | $20.8B | $4.4B | $5.0B | -$868.8M | $21.0B |
| Year 8 | $211.4B | 3.1% | $28.1B | 13.3% | $21.4B | $4.5B | $5.3B | -$957.4M | $21.5B |
| Year 9 | $217.8B | 3.0% | $28.8B | 13.2% | $21.9B | $4.6B | $5.6B | -$1.0B | $22.0B |
| Year 10 | $224.3B | 3.0% | $29.5B | 13.2% | $22.5B | $4.8B | $5.9B | -$1.1B | $22.5B |
Same DCF model applied to every company. If HD's gap to fair value stands apart from peers, the case is stock-specific — not a sector-wide trend.
| Company | Peer Type | Mkt Cap | Price | Intrinsic Value | Upside / Premium | Status |
|---|---|---|---|---|---|---|
| HDThe Home Depot, Inc.You are here | Subject | — | $334.28 | $353.22 | +6% | Fair Value |
| Core | $124.5B | $222.10 | $293.96 | +32% | Undervalued | |
| Core | $15.9B | $30.24 | $43.80 | +45% | Undervalued | |
| Core | $5.7B | $53.03 | $0.00 | -100% | — | |
| Core | $8.9B | $80.59 | $98.20 | +22% | Undervalued | |
| Segment | $467M | $15.55 | — | — | — | |
| Segment | $16.3B | $401.04 | $140.13 | -65% | Overvalued | |
| Segment | $4.9B | $110.17 | $113.65 | +3% | Fair Value |
Differences in intrinsic value reflect differences in each company's financial data and business model — not inconsistency in the methodology. Peer rows without DCF coverage show “—”.
Answers to common questions about HD's valuation and our methodology.
The base-case intrinsic value for HD is estimated at $353.22. This is calculated using a Discounted Cash Flow (DCF) model that projects future cash flows and discounts them to today's present value.
Based on our DCF valuation, The Home Depot, Inc. appears fairly valued. Our base-case estimate of $353.22 is perfectly in line with the current price of $334.28.
Under our base-case scenario, HD has an implied 6% downside risk. In our bull-case scenario, the intrinsic value could be significantly higher if growth and margins exceed baseline expectations.
We apply a discount rate (WACC) of 7.2% to calculate the present value of HD's future cash flows. This rate reflects the perceived risk and cost of capital for the business.
The model assumes a consensus-driven baseline growth rate for the next 5 years, which gradually tapers down to a terminal growth rate of 3.0%. The exact rates flex depending on whether you are viewing the bear, base, or bull scenario.
This valuation projects future free cash flow (FCFF) and discounts them back to present value using a WACC. For enterprise models, we then adjust for net debt and divide by diluted shares to calculate the final equity value per share.
Disclaimer: This page is for informational purposes only and does not constitute financial advice. Intrinsic value estimates are model outputs under stated assumptions and should not be relied upon as the sole basis for any investment decision.
Deep dive into HD consensus models and risk factors.
Wall Street verdict, signals, and target summaries.
DCF models, multiple analysis, and analyst estimates.
10-year return with dividends reinvested.
See how regular investing compounds over time.
Compare growth, multiples, and margins vs sector.