Loading market dashboard
The Home Depot, Inc.
HDConsumer CyclicalNYSEUS
Loading analysis workspace
Estimates, scoring, valuation assumptions, and peer comparison in one research surface.
Change the assumptions to see how revenue growth, margins, and exit multiples can move fair value.
| Year | Revenue | Margin | Profit | Free cash flow | Present value |
|---|---|---|---|---|---|
| 2026 | $164.68B | 8.6% | $14.16B | $12.68B | N/A |
| 2027 | $167.32B | 8.6% | $14.39B | $12.88B | $11.71B |
| 2028 | $170.00B | 8.6% | $14.62B | $13.09B | $10.82B |
| 2029 | $172.71B | 8.6% | $14.85B | $13.30B | $9.99B |
| 2030 | $175.48B | 8.6% | $15.09B | $13.51B | $9.23B |
| 2031 | $178.29B | 8.6% | $15.33B | $13.73B | $8.52B |
Projects EPS forward, applies an exit P/E, then discounts the result back to today.
| Base EPS | $14.23 | 2026-02-01 |
| EPS growth | -4.6% | Forecast years: 5 |
| Future EPS | $11.245 | EPS × (1 + G)^5 |
| Base P/E | 26.5 | P/E |
| Future price | $297.98 | Future EPS × P/E |
| Fair value today | $185.02 | PV @ 10.0% |
| 30% safety price | $129.52 | Margin of safety |
| 50% safety price | $92.512 | Margin of safety |
| Discount rate \\ Terminal growth | 1.5% | 2.5% | 3.5% |
|---|---|---|---|
| 9.0% | $89.713 | $106.22 | $128.74 |
| 10.0% | $72.921 | $85.095 | $101.01 |
| 11.0% | $59.665 | $68.934 | $80.675 |