The Home Depot, Inc.

LSE:0R1G Stock Report

Market Cap: US$390.0b

Home Depot Valuation

Is 0R1G undervalued compared to its fair value, analyst forecasts and its price relative to the market?

Valuation Score

2/6

Valuation Score 2/6

  • Below Fair Value

  • Significantly Below Fair Value

  • Price-To-Earnings vs Peers

  • Price-To-Earnings vs Industry

  • Price-To-Earnings vs Fair Ratio

  • Analyst Forecast

Share Price vs Fair Value

What is the Fair Price of 0R1G when looking at its future cash flows? For this estimate we use a Discounted Cash Flow model.

Below Fair Value: 0R1G ($178.57) is trading below our estimate of fair value ($201.17)

Significantly Below Fair Value: 0R1G is trading below fair value, but not by a significant amount.

Key Valuation Metric

Which metric is best to use when looking at relative valuation for 0R1G?

Key metric: As 0R1G is profitable we use its Price-To-Earnings Ratio for relative valuation analysis.

The above table shows the Price to Earnings ratio for 0R1G. This is calculated by dividing 0R1G's market cap by their current earnings.
What is 0R1G's PE Ratio?
PE Ratio26.7x
EarningsUS$14.61b
Market CapUS$389.99b

Price to Earnings Ratio vs Peers

How does 0R1G's PE Ratio compare to its peers?

The above table shows the PE ratio for 0R1G vs its peers. Here we also display the market cap and forecasted growth for additional consideration.
CompanyForward PEEstimated GrowthMarket Cap
Peer Average17.9x
KGF Kingfisher
13.1x9.5%UK£4.5b
WIX Wickes Group
12.1x12.0%UK£371.3m
VIC Victorian Plumbing Group
25.9x26.8%UK£313.3m
LOW Lowe's Companies
20.5x5.9%US$139.9b
0R1G Home Depot
26.7x6.9%US$390.0b

Price-To-Earnings vs Peers: 0R1G is expensive based on its Price-To-Earnings Ratio (26.7x) compared to the peer average (17.9x).

Price to Earnings Ratio vs Industry

How does 0R1G's PE Ratio compare vs other companies in the GB Specialty Retail Industry?

1 CompanyPrice / EarningsEstimated GrowthMarket Cap
WRKS TheWorks.co.uk
1.9xn/aUS$15.31m
No more companies available in this PE range
0R1G 26.7xIndustry Avg. 14.2xNo. of Companies4PE01020304050+
1 CompanyEstimated GrowthMarket Cap
No more companies

Price-To-Earnings vs Industry: 0R1G is expensive based on its Price-To-Earnings Ratio (26.7x) compared to the UK Specialty Retail industry average (14.2x).

Price to Earnings Ratio vs Fair Ratio

What is 0R1G's PE Ratio compared to its Fair PE Ratio? This is the expected PE Ratio taking into account the company's forecast earnings growth, profit margins and other risk factors.

0R1G PE Ratio vs Fair Ratio.
Fair Ratio
Current PE Ratio26.7x
Fair PE Ratio83.3x

Price-To-Earnings vs Fair Ratio: 0R1G is good value based on its Price-To-Earnings Ratio (26.7x) compared to the estimated Fair Price-To-Earnings Ratio (83.3x).

Analyst Price Targets

What is the analyst 12-month forecast and do we have any statistical confidence in the consensus price target?

