Financials The Home Depot, Inc.

Equities

HD

US4370761029

Home Improvement Products & Services Retailers

Market Closed - Nyse 04:00:03 2024-05-31 pm EDT 5-day change 1st Jan Change
334.9 USD +1.74% Intraday chart for The Home Depot, Inc. +3.02% -3.36%

Valuation

Fiscal Period: January 2020 2021 2022 2023 2024 2025 2026 2027
Capitalization 1 255,102 299,349 382,755 322,766 353,617 332,062 - -
Enterprise Value (EV) 1 284,452 328,692 420,498 363,202 393,968 368,571 366,832 365,573
P/E ratio 22.8 x 23.3 x 23.6 x 19 x 23.5 x 21.9 x 20.6 x 19 x
Yield 2.39% 2.21% 2.07% - - 2.7% 2.87% 3.1%
Capitalization / Revenue 2.31 x 2.27 x 2.53 x 2.05 x 2.32 x 2.15 x 2.1 x 2.02 x
EV / Revenue 2.58 x 2.49 x 2.78 x 2.31 x 2.58 x 2.39 x 2.32 x 2.22 x
EV / EBITDA 15.7 x 15.7 x 16.2 x 13.4 x 15.8 x 14.8 x 14.1 x 13.4 x
EV / FCF 25.8 x 20.1 x 30 x 31.6 x 22 x 21.4 x 22.1 x 20.9 x
FCF Yield 3.88% 4.98% 3.33% 3.17% 4.56% 4.67% 4.53% 4.78%
Price to Book -80.9 x 90.8 x -224 x - 341 x 52 x 50.8 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 334.9 334.9 334.9
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: Enero 2020 2021 2022 2023 2024 2025 2026 2027
Net sales 1 110,225 132,110 151,157 157,403 152,669 154,166 158,192 164,451
EBITDA 1 18,139 20,907 25,902 27,014 24,936 24,928 25,983 27,358
EBIT 1 15,843 18,388 23,040 24,039 21,689 21,732 22,758 24,039
Operating Margin 14.37% 13.92% 15.24% 15.27% 14.21% 14.1% 14.39% 14.62%
Earnings before Tax (EBT) 1 14,715 16,978 21,737 22,477 19,924 20,041 21,059 22,367
Net income 1 11,242 12,866 16,433 17,105 15,143 15,147 15,908 16,820
Net margin 10.2% 9.74% 10.87% 10.87% 9.92% 9.82% 10.06% 10.23%
EPS 2 10.25 11.94 15.53 16.69 15.11 15.28 16.25 17.60
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 17,225 16,602 17,482
FCF margin 10.02% 12.4% 9.27% 7.3% 11.75% 11.17% 10.49% 10.63%
FCF Conversion (EBITDA) 60.89% 78.33% 54.07% 42.56% 71.97% 69.1% 63.9% 63.9%
FCF Conversion (Net income) 98.25% 127.28% 85.22% 67.21% 118.51% 113.72% 104.36% 103.94%
Dividend per Share 2 5.580 6.150 7.600 - - 9.028 9.612 10.37
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,469 37,691 37,428 37,981 44,150
EBITDA 1 5,559 6,656 7,956 6,891 5,511 6,344 7,384 6,233 4,975 5,916 7,238 6,240 5,551 6,241 7,681
EBIT 1 4,825 5,929 7,210 6,148 4,752 5,551 6,589 5,406 4,143 5,079 6,470 5,467 4,707 5,417 6,872
Operating Margin 13.51% 15.24% 16.46% 15.82% 13.26% 14.9% 15.35% 14.34% 11.91% 13.95% 15.23% 14.51% 12.58% 14.26% 15.56%
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,034 5,056 4,250 4,998 6,464
Net income 1 3,352 4,231 5,173 4,339 3,362 3,873 4,659 3,810 2,801 3,600 4,547 3,805 3,215 3,773 4,881
Net margin 9.38% 10.87% 11.81% 11.16% 9.38% 10.4% 10.86% 10.1% 8.05% 9.89% 10.71% 10.1% 8.59% 9.93% 11.05%
EPS 2 3.210 4.090 5.050 4.240 3.300 3.820 4.650 3.810 2.820 3.630 4.596 3.843 3.256 3.847 4.998
Dividend per Share 2 1.900 1.900 1.900 1.900 - 2.090 - - - - 2.250 2.250 2.266 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 36,509 34,770 33,512
Net Cash position 1 - - - - - - - -
Leverage (Debt/EBITDA) 1.618 x 1.404 x 1.457 x 1.497 x 1.618 x 1.465 x 1.338 x 1.225 x
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 17,225 16,602 17,482
ROE (net income / shareholders' equity) - 458% 2,050% - 1,162% 377% 191% 167%
ROA (Net income/ Total Assets) 23.6% 21.1% 23.1% 23.1% 19.8% 19% 20.1% 21.1%
Assets 1 47,615 60,908 71,229 74,161 76,488 79,530 79,277 79,714
Book Value Per Share 2 -2.890 3.060 -1.640 - 1.040 6.450 6.590 11.50
Cash Flow per Share 2 12.50 17.50 15.70 14.30 21.10 20.10 21.10 24.40
Capex 1 2,678 2,463 2,566 3,119 3,226 3,123 3,166 3,298
Capex / Sales 2.43% 1.86% 1.7% 1.98% 2.11% 2.03% 2% 2.01%
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
C+
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
34
Last Close Price
334.9 USD
Average target price
380.7 USD
Spread / Average Target
+13.68%
Consensus
  1. Stock Market
  2. Equities
  3. HD Stock
  4. Financials The Home Depot, Inc.