HOME DEPOT INC (HDI.DE) Fundamental Analysis & Valuation

FRA:HDI • US4370761029

Current stock price

284.6 EUR
-2.8 (-0.97%)
Last:

This HDI.DE fundamental analysis includes valuation metrics, fair value assessment, financial health analysis, profitability trends, growth metrics and dividend sustainability analysis.

8

1. HDI.DE Profitability Analysis

1.1 Basic Checks

  • In the past year HDI was profitable.
  • HDI had a positive operating cash flow in the past year.
  • In the past 5 years HDI has always been profitable.
  • Each year in the past 5 years HDI had a positive operating cash flow.
HDI.DE Yearly Net Income VS EBIT VS OCF VS FCFHDI.DE Yearly Net Income VS EBIT VS OCF VS FCFYearly Net Income VS EBIT VS OCF VS FCF 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 5B 10B 15B 20B

1.2 Ratios

  • With an excellent Return On Assets value of 13.47%, HDI belongs to the best of the industry, outperforming 94.44% of the companies in the same industry.
  • The Return On Equity of HDI (110.48%) is better than 98.15% of its industry peers.
  • With an excellent Return On Invested Capital value of 20.64%, HDI belongs to the best of the industry, outperforming 96.30% of the companies in the same industry.
  • HDI had an Average Return On Invested Capital over the past 3 years of 25.05%. This is significantly above the industry average of 8.87%.
  • The last Return On Invested Capital (20.64%) for HDI is well below the 3 year average (25.05%), which needs to be investigated, but indicates that HDI had better years and this may not be a problem.
Industry RankSector Rank
ROA 13.47%
ROE 110.48%
ROIC 20.64%
ROA(3y)16.22%
ROA(5y)18.78%
ROE(3y)594.65%
ROE(5y)N/A
ROIC(3y)25.05%
ROIC(5y)29.93%
HDI.DE Yearly ROA, ROE, ROICHDI.DE Yearly ROA, ROE, ROICYearly ROA, ROE, ROIC 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 0 500 -500 1K

1.3 Margins

  • Looking at the Profit Margin, with a value of 8.60%, HDI belongs to the top of the industry, outperforming 92.59% of the companies in the same industry.
  • HDI's Profit Margin has declined in the last couple of years.
  • HDI has a better Operating Margin (12.68%) than 98.15% of its industry peers.
  • HDI's Operating Margin has declined in the last couple of years.
  • HDI has a Gross Margin (33.32%) which is in line with its industry peers.
  • HDI's Gross Margin has been stable in the last couple of years.
Industry RankSector Rank
OM 12.68%
PM (TTM) 8.6%
GM 33.32%
OM growth 3Y-6%
OM growth 5Y-3.74%
PM growth 3Y-7.52%
PM growth 5Y-2.47%
GM growth 3Y-0.21%
GM growth 5Y-0.38%
HDI.DE Yearly Profit, Operating, Gross MarginsHDI.DE Yearly Profit, Operating, Gross MarginsYearly Profit, Operating, Gross Margins 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 10 20 30

3

2. HDI.DE Health Analysis

2.1 Basic Checks

  • With a Return on Invested Capital (ROIC) well above the Cost of Capital (WACC), HDI is creating value.
  • The number of shares outstanding for HDI remains at a similar level compared to 1 year ago.
  • Compared to 5 years ago, HDI has less shares outstanding
  • Compared to 1 year ago, HDI has an improved debt to assets ratio.
HDI.DE Yearly Shares OutstandingHDI.DE Yearly Shares OutstandingYearly Shares Outstanding 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 200M 400M 600M 800M 1B
HDI.DE Yearly Total Debt VS Total AssetsHDI.DE Yearly Total Debt VS Total AssetsYearly Total Debt VS Total Assets 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 20B 40B 60B 80B 100B

2.2 Solvency

  • HDI has a debt to FCF ratio of 4.41. This is a neutral value as HDI would need 4.41 years to pay back of all of its debts.
  • With a decent Debt to FCF ratio value of 4.41, HDI is doing good in the industry, outperforming 64.81% of the companies in the same industry.
  • HDI has a Debt/Equity ratio of 3.97. This is a high value indicating a heavy dependency on external financing.
  • HDI's Debt to Equity ratio of 3.97 is on the low side compared to the rest of the industry. HDI is outperformed by 87.04% of its industry peers.
