Financials Home Depot (The) CINNOBER BOAT

Equities

0R1G

US4370761029

Home Improvement Products & Services Retailers

Delayed CINNOBER BOAT 23:11:11 2019-04-18 EDT 5-day change 1st Jan Change
181.5 EUR -.--% Intraday chart for Home Depot (The) -.--% -.--%

Valuation

Fiscal Period: January 2020 2021 2022 2023 2024 2025 2026 2027
Capitalization 1 255,102 299,349 382,755 322,766 353,617 328,323 - -
Enterprise Value (EV) 1 284,452 328,692 420,498 363,202 393,968 365,204 363,942 361,835
P/E ratio 22.8 x 23.3 x 23.6 x 19 x 23.5 x 21.4 x 20.2 x 18.7 x
Yield 2.39% 2.21% 2.07% - - 2.76% 2.94% 3.17%
Capitalization / Revenue 2.31 x 2.27 x 2.53 x 2.05 x 2.32 x 2.13 x 2.08 x 2 x
EV / Revenue 2.58 x 2.49 x 2.78 x 2.31 x 2.58 x 2.37 x 2.3 x 2.2 x
EV / EBITDA 15.7 x 15.7 x 16.2 x 13.4 x 15.8 x 14.7 x 14 x 13.3 x
EV / FCF 25.8 x 20.1 x 30 x 31.6 x 22 x 21.7 x 22 x 20.7 x
FCF Yield 3.88% 4.98% 3.33% 3.17% 4.56% 4.62% 4.54% 4.82%
Price to Book -80.9 x 90.8 x -224 x - 341 x 50.7 x 49.6 x 28.5 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 327.0 327.0 327.0
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,133 158,125 164,246
EBITDA 1 18,139 20,907 25,902 27,014 24,936 24,917 25,981 27,297
EBIT 1 15,843 18,388 23,040 24,039 21,689 21,730 22,753 23,990
Operating Margin 14.37% 13.92% 15.24% 15.27% 14.21% 14.1% 14.39% 14.61%
Earnings before Tax (EBT) 1 14,715 16,978 21,737 22,477 19,924 20,041 21,030 22,265
Net income 1 11,242 12,866 16,433 17,105 15,143 15,149 15,889 16,761
Net margin 10.2% 9.74% 10.87% 10.87% 9.92% 9.83% 10.05% 10.2%
EPS 2 10.25 11.94 15.53 16.69 15.11 15.28 16.23 17.53
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,867 16,528 17,443
FCF margin 10.02% 12.4% 9.27% 7.3% 11.75% 10.94% 10.45% 10.62%
FCF Conversion (EBITDA) 60.89% 78.33% 54.07% 42.56% 71.97% 67.69% 63.62% 63.9%
FCF Conversion (Net income) 98.25% 127.28% 85.22% 67.21% 118.51% 111.34% 104.03% 104.07%
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,461 37,683 37,425 37,890 44,091
EBITDA 1 5,559 6,656 7,956 6,891 5,511 6,344 7,384 6,233 4,975 5,916 7,237 6,236 5,560 6,239 7,717
EBIT 1 4,825 5,929 7,210 6,148 4,752 5,551 6,589 5,406 4,143 5,079 6,465 5,463 4,709 5,431 6,871
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.5% 12.58% 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,043 5,055 4,248 5,024 6,473
Net income 1 3,352 4,231 5,173 4,339 3,362 3,873 4,659 3,810 2,801 3,600 4,542 3,801 3,215 3,793 4,888
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.09% 8.59% 10.01% 11.09%
EPS 2 3.210 4.090 5.050 4.240 3.300 3.820 4.650 3.810 2.820 3.630 4.589 3.838 3.254 3.838 4.970
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,880 35,619 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.48 x 1.371 x 1.228 x
Free Cash Flow 1 11,045 16,376 14,005 11,496 17,946 16,867 16,528 17,443
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.1% 20.4% 21.1%
Assets 1 47,615 60,908 71,229 74,161 76,488 79,239 77,926 79,435
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 19.80 20.90 23.30
Capex 1 2,678 2,463 2,566 3,119 3,226 3,119 3,167 3,298
Capex / Sales 2.43% 1.86% 1.7% 1.98% 2.11% 2.02% 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
34
Last Close Price
331.1 USD
Average target price
380.7 USD
Spread / Average Target
+14.98%
Consensus
  1. Stock Market
  2. Equities
  3. HD Stock
  4. 0R1G Stock
  5. Financials Home Depot (The)