Business Finance
FIN 460 UW Financial Modeling Stock Valuation of Home Depot Inc Essay

FIN 460

University of Washington


Question Description

I’m studying and need help with a Economics question to help me learn.

All the requirements are in the file, please meet all the requirements and deliver on time with good quality.

Unformatted Attachment Preview

Home Depot (HD) Homework – Financial Modeling - Stock Valuation Determine the intrinsic value per share for Home Depot at the end of the fiscal year using a “two-stage” model (use the following information to construct the model): 1. Assume D0 is current annual dividend per share listed in Bloomberg or from a different free source form the web. 2. Assume that in “first stage” (lasting 5 years), HD’s dividend per share grows by the “Next 5 years” growth estimate . (Be prepared to justify how would you choose this growth rate.....) 3. Assume that HD’s dividend per share is expected to grow by x% per year = Mean Growth rate forever AFTER the five-year “first stage” growth is completed. 4. Calculate HD’s cost of equity. Compare it to the cost of equity from Bloomberg or from a different provider you found online. Attach the report you used. Show formulas, calculations and interpretation. Have a nice table with your assumptions (CAGR using historical growth rates, independent analysts' estimates, management guidance, most recent growth rate etc- like we did in class). Submit it in electronic format attaching screenshots from Bloomberg screens or from a stick research report where you got the data from. 1. Build a table and a chart with the main operating segments for the most recent past year with the following columns: Revenues, % of each segment in Total Revenues, Operating Income, % of each segment in Total Operating Income 2. Build a graph with the dividend annual growth rates since 2005 to the present.Add the EPS growth rates to the same chart for the same period of time. 3. What is Home Depot's stock intrinsic value using the Gordon constant growth model? 4. What is Home Depot's stock intrinsic value using a 2 stage growth model? How accurately does the model above value a share of HD stock? 5. What was the closing price at the end of the trade day on March 13, 2020? 6. What was the closing price at the end of the fiscal year? Attach a chart with daily stock price performance for the past 12 months. On the same chart add the quarterly EPS. 7. What are the possible problems with the models? Please comment on the strengths and weaknesses of each valuation approach. 8. Did you encounter any difficulties or challenges? 9. Take screenshots of the data you used and attach them next to your calculations. 10. Would you buy/sell/hold this stock? Why? Why not? Do you trust your results? Why ? Why not? ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

please find the attached file. let me know if you need adjustments. i look forward to working with you again. good bye


Financial Modeling – Stock Valuation of Home Depot Inc.




Financial Modeling – Home Depot Inc. Stock Valuation


Based in the United States of America, Home Depot deals with home improvement and
its revenue for the year ended 31st December 2019 was above $80 billion. The firm operates to
provide global home improvement retail services and it has diversified its products and stores to
provide lawn products, garden products, and building materials through e-commerce. The stores
are spread over three countries (U.S.A., Mexico and Canada). Out of the three countries, the US
market has over 50% of the total market share.

According to Picarra (2015), the company has thrived in the macroeconomic environment
by remodeling its strategy to include online stores with a major focus on customer service and a
disciplined capital allocation. Due to the improved strategic perspectives, it has gained growth
and exhibited a great ability to handle the industry challenges, thereby emerging the top player in
the market. The stock price of Home Depot has continu...

chemtai (23904)
Boston College

Thanks for the help.

Outstanding. Studypool always delivers quality work.

Tutor was very helpful and took the time to explain concepts to me. Very responsive, managed to get replies within the hour.