Financials The Home Depot, Inc.
Equities
HD
US4370761029
Home Improvement Products & Services Retailers
|
Market Closed -
Other stock markets
|
5-day change | 1st Jan Change | ||
| 380.17 USD | +0.27% |
|
+1.48% | +10.48% |
| 01-16 | ICE raids spur investor questions on Home Depot surveillance data | RE |
| 01-16 | Where the Money's Moving |  |
Projected Income Statement: The Home Depot, Inc.
| Fiscal Period: February | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|---|
| Net sales 1 | 132,110 | 151,157 | 157,403 | 152,669 | 159,514 | 164,246 | 171,474 | 178,952 |
| Change | - | 14.42% | 4.13% | -3.01% | 4.48% | 2.97% | 4.4% | 4.36% |
| EBITDA 1 | 20,907 | 25,902 | 27,014 | 24,936 | 24,560 | 24,935 | 25,723 | 27,205 |
| Change | - | 23.89% | 4.29% | -7.69% | -1.51% | 1.52% | 3.16% | 5.76% |
| EBIT 1 | 18,388 | 23,040 | 24,039 | 21,689 | 21,526 | 21,291 | 22,018 | 23,396 |
| Change | - | 25.3% | 4.34% | -9.78% | -0.75% | -1.09% | 3.41% | 6.26% |
| Interest Paid 1 | -1,300 | -1,303 | -1,562 | -1,765 | -2,120 | -2,334 | -2,351 | -2,265 |
| Earnings before Tax (EBT) 1 | 16,978 | 21,737 | 22,477 | 19,924 | 19,406 | 18,559 | 19,366 | 20,733 |
| Change | - | 28.03% | 3.4% | -11.36% | -2.6% | -4.36% | 4.34% | 7.06% |
| Net income 1 | 12,866 | 16,433 | 17,105 | 15,143 | 14,806 | 14,023 | 14,558 | 15,778 |
| Change | - | 27.72% | 4.09% | -11.47% | -2.23% | -5.29% | 3.82% | 8.38% |
| Announcement Date | 23/02/21 | 22/02/22 | 21/02/23 | 20/02/24 | 25/02/25 | - | - | - |
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 | 53,918 | 50,235 | 50,492 |
| Change | - | 28.63% | 7.14% | -0.21% | 27.4% | 4.88% | -6.83% | 0.51% |
| Announcement Date | 23/02/21 | 22/02/22 | 21/02/23 | 20/02/24 | 25/02/25 | - | - | - |
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 | 4,003 | 4,039 | 4,184 |
| Change | - | 4.18% | 21.55% | 3.43% | 8.03% | 14.86% | 0.89% | 3.61% |
| Free Cash Flow (FCF) 1 | 16,376 | 14,005 | 11,496 | 17,946 | 16,325 | 14,544 | 15,767 | 16,273 |
| Change | - | -14.48% | -17.92% | 56.11% | -9.03% | -10.91% | 8.4% | 3.21% |
| Announcement Date | 23/02/21 | 22/02/22 | 21/02/23 | 20/02/24 | 25/02/25 | - | - | - |
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.18% | 15% | 15.2% |
| EBIT Margin (%) | 13.92% | 15.24% | 15.27% | 14.21% | 13.49% | 12.96% | 12.84% | 13.07% |
| EBT Margin (%) | 12.85% | 14.38% | 14.28% | 13.05% | 12.17% | 11.3% | 11.29% | 11.59% |
| Net margin (%) | 9.74% | 10.87% | 10.87% | 9.92% | 9.28% | 8.54% | 8.49% | 8.82% |
| FCF margin (%) | 12.4% | 9.27% | 7.3% | 11.75% | 10.23% | 8.86% | 9.19% | 9.09% |
| FCF / Net Income (%) | 127.28% | 85.22% | 67.21% | 118.51% | 110.26% | 103.72% | 108.3% | 103.14% |
Profitability | ||||||||
| ROA | 21.12% | 23.07% | 23.06% | 19.8% | 17.15% | 15.05% | 15.1% | 15.93% |
| ROE | 458.03% | 2,050.28% | - | 1,162.16% | 385.37% | 153.97% | 105.56% | 97.42% |
Financial Health | ||||||||
| Leverage (Debt/EBITDA) | 1.4x | 1.46x | 1.5x | 1.62x | 2.09x | 2.16x | 1.95x | 1.86x |
| Debt / Free cash flow | 1.79x | 2.69x | 3.52x | 2.25x | 3.15x | 3.71x | 3.19x | 3.1x |
Capital Intensity | ||||||||
| CAPEX / Current Assets (%) | 1.86% | 1.7% | 1.98% | 2.11% | 2.18% | 2.44% | 2.36% | 2.34% |
| CAPEX / EBITDA (%) | 11.78% | 9.91% | 11.55% | 12.94% | 14.19% | 16.05% | 15.7% | 15.38% |
| CAPEX / FCF (%) | 15.04% | 18.32% | 27.13% | 17.98% | 21.35% | 27.52% | 25.62% | 25.71% |
Items per share | ||||||||
| Cash flow per share 1 | 17.48 | 15.66 | 14.26 | 21.13 | 19.95 | 19.78 | 21.29 | 24.29 |
| Change | - | -10.38% | -8.96% | 48.19% | -5.59% | -0.85% | 7.65% | 14.07% |
| Dividend per Share 1 | 6.15 | 7.6 | - | 8.52 | 9 | 9.185 | 9.58 | 10.16 |
| Change | - | 23.58% | - | - | 5.63% | 2.06% | 4.3% | 6.09% |
| Book Value Per Share 1 | 3.063 | -1.639 | - | 1.042 | 6.687 | 12.37 | 16.35 | 18.03 |
| Change | - | -153.49% | - | - | 541.79% | 85.06% | 32.15% | 10.25% |
| EPS 1 | 11.94 | 15.53 | 16.69 | 15.11 | 14.91 | 14.07 | 14.72 | 16.02 |
| Change | - | 30.07% | 7.47% | -9.47% | -1.32% | -5.6% | 4.57% | 8.87% |
| 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 | - | - | - |
| 2026 * | 2027 * | |
|---|---|---|
| P/E ratio | 27x | 25.8x |
| PBR | 30.7x | 23.2x |
| EV / Sales | 2.63x | 2.5x |
| Yield | 2.42% | 2.52% |
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: Global 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), Global 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 performed. We recommend that you carefully review the associated descriptions.
Quality
This composite rating is the result of an average of the rankings based on the following ratings: Capital Efficiency (Composite), 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 review the associated descriptions.
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
MarketScreener is also available in this country: United States.
Switch edition