Industry RankSector Rank
Debt/Equity 3.97
Debt/FCF 4.41
Altman-Z N/A
ROIC/WACC2.55
WACC8.1%
HDI.DE Yearly LT Debt VS Equity VS FCFHDI.DE Yearly LT Debt VS Equity VS FCFYearly LT Debt VS Equity VS FCF 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 0 10B 20B 30B 40B

2.3 Liquidity

  • A Current Ratio of 1.06 indicates that HDI should not have too much problems paying its short term obligations.
  • The Current ratio of HDI (1.06) is worse than 62.96% of its industry peers.
  • HDI has a Quick Ratio of 1.06. This is a bad value and indicates that HDI is not financially healthy enough and could expect problems in meeting its short term obligations.
  • Looking at the Quick ratio, with a value of 0.26, HDI is doing worse than 81.48% of the companies in the same industry.
Industry RankSector Rank
Current Ratio 1.06
Quick Ratio 0.26
HDI.DE Yearly Current Assets VS Current LiabilitesHDI.DE Yearly Current Assets VS Current LiabilitesYearly Current Assets VS Current Liabilites 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 10B 20B 30B

4

3. HDI.DE Growth Analysis

3.1 Past

  • HDI shows a slight negative growth in Earnings Per Share. In the last year, the EPS has decreased by -1.47%.
  • Measured over the past 5 years, HDI shows a small growth in Earnings Per Share. The EPS has been growing by 4.26% on average per year.
  • HDI shows a small growth in Revenue. In the last year, the Revenue has grown by 3.24%.
  • HDI shows a small growth in Revenue. Measured over the last years, the Revenue has been growing by 4.51% yearly.
EPS 1Y (TTM)-1.47%
EPS 3Y-4.12%
EPS 5Y4.26%
EPS Q2Q%-9.93%
Revenue 1Y (TTM)3.24%
Revenue growth 3Y1.52%
Revenue growth 5Y4.51%
Sales Q2Q%-3.79%

3.2 Future

  • The Earnings Per Share is expected to grow by 7.18% on average over the next years.
  • The Revenue is expected to grow by 3.81% on average over the next years.
EPS Next Y5.55%
EPS Next 2Y6.91%
EPS Next 3Y7.68%
EPS Next 5Y7.18%
Revenue Next Year3.95%
Revenue Next 2Y4.02%
Revenue Next 3Y4.17%
Revenue Next 5Y3.81%

3.3 Evolution

  • The EPS growth rate is accelerating: in the next years the growth will be better than in the last years.
  • The Revenue growth rate is stable: in the next years the growth will be about the same than in the last years.
HDI.DE Yearly Revenue VS EstimatesHDI.DE Yearly Revenue VS EstimatesYearly Revenue VS Estimates 2015 2017 2019 2021 2023 2025 2027 2029 2031 2033 50B 100B 150B 200B
HDI.DE Yearly EPS VS EstimatesHDI.DE Yearly EPS VS EstimatesYearly EPS VS Estimates 2015 2017 2019 2021 2023 2025 2027 2029 2031 2033 5 10 15 20 25

3

4. HDI.DE Valuation Analysis

4.1 Price/Earnings Ratio

  • HDI is valuated rather expensively with a Price/Earnings ratio of 22.66.
  • HDI's Price/Earnings ratio is a bit cheaper when compared to the industry. HDI is cheaper than 62.96% of the companies in the same industry.
  • Compared to an average S&P500 Price/Earnings ratio of 26.91, HDI is valued at the same level.
  • HDI is valuated rather expensively with a Price/Forward Earnings ratio of 21.47.
  • The rest of the industry has a similar Price/Forward Earnings ratio as HDI.
  • Compared to an average S&P500 Price/Forward Earnings ratio of 23.68, HDI is valued at the same level.
Industry RankSector Rank
PE 22.66
Fwd PE 21.47
HDI.DE Price Earnings VS Forward Price EarningsHDI.DE Price Earnings VS Forward Price Earnings ChartPrice Earnings - Forward Price Earnings PE FPE 5 10 15 20 25

4.2 Price Multiples

  • Based on the Enterprise Value to EBITDA ratio, HDI is valued a bit more expensive than the industry average as 62.96% of the companies are valued more cheaply.
  • HDI's Price/Free Cash Flow ratio is in line with the industry average.
