Intro text

Conclusions:

On Page 1, based on the first chart, we can tell that the Costco and Home Depot have the increasing tendency during the date range (2021.1-2022.10) while Amazon and Walmart have the decreasing tendency.

In the second chart, we calculate the Compound Annual Grow Rate, which has similarity to what the tendency shows in the first chart. Home Depot has the highest compound annual growth rate: 42%, Costco has the second highest compound growth rate: 38%. On the other hand, Walmart (-38%) and Amazon (-28%) have negative growth rate.

In the third chart, we calculate the Price-To-Earning Ratio and Price EPS Estimate Next Year. By using P/E and Price EPS Estimate Next Year, we can tell if the stock is devalued or over-priced. The lower these two metrics are, the higher likely we can make profits from choosing the corresponding stock. We can see that Home Depot has the lowest P/E Ratio which means that the price of Home Depot Stock is devalued and might be profitable for us to invest for this year.

On page two, we focused on Home Depot and analyzed P/E ratio variance with time range (Q1,Q2,Q3,Q4 2021 and Q1, Q2 2022). We selected Quarterly Earning Report and calculated the P/E ratio according to value by quarter. We find that Q2 has the lowest P/E ratio which shows us Q2 might be the best time to invest.

In summary, Home Deport is the most profitable stock we can choose among conglomerate retail sellers by comparing Amazon, Walmart, Costco and the best time to invest is quarter two.