Company Valuation: The Home Depot, Inc.

Data adjusted to current consolidation scope
Fiscal Period: February 2022 2023 2024 2025 2026 2027 2028 2029
Capitalization 1 385,011 334,385 358,364 409,246 372,909 309,884 - -
Change - -13.15% 7.17% 14.2% -8.88% -16.9% - -
Enterprise Value (EV) 1 422,754 374,821 398,715 460,654 422,558 363,044 361,545 361,891
Change - -11.34% 6.37% 15.53% -8.27% -14.08% -0.41% 0.1%
P/E ratio 23.7x 19.7x 23.8x 27.6x 26.3x 21.5x 19.9x 18.1x
PBR -225x - 346x 61.6x 29.1x 16.2x 14.3x 13.2x
PEG - 2.64x -2.51x -20.85x -5.77x 14.62x 2.43x 1.88x
Capitalization / Revenue 2.55x 2.12x 2.35x 2.57x 2.26x 1.81x 1.75x 1.67x
EV / Revenue 2.8x 2.38x 2.61x 2.89x 2.57x 2.12x 2.04x 1.95x
EV / EBITDA 16.3x 13.9x 16x 18.8x 16.9x 14.2x 13.4x 12.6x
EV / EBIT 18.3x 15.6x 18.4x 21.4x 19.7x 16.6x 15.6x 14.7x
EV / FCF 30.2x 32.6x 22.2x 28.2x 33.4x 21.7x 23.4x 21.4x
FCF Yield 3.31% 3.07% 4.5% 3.54% 2.99% 4.61% 4.28% 4.67%
Dividend per Share 2 7.6 - 8.52 9 - 9.314 9.876 10.58
Rate of return 2.06% - 2.37% 2.18% - 3% 3.18% 3.4%
EPS 2 15.53 16.69 15.11 14.91 14.23 14.44 15.62 17.12
Distribution rate 48.9% - 56.4% 60.4% - 64.5% 63.2% 61.8%
Net sales 1 151,157 157,403 152,669 159,514 164,683 170,978 177,462 185,385
EBITDA 1 25,902 27,014 24,936 24,560 25,011 25,574 27,019 28,728
EBIT 1 23,040 24,039 21,689 21,526 21,497 21,883 23,134 24,667
Net income 1 16,433 17,105 15,143 14,806 14,156 14,425 15,639 16,989
Net Debt 1 37,743 40,436 40,351 51,408 49,649 53,160 51,661 52,007
Reference price 2 368.70 328.09 360.07 411.98 374.59 310.78 310.78 310.78
Nbr of stocks (in thousands) 1,044,239 1,019,186 995,262 993,363 995,511 997,117 - -
Announcement Date 2/22/22 2/21/23 2/20/24 2/25/25 2/24/26 - - -
1USD in Million2USD
Estimates

P/E ratio, Detailed evolution

P/E (Y) EV / Sales (Y) EV / EBITDA (Y) Dividend Yield (Y) Capi.($)
21.52x2.12x14.2x3% 310B
17.54x1.66x11.89x2.32% 118B
11.62x0.51x4.89x4.39% 6.37B
21.99x2.86x11.29x4.8% 3.83B
20.6x1.93x11.99x2.57% 2.55B
13.07x1.4x7.95x6.5% 2.39B
11.23x - - - 2.26B
8.42x0.38x4.79x3.2% 1.42B
Average 15.75x 1.55x 9.57x 3.83% 55.86B
Weighted average by Cap. 20.19x 1.97x 13.35x 2.87%

Y-o-Y evolution of P/E

Historical PBR trend

Evolution Enterprise Value / Sales

Change in Enterprise Value/EBITDA

Year-on-year evolution of the Yield

  1. Stock Market
  2. Equities
  3. HD Stock
  4. Valuation The Home Depot, Inc.