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

FRA:HDI • US4370761029

Current stock price

279.55 EUR
-3.85 (-1.36%)
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

  • HDI had positive earnings in the past year.
  • HDI had a positive operating cash flow in the past year.
  • In the past 5 years HDI has always been profitable.
  • HDI had a positive operating cash flow in each of the past 5 years.
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

  • Looking at the Return On Assets, with a value of 13.47%, HDI belongs to the top of the industry, outperforming 92.98% of the companies in the same industry.
  • HDI's Return On Equity of 110.48% is amongst the best of the industry. HDI outperforms 98.25% of its industry peers.
  • The Return On Invested Capital of HDI (20.64%) is better than 92.98% of its industry peers.
  • The Average Return On Invested Capital over the past 3 years for HDI is significantly above the industry average of 10.14%.
  • The 3 year average ROIC (25.05%) for HDI is well above the current ROIC(20.64%). The reason for the recent decline needs to be investigated.
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

  • HDI has a better Profit Margin (8.60%) than 89.47% of its industry peers.
  • In the last couple of years the Profit Margin of HDI has declined.
  • HDI has a better Operating Margin (12.68%) than 94.74% of its industry peers.
  • HDI's Operating Margin has declined in the last couple of years.
  • Looking at the Gross Margin, with a value of 33.32%, HDI is in line with its industry, outperforming 47.37% of the companies in the same industry.
  • In the last couple of years the Gross Margin of HDI has remained more or less at the same level.
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.
  • Compared to 1 year ago, HDI has about the same amount of shares outstanding.
  • The number of shares outstanding for HDI has been reduced compared to 5 years ago.
  • HDI has a better debt/assets ratio than last year.
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.
  • HDI's Debt to FCF ratio of 4.41 is fine compared to the rest of the industry. HDI outperforms 64.91% of its industry peers.
  • A Debt/Equity ratio of 3.97 is on the high side and indicates that HDI has dependencies on debt financing.
  • The Debt to Equity ratio of HDI (3.97) is worse than 85.96% of its industry peers.
Industry RankSector Rank
Debt/Equity 3.97
Debt/FCF 4.41
Altman-Z N/A
ROIC/WACC2.15
WACC9.62%
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.
  • With a Current ratio value of 1.06, HDI is not doing good in the industry: 64.91% of the companies in the same industry are doing better.
  • A Quick Ratio of 0.26 indicates that HDI may have some problems paying its short term obligations.
  • HDI's Quick ratio of 0.26 is on the low side compared to the rest of the industry. HDI is outperformed by 82.46% of its industry peers.
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

  • The earnings per share for HDI have decreased by -1.47% in the last year.
  • 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%.
  • The Revenue has been growing slightly by 4.51% on average over the past years.
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

  • Based on estimates for the next years, HDI will show a small growth in Earnings Per Share. The EPS will grow by 7.18% on average per year.
  • Based on estimates for the next years, HDI will show a small growth in Revenue. The Revenue will grow by 3.81% on average per year.
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

  • When comparing the EPS growth rate of the last years to the growth rate of the upcoming years, we see that the growth is accelerating.
  • 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 21.98.
  • Based on the Price/Earnings ratio, HDI is valued a bit cheaper than the industry average as 64.91% of the companies are valued more expensively.
  • HDI is valuated at similar levels of the S&P average when we compare the Price/Earnings ratio to 25.23, which is the current average of the S&P500 Index.
  • HDI is valuated rather expensively with a Price/Forward Earnings ratio of 20.82.
  • HDI's Price/Forward Earnings is on the same level as the industry average.
  • HDI is valuated at similar levels of the S&P average when we compare the Price/Forward Earnings ratio to 23.28, which is the current average of the S&P500 Index.
Industry RankSector Rank
PE 21.98
Fwd PE 20.82
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 61.40% of the companies are valued more cheaply.
  • Compared to the rest of the industry, the Price/Free Cash Flow ratio of HDI is on the same level as its industry peers.
Industry RankSector Rank
P/FCF 25.43
EV/EBITDA 14.85
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.
  • The excellent profitability rating of HDI may justify a higher PE ratio.
PEG (NY)3.96
PEG (5Y)5.15
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.84%.
  • HDI's Dividend Yield is a higher than the industry average which is at 1.46.
  • Compared to an average S&P500 Dividend Yield of 1.89, HDI pays a better dividend.
Industry RankSector Rank
Dividend Yield 2.84%

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 Years6
Div Non Decr Years6
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 (3/20/2026, 7:00:00 PM)

279.55

-3.85 (-1.36%)

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 Cap278.29B
Revenue(TTM)164.68B
Net Income(TTM)14.16B
Analysts75.65
Price Target342.85 (22.64%)
Short Float %N/A
Short RatioN/A
Dividend
Industry RankSector Rank
Dividend Yield 2.84%
Yearly Dividend7.96
Dividend Growth(5Y)8.96%
DP64.65%
Div Incr Years6
Div Non Decr Years6
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)1.45%
PT rev (3m)-2.7%
EPS NQ rev (1m)-5.96%
EPS NQ rev (3m)-6.09%
EPS NY rev (1m)-0.1%
EPS NY rev (3m)-1.81%
Revenue NQ rev (1m)-0.31%
Revenue NQ rev (3m)-0.36%
Revenue NY rev (1m)-0.02%
Revenue NY rev (3m)-0.43%
Valuation
Industry RankSector Rank
PE 21.98
Fwd PE 20.82
P/S 1.95
P/FCF 25.43
P/OCF 19.7
P/B 25.1
P/tB N/A
EV/EBITDA 14.85
EPS(TTM)12.72
EY4.55%
EPS(NY)13.43
Fwd EY4.8%
FCF(TTM)10.99
FCFY3.93%
OCF(TTM)14.19
OCFY5.08%
SpS143.16
BVpS11.14
TBVpS-17.26
PEG (NY)3.96
PEG (5Y)5.15
Graham Number56.46
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
WACC9.62%
ROIC/WACC2.15
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.


What is the profitability of HDI stock?

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


What is the expected EPS growth for HOME DEPOT INC (HDI.DE) stock?

The Earnings per Share (EPS) of HOME DEPOT INC (HDI.DE) is expected to grow by 5.55% in the next year.


How sustainable is the dividend of HOME DEPOT INC (HDI.DE) stock?

The dividend rating of HOME DEPOT INC (HDI.DE) is 4 / 10 and the dividend payout ratio is 64.65%.