Financials The Home Depot, Inc.
Equities
HD
US4370761029
Home Improvement Products & Services Retailers
|
Market Closed -
Other stock markets
|
5-day change | 1st Jan Change | ||
| 302.55 USD | -2.55% |
|
-6.35% | -12.07% |
| May. 13 | Truist Cuts Price Target on Home Depot to $394 From $424, Keeps Buy Rating | MT |
| May. 12 | Citigroup Adjusts Price Target on Home Depot to $400 From $450, Maintains Buy Rating | MT |
Projected Income Statement: The Home Depot, Inc.
| Fiscal Period: February | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 |
|---|---|---|---|---|---|---|---|---|
| Net sales 1 | 151,157 | 157,403 | 152,669 | 159,514 | 164,683 | 171,177 | 178,216 | 186,101 |
| Change | - | 4.13% | -3.01% | 4.48% | 3.24% | 3.94% | 4.11% | 4.42% |
| EBITDA 1 | 25,902 | 27,014 | 24,936 | 24,560 | 25,011 | 25,575 | 27,053 | 28,773 |
| Change | - | 4.29% | -7.69% | -1.51% | 1.84% | 2.26% | 5.78% | 6.36% |
| EBIT 1 | 23,040 | 24,039 | 21,689 | 21,526 | 21,497 | 21,974 | 23,376 | 24,892 |
| Change | - | 4.34% | -9.78% | -0.75% | -0.13% | 2.22% | 6.38% | 6.48% |
| Interest Paid 1 | -1,303 | -1,562 | -1,765 | -2,120 | -2,288 | -2,281 | -2,213 | -2,321 |
| Earnings before Tax (EBT) 1 | 21,737 | 22,477 | 19,924 | 19,406 | 18,602 | 19,290 | 20,732 | 22,479 |
| Change | - | 3.4% | -11.36% | -2.6% | -4.14% | 3.7% | 7.48% | 8.42% |
| Net income 1 | 16,433 | 17,105 | 15,143 | 14,806 | 14,156 | 14,551 | 15,677 | 17,005 |
| Change | - | 4.09% | -11.47% | -2.23% | -4.39% | 2.79% | 7.74% | 8.47% |
| Announcement Date | 2/22/22 | 2/21/23 | 2/20/24 | 2/25/25 | 2/24/26 | - | - | - |
Forecast Balance Sheet: The Home Depot, Inc.
| Fiscal Period: February | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 |
|---|---|---|---|---|---|---|---|---|
| Net Debt 1 | 37,743 | 40,436 | 40,351 | 51,408 | 49,649 | 51,748 | 52,272 | 52,377 |
| Change | - | 7.14% | -0.21% | 27.4% | -3.42% | 4.23% | 1.01% | 0.2% |
| Announcement Date | 2/22/22 | 2/21/23 | 2/20/24 | 2/25/25 | 2/24/26 | - | - | - |
Cash Flow Forecast: The Home Depot, Inc.
| Fiscal Period: February | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 |
|---|---|---|---|---|---|---|---|---|
| CAPEX 1 | 2,566 | 3,119 | 3,226 | 3,485 | 3,679 | 4,235 | 4,342 | 4,539 |
| Change | - | 21.55% | 3.43% | 8.03% | 5.57% | 15.12% | 2.52% | 4.54% |
| Free Cash Flow (FCF) 1 | 14,005 | 11,496 | 17,946 | 16,325 | 12,646 | 15,831 | 15,739 | 17,116 |
| Change | - | -17.92% | 56.11% | -9.03% | -22.54% | 25.19% | -0.58% | 8.75% |
| Announcement Date | 2/22/22 | 2/21/23 | 2/20/24 | 2/25/25 | 2/24/26 | - | - | - |
Forecast Financial Ratios: The Home Depot, Inc.
| Fiscal Period: February | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 |
|---|---|---|---|---|---|---|---|---|
Profitability | ||||||||
| EBITDA Margin (%) | 17.14% | 17.16% | 16.33% | 15.4% | 15.19% | 14.94% | 15.18% | 15.46% |
| EBIT Margin (%) | 15.24% | 15.27% | 14.21% | 13.49% | 13.05% | 12.84% | 13.12% | 13.38% |
| EBT Margin (%) | 14.38% | 14.28% | 13.05% | 12.17% | 11.3% | 11.27% | 11.63% | 12.08% |
| Net margin (%) | 10.87% | 10.87% | 9.92% | 9.28% | 8.6% | 8.5% | 8.8% | 9.14% |
| FCF margin (%) | 9.27% | 7.3% | 11.75% | 10.23% | 7.68% | 9.25% | 8.83% | 9.2% |
| FCF / Net Income (%) | 85.22% | 67.21% | 118.51% | 110.26% | 89.33% | 108.8% | 100.4% | 100.65% |
Profitability | ||||||||
| ROA | 23.07% | 23.06% | 19.8% | 17.15% | 14.53% | 14.83% | 15.79% | 14.6% |
| ROE | 2,050.28% | - | 1,162.16% | 385.37% | 150.29% | 93.09% | 87.22% | 123.32% |
Financial Health | ||||||||
| Leverage (Debt/EBITDA) | 1.46x | 1.5x | 1.62x | 2.09x | 1.99x | 2.02x | 1.93x | 1.82x |
| Debt / Free cash flow | 2.69x | 3.52x | 2.25x | 3.15x | 3.93x | 3.27x | 3.32x | 3.06x |
Capital Intensity | ||||||||
| CAPEX / Current Assets (%) | 1.7% | 1.98% | 2.11% | 2.18% | 2.23% | 2.47% | 2.44% | 2.44% |
| CAPEX / EBITDA (%) | 9.91% | 11.55% | 12.94% | 14.19% | 14.71% | 16.56% | 16.05% | 15.78% |
| CAPEX / FCF (%) | 18.32% | 27.13% | 17.98% | 21.35% | 29.09% | 26.75% | 27.59% | 26.52% |
Items per share | ||||||||
| Cash flow per share 1 | 15.66 | 14.26 | 21.13 | 19.95 | 16.41 | 21.22 | 22.82 | 25.41 |
| Change | - | -8.96% | 48.19% | -5.59% | -17.76% | 29.31% | 7.58% | 11.32% |
| Dividend per Share 1 | 7.6 | - | 8.52 | 9 | - | 9.306 | 9.895 | 10.59 |
| Change | - | - | - | 5.63% | - | - | 6.32% | 7.07% |
| Book Value Per Share 1 | -1.639 | - | 1.042 | 6.687 | 12.88 | 18.73 | 18.82 | 19.29 |
| Change | - | - | - | 541.79% | 92.58% | 45.44% | 0.5% | 2.5% |
| EPS 1 | 15.53 | 16.69 | 15.11 | 14.91 | 14.23 | 14.52 | 15.77 | 17.26 |
| Change | - | 7.47% | -9.47% | -1.32% | -4.56% | 2.07% | 8.57% | 9.44% |
| Nbr of stocks (in thousands) | 1,044,239 | 1,019,186 | 995,262 | 993,363 | 995,511 | 996,028 | 996,028 | 996,028 |
| Announcement Date | 2/22/22 | 2/21/23 | 2/20/24 | 2/25/25 | 2/24/26 | - | - | - |
| 2027 * | 2028 * | |
|---|---|---|
| P/E ratio | 20.8x | 19.2x |
| PBR | 16.2x | 16.1x |
| EV / Sales | 2.06x | 1.98x |
| Yield | 3.08% | 3.27% |
EPS & Dividend
Y-o-Y evolution of P/E
Year-on-year evolution of the Yield
Trader
This super rating is the result of a weighted average of the rankings based on the following ratings: Valuation (Composite), EPS Revisions (4 months), and Visibility (Composite). We recommend that you carefully review the associated descriptions.
Investor
This super composite rating is the result of a weighted average of the rankings based on the following ratings: Fundamentals (Composite), Valuation (Composite), EPS Revisions (1 year), and Visibility (Composite). We recommend that you carefully review the associated descriptions.
Global
This composite rating is the result of an average of the rankings based on the following ratings: Fundamentals (Composite), Valuation (Composite), Financial Estimates Revisions (Composite), Consensus (Composite) and Visibility (Composite). The company must be covered by at least 4 of these 5 ratings for the calculation to be carried out. We recommend that you carefully review the associated descriptions.
Quality
This composite rating is the result of an average of rankings based on the following ratings: Returns (Composite), Profitability (Composite) and Quality of Financial Reporting (Composite), and Financial Health (Composite). The company must be covered by at least 2 of these 3 ratings for the calculation to be performed. We recommend that you carefully read the associated descriptions.
ESG MSCI
The MSCI ESG score assesses a company’s environmental, social, and governance practices relative to its industry peers. Companies are rated from CCC (laggard) to AAA (leader). This rating helps investors incorporate sustainability risks and opportunities into their investment decisions.
Quarterly revenue - Rate of surprise
- Stock Market
- Equities
- HD Stock
- Financials The Home Depot, Inc.
Select your edition
All financial news and data tailored to specific country editions
