Company Valuation: The Home Depot, Inc.

Data adjusted to current consolidation scope
Fiscal Period: February 2021 2022 2023 2024 2025 2026 2027 2028
Capitalization 1 293,008 390,264 346,309 355,537 409,246 347,847 - -
Change - 33.19% -11.26% 2.66% 15.11% -15% - -
Enterprise Value (EV) 1 322,351 428,007 386,745 395,888 460,654 396,366 395,141 395,649
Change - 32.78% -9.64% 2.36% 16.36% -13.96% -0.31% 0.13%
P/E ratio 22.8x 24.1x 20.4x 23.6x 27.6x 23.9x 21.9x 20.1x
PBR 88.9x -228x - 343x 61.6x 27.2x 24.4x 20.1x
PEG - 0.8x 2.73x -2.49x -20.85x -12.86x 2.46x 2.23x
Capitalization / Revenue 2.22x 2.58x 2.2x 2.33x 2.57x 2.11x 2.03x 1.95x
EV / Revenue 2.44x 2.83x 2.46x 2.59x 2.89x 2.41x 2.31x 2.22x
EV / EBITDA 15.4x 16.5x 14.3x 15.9x 18.8x 15.6x 14.7x 13.9x
EV / EBIT 17.5x 18.6x 16.1x 18.3x 21.4x 18.1x 17x 16.1x
EV / FCF 19.7x 30.6x 33.6x 22.1x 28.2x 26.7x 24.2x 23.8x
FCF Yield 5.08% 3.27% 2.97% 4.53% 3.54% 3.75% 4.14% 4.21%
Dividend per Share 2 6.15 7.6 - 8.52 9 9.216 9.804 10.53
Rate of return 2.26% 2.03% - 2.39% 2.18% 2.64% 2.8% 3.01%
EPS 2 11.94 15.53 16.69 15.11 14.91 14.63 15.93 17.37
Distribution rate 51.5% 48.9% - 56.4% 60.4% 63% 61.5% 60.6%
Net sales 1 132,110 151,157 157,403 152,669 159,514 164,528 171,112 178,265
EBITDA 1 20,907 25,902 27,014 24,936 24,560 25,467 26,926 28,528
EBIT 1 18,388 23,040 24,039 21,689 21,526 21,880 23,242 24,619
Net income 1 12,866 16,433 17,105 15,143 14,806 14,590 15,701 17,151
Net Debt 1 29,343 37,743 40,436 40,351 51,408 48,519 47,294 47,802
Reference price 2 272.16 373.73 339.79 357.23 411.98 349.62 349.62 349.62
Nbr of stocks (in thousands) 1,076,601 1,044,239 1,019,186 995,262 993,363 994,928 - -
Announcement Date 2/23/21 2/22/22 2/21/23 2/20/24 2/25/25 - - -
1USD in Million2USD
Estimates

P/E ratio, Detailed evolution

P/E (Y) EV / Sales (Y) EV / EBITDA (Y) Dividend Yield (Y) Capi.($)
23.9x2.41x15.55x2.64% 348B
17.38x1.78x12.2x2.24% 119B
12.57x0.52x5.08x4.52% 6.51B
24.13x2.92x12x3.1% 3.63B
11.78x1.32x7.49x7.11% 2.36B
23.63x1.84x11.13x2.12% 2.11B
9.52x0.41x4.9x2.89% 1.65B
Average 17.56x 1.60x 9.77x 3.52% 69.05B
Weighted average by Cap. 22.03x 2.22x 14.46x 2.59%
See all sector valuations

Year-on-year evolution of the PER

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.