Financials The Home Depot, Inc. Wiener Boerse

Equities

HD

US4370761029

Home Improvement Products & Services Retailers

Real-time Estimate Tradegate 04:59:02 2024-07-11 am EDT 5-day change 1st Jan Change
317.4 EUR +1.66% Intraday chart for The Home Depot, Inc. +0.69% -0.64%

Valuation

Fiscal Period: Januar 2020 2021 2022 2023 2024 2025 2026 2027
Capitalization 1 255,102 299,349 382,755 322,766 353,617 341,294 - -
Enterprise Value (EV) 1 284,452 328,692 420,498 363,202 393,968 379,089 375,632 374,330
P/E ratio 22.8 x 23.3 x 23.6 x 19 x 23.5 x 22.6 x 21.2 x 19.7 x
Yield 2.39% 2.21% 2.07% - - 2.62% 2.79% 3%
Capitalization / Revenue 2.31 x 2.27 x 2.53 x 2.05 x 2.32 x 2.21 x 2.14 x 2.05 x
EV / Revenue 2.58 x 2.49 x 2.78 x 2.31 x 2.58 x 2.45 x 2.36 x 2.25 x
EV / EBITDA 15.7 x 15.7 x 16.2 x 13.4 x 15.8 x 15.2 x 14.4 x 13.6 x
EV / FCF 25.8 x 20.1 x 30 x 31.6 x 22 x 22.7 x 22.6 x 21.5 x
FCF Yield 3.88% 4.98% 3.33% 3.17% 4.56% 4.4% 4.42% 4.65%
Price to Book -80.9 x 90.8 x -224 x - 341 x 54.1 x 53.1 x 29.2 x
Nbr of stocks (in thousands) 1,090,831 1,076,601 1,044,239 1,019,186 995,262 991,614 - -
Reference price 2 233.9 278.0 366.5 316.7 355.3 344.2 344.2 344.2
Announcement Date 2/25/20 2/23/21 2/22/22 2/21/23 2/20/24 - - -
1USD in Million2USD
Estimates

Income Statement Evolution (Annual data)

Fiscal Period: Januar 2020 2021 2022 2023 2024 2025 2026 2027
Net sales 1 110,225 132,110 151,157 157,403 152,669 154,750 159,254 166,654
EBITDA 1 18,139 20,907 25,902 27,014 24,936 24,932 26,064 27,473
EBIT 1 15,843 18,388 23,040 24,039 21,689 21,746 22,852 24,246
Operating Margin 14.37% 13.92% 15.24% 15.27% 14.21% 14.05% 14.35% 14.55%
Earnings before Tax (EBT) 1 14,715 16,978 21,737 22,477 19,924 19,963 21,017 22,261
Net income 1 11,242 12,866 16,433 17,105 15,143 15,120 15,919 16,785
Net margin 10.2% 9.74% 10.87% 10.87% 9.92% 9.77% 10% 10.07%
EPS 2 10.25 11.94 15.53 16.69 15.11 15.25 16.22 17.48
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,686 16,615 17,401
FCF margin 10.02% 12.4% 9.27% 7.3% 11.75% 10.78% 10.43% 10.44%
FCF Conversion (EBITDA) 60.89% 78.33% 54.07% 42.56% 71.97% 66.93% 63.75% 63.34%
FCF Conversion (Net income) 98.25% 127.28% 85.22% 67.21% 118.51% 110.35% 104.37% 103.67%
Dividend per Share 2 5.580 6.150 7.600 - - 9.011 9.593 10.34
Announcement Date 2/25/20 2/23/21 2/22/22 2/21/23 2/20/24 - - -
1USD in Million2USD
Estimates

Income Statement Evolution (Quarterly data)

Fiscal Period: January 2022 Q4 2023 Q1 2023 Q2 2023 Q3 2023 Q4 2024 Q1 2024 Q2 2024 Q3 2024 Q4 2025 Q1 2025 Q2 2025 Q3 2025 Q4 2026 Q1 2026 Q2
Net sales 1 35,719 38,908 43,792 38,872 35,831 37,257 42,916 37,710 34,786 36,418 42,693 38,090 37,762 38,331 44,659
EBITDA 1 5,559 6,656 7,956 6,891 5,511 6,344 7,384 6,233 4,975 5,916 7,250 6,261 5,567 6,359 7,856
EBIT 1 4,825 5,929 7,210 6,148 4,752 5,551 6,589 5,406 4,143 5,079 6,482 5,474 4,713 5,473 6,936
Operating Margin 13.51% 15.24% 16.46% 15.82% 13.26% 14.9% 15.35% 14.34% 11.91% 13.95% 15.18% 14.37% 12.48% 14.28% 15.53%
Earnings before Tax (EBT) 1 4,502 5,560 6,831 5,742 4,344 5,110 6,161 4,968 3,685 4,651 6,025 5,030 4,246 5,032 6,502
Net income 1 3,352 4,231 5,173 4,339 3,362 3,873 4,659 3,810 2,801 3,600 4,539 3,787 3,190 3,799 4,909
Net margin 9.38% 10.87% 11.81% 11.16% 9.38% 10.4% 10.86% 10.1% 8.05% 9.89% 10.63% 9.94% 8.45% 9.91% 10.99%
EPS 2 3.210 4.090 5.050 4.240 3.300 3.820 4.650 3.810 2.820 3.630 4.580 3.820 3.225 3.845 4.988
Dividend per Share 2 1.900 1.900 1.900 1.900 - 2.090 - - - - 2.256 2.256 2.270 2.362 2.306
Announcement Date 2/22/22 5/17/22 8/16/22 11/15/22 2/21/23 5/16/23 8/15/23 11/14/23 2/20/24 5/14/24 - - - - -
1USD in Million2USD
Estimates

Balance Sheet Analysis

Fiscal Period: January 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 29,350 29,343 37,743 40,436 40,351 37,796 34,338 33,037
Net Cash position 1 - - - - - - - -
Leverage (Debt/EBITDA) 1.618 x 1.404 x 1.457 x 1.497 x 1.618 x 1.516 x 1.317 x 1.203 x
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,686 16,615 17,401
ROE (net income / shareholders' equity) - 458% 2,050% - 1,162% 378% 203% 168%
ROA (Net income/ Total Assets) 23.6% 21.1% 23.1% 23.1% 19.8% 17.5% 18.5% 18.8%
Assets 1 47,615 60,908 71,229 74,161 76,488 86,563 85,891 89,282
Book Value Per Share 2 -2.890 3.060 -1.640 - 1.040 6.360 6.480 11.80
Cash Flow per Share 2 12.50 17.50 15.70 14.30 21.10 19.80 20.90 23.30
Capex 1 2,678 2,463 2,566 3,119 3,226 3,167 3,259 3,381
Capex / Sales 2.43% 1.86% 1.7% 1.98% 2.11% 2.05% 2.05% 2.03%
Announcement Date 2/25/20 2/23/21 2/22/22 2/21/23 2/20/24 - - -
1USD in Million2USD
Estimates

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Change in Enterprise Value/EBITDA

Trading Rating
Investor Rating
ESG Refinitiv
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
35
Last Close Price
344.2 USD
Average target price
381.6 USD
Spread / Average Target
+10.86%
Consensus
  1. Stock Market
  2. Equities
  3. HD Stock
  4. HD Stock
  5. Financials The Home Depot, Inc.