Financials The Home Depot, Inc. Buenos Aires S.E.

Equities

HD

ARDEUT111705

Home Improvement Products & Services Retailers

End-of-day quote Buenos Aires S.E. 06:00:00 2024-06-12 pm EDT 5-day change 1st Jan Change
13,864 ARS -1.18% Intraday chart for The Home Depot, Inc. +3.03% +32.29%

Valuation

Fiscal Period: January 2020 2021 2022 2023 2024 2025 2026 2027
Capitalization 1 255,102 299,349 382,755 322,766 353,617 344,963 - -
Enterprise Value (EV) 1 284,452 328,692 420,498 363,202 393,968 381,277 379,112 377,728
P/E ratio 22.8 x 23.3 x 23.6 x 19 x 23.5 x 22.8 x 21.4 x 19.9 x
Yield 2.39% 2.21% 2.07% - - 2.59% 2.76% 2.98%
Capitalization / Revenue 2.31 x 2.27 x 2.53 x 2.05 x 2.32 x 2.24 x 2.18 x 2.1 x
EV / Revenue 2.58 x 2.49 x 2.78 x 2.31 x 2.58 x 2.47 x 2.4 x 2.3 x
EV / EBITDA 15.7 x 15.7 x 16.2 x 13.4 x 15.8 x 15.3 x 14.6 x 13.8 x
EV / FCF 25.8 x 20.1 x 30 x 31.6 x 22 x 22.5 x 22.8 x 21.6 x
FCF Yield 3.88% 4.98% 3.33% 3.17% 4.56% 4.44% 4.38% 4.63%
Price to Book -80.9 x 90.8 x -224 x - 341 x 54 x 52.8 x 30.3 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 347.9 347.9 347.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: January 2020 2021 2022 2023 2024 2025 2026 2027
Net sales 1 110,225 132,110 151,157 157,403 152,669 154,079 158,076 164,381
EBITDA 1 18,139 20,907 25,902 27,014 24,936 24,894 25,987 27,277
EBIT 1 15,843 18,388 23,040 24,039 21,689 21,727 22,770 24,043
Operating Margin 14.37% 13.92% 15.24% 15.27% 14.21% 14.1% 14.4% 14.63%
Earnings before Tax (EBT) 1 14,715 16,978 21,737 22,477 19,924 20,026 21,057 22,289
Net income 1 11,242 12,866 16,433 17,105 15,143 15,153 15,923 16,821
Net margin 10.2% 9.74% 10.87% 10.87% 9.92% 9.83% 10.07% 10.23%
EPS 2 10.25 11.94 15.53 16.69 15.11 15.28 16.25 17.51
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,912 16,622 17,482
FCF margin 10.02% 12.4% 9.27% 7.3% 11.75% 10.98% 10.52% 10.64%
FCF Conversion (EBITDA) 60.89% 78.33% 54.07% 42.56% 71.97% 67.93% 63.96% 64.09%
FCF Conversion (Net income) 98.25% 127.28% 85.22% 67.21% 118.51% 111.6% 104.39% 103.93%
Dividend per Share 2 5.580 6.150 7.600 - - 9.025 9.608 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,463 37,691 37,413 37,913 44,144
EBITDA 1 5,559 6,656 7,956 6,891 5,511 6,344 7,384 6,233 4,975 5,916 7,241 6,231 5,538 6,244 7,729
EBIT 1 4,825 5,929 7,210 6,148 4,752 5,551 6,589 5,406 4,143 5,079 6,469 5,460 4,711 5,433 6,876
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.49% 12.59% 14.33% 15.58%
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,037 5,043 4,268 5,038 6,494
Net income 1 3,352 4,231 5,173 4,339 3,362 3,873 4,659 3,810 2,801 3,600 4,543 3,797 3,216 3,804 4,903
Net margin 9.38% 10.87% 11.81% 11.16% 9.38% 10.4% 10.86% 10.1% 8.05% 9.89% 10.7% 10.07% 8.6% 10.03% 11.11%
EPS 2 3.210 4.090 5.050 4.240 3.300 3.820 4.650 3.810 2.820 3.630 4.587 3.830 3.252 3.876 5.008
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 36,314 34,149 32,765
Net Cash position 1 - - - - - - - -
Leverage (Debt/EBITDA) 1.618 x 1.404 x 1.457 x 1.497 x 1.618 x 1.459 x 1.314 x 1.201 x
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,912 16,622 17,482
ROE (net income / shareholders' equity) - 458% 2,050% - 1,162% 376% 202% 167%
ROA (Net income/ Total Assets) 23.6% 21.1% 23.1% 23.1% 19.8% 19.3% 20.2% 21.6%
Assets 1 47,615 60,908 71,229 74,161 76,488 78,442 78,891 77,873
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,122 3,169 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
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
35
Last Close Price
347.9 USD
Average target price
380.8 USD
Spread / Average Target
+9.45%
Consensus
  1. Stock Market
  2. Equities
  3. HD Stock
  4. HD Stock
  5. Financials The Home Depot, Inc.