The above table shows the analyst 0R1G forecast and predictions for the stock price in 12 month’s time.
DateShare PriceAverage 1Y Price TargetDispersionHighLow1Y Actual priceAnalysts
CurrentUS$178.57
US$431.41
+141.6%
10.5%US$500.00US$292.00n/a35
Dec ’25US$178.57
US$428.58
+140.0%
10.3%US$475.00US$292.00n/a35
Nov ’25US$178.57
US$403.32
+125.9%
11.7%US$466.00US$282.00n/a35
Oct ’25US$178.57
US$387.74
+117.1%
9.9%US$455.00US$282.00n/a34
Sep ’25US$178.57
US$379.56
+112.6%
9.4%US$433.00US$282.00n/a33
Aug ’25US$178.57
US$382.83
+114.4%
8.6%US$426.00US$270.00n/a32
Jul ’25US$178.57
US$381.20
+113.5%
8.7%US$425.00US$265.00n/a31
Jun ’25US$178.57
US$380.76
+113.2%
8.7%US$425.00US$265.00n/a32
May ’25US$178.57
US$384.83
+115.5%
9.4%US$440.00US$263.00n/a33
Apr ’25US$178.57
US$383.77
+114.9%
9.5%US$440.00US$263.00n/a33
Mar ’25US$178.57
US$375.53
+110.3%
9.6%US$415.00US$263.00n/a33
Feb ’25US$178.57
US$350.08
+96.0%
10.5%US$415.00US$263.00n/a32
Jan ’25US$178.57
US$336.51
+88.4%
8.0%US$390.00US$263.00n/a33
Dec ’24US$178.57
US$330.50
+85.1%
6.7%US$375.00US$263.00US$178.5733
Nov ’24US$178.57
US$343.27
+92.2%
7.5%US$384.00US$263.00US$178.5732
Oct ’24US$178.57
US$347.86
+94.8%
7.2%US$384.00US$263.00US$178.5732
Sep ’24US$178.57
US$346.02
+93.8%
7.5%US$384.00US$263.00US$178.5731
Aug ’24US$178.57
US$320.86
+79.7%
8.5%US$370.00US$259.00US$178.5732
Jul ’24US$178.57
US$317.73
+77.9%
7.8%US$360.00US$259.00US$178.5732
Jun ’24US$178.57
US$313.94
+75.8%
7.6%US$360.00US$259.00US$178.5732
May ’24US$178.57
US$328.87
+84.2%
8.5%US$400.00US$264.00US$178.5731
Apr ’24US$178.57
US$330.43
+85.0%
8.7%US$400.00US$264.00US$178.5730
Mar ’24US$178.57
US$329.87
+84.7%
8.6%US$400.00US$264.00US$178.5731
Feb ’24US$178.57
US$345.33
+93.4%
11.5%US$470.00US$258.00US$178.5730
Jan ’24US$178.57
US$344.43
+92.9%
11.5%US$470.00US$258.00US$178.5730
Dec ’23US$178.57
US$346.63
+94.1%
11.6%US$470.00US$258.00US$178.5730

Analyst Forecast: Target price is less than 20% higher than the current share price.

Discover undervalued companies

7D

1Y

7D

1Y

7D

1Y

Company Analysis and Financial Data Status

DataLast Updated (UTC time)
Company Analysis2024/12/22 16:53
End of Day Share Price 2024/12/20 00:00
Earnings2024/10/27
Annual Earnings2024/01/28

Data Sources

The data used in our company analysis is from S&P Global Market Intelligence LLC. The following data is used in our analysis model to generate this report. Data is normalised which can introduce a delay from the source being available.

PackageDataTimeframeExample US Source *
Company Financials10 years
  • Income statement
  • Cash flow statement
  • Balance sheet
Analyst Consensus Estimates+3 years
  • Forecast financials
  • Analyst price targets
Market Prices30 years
  • Stock prices
  • Dividends, Splits and Actions
Ownership10 years
  • Top shareholders
  • Insider trading
Management10 years
  • Leadership team
  • Board of directors
Key Developments10 years
  • Company announcements

* example for US securities, for non-US equivalent regulatory forms and sources are used.

Unless specified all financial data is based on a yearly period but updated quarterly. This is known as Trailing Twelve Month (TTM) or Last Twelve Month (LTM) Data. Learn more here.

Analysis Model and Snowflake

Details of the analysis model used to generate this report is available on our Github page, we also have guides on how to use our reports and tutorials on Youtube.

Learn about the world class team who designed and built the Simply Wall St analysis model.

Industry and Sector Metrics

Our industry and section metrics are calculated every 6 hours by Simply Wall St, details of our process are available on .

Analyst Sources

The Home Depot, Inc. is covered by 76 analysts. 37 of those analysts submitted the estimates of revenue or earnings used as inputs to our report. Analysts submissions are updated throughout the day.

AnalystInstitution
Christopher GrajaArgus Research Company
Peter BenedictBaird
Ishan MajumdarBaptista Research