Home Depot Inc Stock Analysis

In this article I will analyze Home Depot Stock based in its earning per Share (EPS) and its Price/Earning (P/E) ratio.

First, we need to see how was HD’s EPS doing in the last six years. By browsing HD’s EPS for the last years , I found that HD’s EPS increased form 7.2$ in year 2017 until it reached to 16.6$ in 2022, with compound growth rate is 18.18%, as shown below:

Now we will estimate HD’s (EPS) in year 2027 to see how much will it be by applying the following equation:


  • Where PV = HD’s EPS in year 2022 = 16.6$
  • i = growth rate of HD’s EPS estimated above = 18.18%
  • n = years of investment = 5 years in 2027

By plug in the data that we mentioned above in the formula, we end up with projected EPS for Home Depot in 2027 which will be 38.27$.

Second, that we have HD projected EPS for year 2027 which is 38.27$, all what we have to do is to find the lowest (P/E) ratio for Home Depot in the last six years, and as we said in the previous analysis we are looking for the lowest (P/E) ratio because we are conservative investors.

The lowest (P/E) ratio for HD for the last six years was 17.14 which was in year 2019.

Finally, all what we have to do is to multiply the (P/E) ratio that mentioned above to the projected Home Depot’s EPS for year 2027 to find the price of HD’s stock in year 2027 which is as following:

Home Depot’s Stock Price In 2027 = (38.27)*(17.14)= 655.95$

Home Depot has a tremendous EPS growth rate, and it never recorded a negative EPS even during the COVID-19 Crisis, so it is fair to say that the projected stock price in year 2027 that estimated using the forecasted HD’s EPS in year 2027 is reliable.

In conclusion, if someone invest 10,000 $ and bough HD stock in today price which is as of writing this article is 326.68$ , she will make 20,079.3$ in year 2027, which means that she double her money in five years.

Leave a Reply

About Me

Helps companies and individual make the most of their finances. Provide them guidance and advice on how much they should invest in stocks or bonds. In addition, I assess which investments could bring the optimal return for their worth.


%d bloggers like this: