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 379,290 - -
Change - 33.19% -11.26% 2.66% 15.11% -7.32% - -
Enterprise Value (EV) 1 322,351 428,007 386,745 395,888 460,654 433,211 429,545 429,965
Change - 32.78% -9.64% 2.36% 16.36% -5.96% -0.85% 0.1%
P/E ratio 22.8x 24.1x 20.4x 23.6x 27.6x 27.1x 25.9x 23.8x
PBR 88.9x -228x - 343x 61.6x 30.8x 23.4x 21.6x
PEG - 0.8x 2.73x -2.49x -20.85x -4.84x 5.66x 2.66x
Capitalization / Revenue 2.22x 2.58x 2.2x 2.33x 2.57x 2.31x 2.21x 2.12x
EV / Revenue 2.44x 2.83x 2.46x 2.59x 2.89x 2.64x 2.51x 2.4x
EV / EBITDA 15.4x 16.5x 14.3x 15.9x 18.8x 17.4x 16.7x 15.8x
EV / EBIT 17.5x 18.6x 16.1x 18.3x 21.4x 20.4x 19.5x 18.4x
EV / FCF 19.7x 30.6x 33.6x 22.1x 28.2x 29.8x 27.6x 27x
FCF Yield 5.08% 3.27% 2.97% 4.53% 3.54% 3.35% 3.63% 3.71%
Dividend per Share 2 6.15 7.6 - 8.52 9 9.195 9.58 10.16
Rate of return 2.26% 2.03% - 2.39% 2.18% 2.41% 2.51% 2.67%
EPS 2 11.94 15.53 16.69 15.11 14.91 14.07 14.72 16.04
Distribution rate 51.5% 48.9% - 56.4% 60.4% 65.3% 65.1% 63.4%
Net sales 1 132,110 151,157 157,403 152,669 159,514 164,275 171,413 178,842
EBITDA 1 20,907 25,902 27,014 24,936 24,560 24,876 25,654 27,150
EBIT 1 18,388 23,040 24,039 21,689 21,526 21,270 21,999 23,389
Net income 1 12,866 16,433 17,105 15,143 14,806 14,023 14,559 15,795
Net Debt 1 29,343 37,743 40,436 40,351 51,408 53,921 50,255 50,675
Reference price 2 272.16 373.73 339.79 357.23 411.98 381.00 381.00 381.00
Nbr of stocks (in thousands) 1,076,601 1,044,239 1,019,186 995,262 993,363 995,511 - -
Announcement Date 23/02/21 22/02/22 21/02/23 20/02/24 25/02/25 - - -
1USD in Million2USD
Estimates

P/E ratio, Detailed evolution

P/E (Y) EV / Sales (Y) EV / EBITDA (Y) Dividend Yield (Y) Capi.($)
27.36x2.66x17.58x2.38% 383B
23.14x2.27x15.77x1.7% 156B
15.63x0.6x5.93x3.6% 7.98B
26.42x3.25x13.01x3.11% 4.3B
14.8x1.52x8.81x5.79% 2.8B
18.75x - - 1.83% 2.68B
19.07x1.73x9.85x2.66% 2.32B
9.52x0.4x5.05x2.96% 1.55B
Average 19.34x 1.77x 10.86x 3% 70.15B
Weighted average by Cap. 25.83x 2.51x 16.76x 2.23%
See all sector valuations

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.