Industry RankSector Rank
P/FCF 26.23
EV/EBITDA 15.39
HDI.DE Per share dataHDI.DE EPS, Sales, OCF, FCF, BookValue per sharePer Share Data Per Share 0 50 100

4.3 Compensation for Growth

  • The high PEG Ratio(NY), which compensates the Price/Earnings for growth, indicates an expensive valuation of the company.
  • HDI has an outstanding profitability rating, which may justify a higher PE ratio.
PEG (NY)4.08
PEG (5Y)5.31
EPS Next 2Y6.91%
EPS Next 3Y7.68%

5

5. HDI.DE Dividend Analysis

5.1 Amount

  • HDI has a Yearly Dividend Yield of 2.90%.
  • HDI's Dividend Yield is a higher than the industry average which is at 1.41.
  • HDI's Dividend Yield is rather good when compared to the S&P500 average which is at 1.89.
Industry RankSector Rank
Dividend Yield 2.9%

5.2 History

  • On average, the dividend of HDI grows each year by 8.96%, which is quite nice.
Dividend Growth(5Y)8.96%
Div Incr Years7
Div Non Decr Years7
HDI.DE Yearly Dividends per shareHDI.DE Yearly Dividends per shareYearly Dividends per share 2018 2019 2020 2021 2022 2023 2024 2025 2026 2 4 6 8

5.3 Sustainability

  • 64.65% of the earnings are spent on dividend by HDI. This is not a sustainable payout ratio.
  • The dividend of HDI is growing, but the earnings are growing slower. This means the dividend growth is not sustainable.
DP64.65%
EPS Next 2Y6.91%
EPS Next 3Y7.68%
HDI.DE Yearly Income VS Free CF VS DividendHDI.DE Yearly Income VS Free CF VS DividendYearly Income VS Free CF VS Dividend 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 5B 10B 15B
HDI.DE Dividend Payout.HDI.DE Dividend Payout, showing the Payout Ratio.HDI.DE Dividend Payout.PayoutRetained Earnings

HDI.DE Fundamentals: All Metrics, Ratios and Statistics

HOME DEPOT INC

FRA:HDI (4/9/2026, 3:47:09 PM)

284.6

-2.8 (-0.97%)

