Projected Income Statement: The Home Depot, Inc.

Forecast Balance Sheet: The Home Depot, Inc.

Fiscal Period: February 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 29,343 37,743 40,436 40,351 51,408 49,649 51,679 52,182
Change - 28.63% 7.14% -0.21% 27.4% -3.42% -4.15% 0.97%
Announcement Date 23/02/21 22/02/22 21/02/23 20/02/24 25/02/25 24/02/26 - -
1USD in Million
Estimates

Cash Flow Forecast: The Home Depot, Inc.

Fiscal Period: February 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 2,463 2,566 3,119 3,226 3,485 3,679 4,219 4,330
Change - 4.18% 21.55% 3.43% 8.03% 5.57% 5.42% 2.61%
Free Cash Flow (FCF) 1 16,376 14,005 11,496 17,946 16,325 12,646 15,581 15,742
Change - -14.48% -17.92% 56.11% -9.03% -22.54% 7.29% 1.03%
Announcement Date 23/02/21 22/02/22 21/02/23 20/02/24 25/02/25 24/02/26 - -
1USD in Million
Estimates

Forecast Financial Ratios: The Home Depot, Inc.

Fiscal Period: February 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 15.83% 17.14% 17.16% 16.33% 15.4% 15.19% 14.98% 15.21%
EBIT Margin (%) 13.92% 15.24% 15.27% 14.21% 13.49% 13.05% 12.84% 13.11%
EBT Margin (%) 12.85% 14.38% 14.28% 13.05% 12.17% 11.3% 11.31% 11.66%
Net margin (%) 9.74% 10.87% 10.87% 9.92% 9.28% 8.6% 8.56% 8.86%
FCF margin (%) 12.4% 9.27% 7.3% 11.75% 10.23% 7.68% 9.1% 8.83%
FCF / Net Income (%) 127.28% 85.22% 67.21% 118.51% 110.26% 89.33% 106.36% 99.67%

Profitability

        
ROA 21.12% 23.07% 23.06% 19.8% 17.15% 14.53% 13.8% 15.62%
ROE 458.03% 2,050.28% - 1,162.16% 385.37% 150.29% 91.23% 88.05%

Financial Health

        
Leverage (Debt/EBITDA) 1.4x 1.46x 1.5x 1.62x 2.09x 1.99x 2.01x 1.93x
Debt / Free cash flow 1.79x 2.69x 3.52x 2.25x 3.15x 3.93x 3.32x 3.31x

Capital Intensity

        
CAPEX / Current Assets (%) 1.86% 1.7% 1.98% 2.11% 2.18% 2.23% 2.47% 2.43%
CAPEX / EBITDA (%) 11.78% 9.91% 11.55% 12.94% 14.19% 14.71% 16.45% 15.97%
CAPEX / FCF (%) 15.04% 18.32% 27.13% 17.98% 21.35% 29.09% 27.08% 27.5%

Items per share

        
Cash flow per share 1 17.48 15.66 14.26 21.13 19.95 16.41 21.04 22.96
Change - -10.38% -8.96% 48.19% -5.59% -17.76% 4.35% 9.13%
Dividend per Share 1 6.15 7.6 - 8.52 9 9.177 9.33 9.954
Change - 23.58% - - 5.63% 1.96% 1.67% 6.69%
Book Value Per Share 1 3.063 -1.639 - 1.042 6.687 12.88 18.73 18.86
Change - -153.49% - - 541.79% 92.58% 51.55% 0.66%
EPS 1 11.94 15.53 16.69 15.11 14.91 14.23 14.6 15.94
Change - 30.07% 7.47% -9.47% -1.32% -4.56% 3.93% 9.23%
Nbr of stocks (in thousands) 1,076,601 1,044,239 1,019,186 995,262 993,363 995,511 995,511 995,511
Announcement Date 23/02/21 22/02/22 21/02/23 20/02/24 25/02/25 24/02/26 - -
1USD
Estimates
2026 2027 *
P/E ratio 26.6x 24.5x
PBR 29.4x 19.1x
EV / Sales 2.59x 2.38x
Yield 2.56% 2.61%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
AA
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
37
Last Close Price
357.92USD
Average target price
410.27USD
Spread / Average Target
+14.63%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. HD Stock
  4. Financials The Home Depot, Inc.