Chartmill FA Rating
GICS IndustryGroupConsumer Discretionary Distribution & Retail
GICS IndustrySpecialty Retail
Earnings (Last)02-24
Earnings (Next)05-18
Inst Owners74.44%
Inst Owner ChangeN/A
Ins Owners0.04%
Ins Owner ChangeN/A
Market Cap283.32B
Revenue(TTM)164.68B
Net Income(TTM)14.16B
Analysts76.09
Price Target342.85 (20.47%)
Short Float %N/A
Short RatioN/A
Dividend
Industry RankSector Rank
Dividend Yield 2.9%
Yearly Dividend7.98
Dividend Growth(5Y)8.96%
DP64.65%
Div Incr Years7
Div Non Decr Years7
Ex-DateN/A
Surprises & Revisions
EPS beat(2)1
Avg EPS beat(2)-0.72%
Min EPS beat(2)-5.4%
Max EPS beat(2)3.96%
EPS beat(4)1
Avg EPS beat(4)-2.22%
Min EPS beat(4)-5.4%
Max EPS beat(4)3.96%
EPS beat(8)1
Avg EPS beat(8)-2.03%
EPS beat(12)2
Avg EPS beat(12)-1.64%
EPS beat(16)3
Avg EPS beat(16)-0.92%
Revenue beat(2)0
Avg Revenue beat(2)-2.52%
Min Revenue beat(2)-2.71%
Max Revenue beat(2)-2.32%
Revenue beat(4)0
Avg Revenue beat(4)-2.42%
Min Revenue beat(4)-3.08%
Max Revenue beat(4)-1.56%
Revenue beat(8)0
Avg Revenue beat(8)-2.27%
Revenue beat(12)0
Avg Revenue beat(12)-2.51%
Revenue beat(16)1
Avg Revenue beat(16)-2.07%
PT rev (1m)0%
PT rev (3m)-1.84%
EPS NQ rev (1m)0%
EPS NQ rev (3m)-5.96%
EPS NY rev (1m)0%
EPS NY rev (3m)0.01%
Revenue NQ rev (1m)0%
Revenue NQ rev (3m)-0.31%
Revenue NY rev (1m)0%
Revenue NY rev (3m)-0.01%
Valuation
Industry RankSector Rank
PE 22.66
Fwd PE 21.47
P/S 2.01
P/FCF 26.23
P/OCF 20.32
P/B 25.88
P/tB N/A
EV/EBITDA 15.39
EPS(TTM)12.56
EY4.41%
EPS(NY)13.26
Fwd EY4.66%
FCF(TTM)10.85
FCFY3.81%
OCF(TTM)14.01
OCFY4.92%
SpS141.32
BVpS11
TBVpS-17.04
PEG (NY)4.08
PEG (5Y)5.31
Graham Number55.74
Profitability
Industry RankSector Rank
ROA 13.47%
ROE 110.48%
ROCE 28.75%
ROIC 20.64%
ROICexc 21.01%
ROICexgc 36.96%
OM 12.68%
PM (TTM) 8.6%
GM 33.32%
FCFM 7.68%
ROA(3y)16.22%
ROA(5y)18.78%
ROE(3y)594.65%
ROE(5y)N/A
ROIC(3y)25.05%
ROIC(5y)29.93%
ROICexc(3y)26.13%
ROICexc(5y)31.4%
ROICexgc(3y)41.07%
ROICexgc(5y)45.33%
ROCE(3y)33.48%
ROCE(5y)39.89%
ROICexgc growth 3Y-7.04%
ROICexgc growth 5Y-4.98%
ROICexc growth 3Y-16.59%
ROICexc growth 5Y-11.68%
OM growth 3Y-6%
OM growth 5Y-3.74%
PM growth 3Y-7.52%
PM growth 5Y-2.47%
GM growth 3Y-0.21%
GM growth 5Y-0.38%
F-Score4
Asset Turnover1.57
Health
Industry RankSector Rank
Debt/Equity 3.97
Debt/FCF 4.41
Debt/EBITDA 2.03
Cap/Depr 89.27%
Cap/Sales 2.23%
Interest Coverage 250
Cash Conversion 65.27%
Profit Quality 89.33%
Current Ratio 1.06
Quick Ratio 0.26
Altman-Z N/A
F-Score4
WACC8.1%
ROIC/WACC2.55
Cap/Depr(3y)93.76%
Cap/Depr(5y)95.16%
Cap/Sales(3y)2.18%
Cap/Sales(5y)2.04%
Profit Quality(3y)106.03%
Profit Quality(5y)94.11%
High Growth Momentum
Growth
EPS 1Y (TTM)-1.47%
EPS 3Y-4.12%
EPS 5Y4.26%
EPS Q2Q%-9.93%
EPS Next Y5.55%
EPS Next 2Y6.91%
EPS Next 3Y7.68%
EPS Next 5Y7.18%
Revenue 1Y (TTM)3.24%
Revenue growth 3Y1.52%
Revenue growth 5Y4.51%
Sales Q2Q%-3.79%
Revenue Next Year3.95%
Revenue Next 2Y4.02%
Revenue Next 3Y4.17%
Revenue Next 5Y3.81%
EBIT growth 1Y-2.95%
EBIT growth 3Y-4.57%
EBIT growth 5Y0.6%
EBIT Next Year19.6%
EBIT Next 3Y10.35%
EBIT Next 5Y7.64%
FCF growth 1Y-22.54%
FCF growth 3Y3.23%
FCF growth 5Y-5.04%
OCF growth 1Y-17.59%
OCF growth 3Y3.76%
OCF growth 5Y-2.82%

HOME DEPOT INC / HDI.DE Fundamental Analysis FAQ

Can you provide the ChartMill fundamental rating for HOME DEPOT INC?

ChartMill assigns a fundamental rating of 5 / 10 to HDI.DE.


Can you provide the valuation status for HOME DEPOT INC?

ChartMill assigns a valuation rating of 3 / 10 to HOME DEPOT INC (HDI.DE). This can be considered as Overvalued.


How profitable is HOME DEPOT INC (HDI.DE) stock?

HOME DEPOT INC (HDI.DE) has a profitability rating of 8 / 10.


What is the valuation of HOME DEPOT INC based on its PE and PB ratios?

The Price/Earnings (PE) ratio for HOME DEPOT INC (HDI.DE) is 22.66 and the Price/Book (PB) ratio is 25.88.


How financially healthy is HOME DEPOT INC?

The financial health rating of HOME DEPOT INC (HDI.DE) is 3 / 10.