Financial Analysis Exercise -
Purpose - The purpose of this assignment is to apply stock valuation techniques to real financial data utilizing an online database.
Overview - Throughout this course you will work with the Yahoo! Finance database and perform elements of securities analysis involving a select group of companies.
Action Items
Review the Sherwin-Williams example. (Please see attachment)
Select ONE of the four companies provided by your professor for analysis.
Write a 1-2 page (approximately 500 words) paper on the following:
Part A-Fundamental Valuation:
a. Estimate a growth rate for your firm's Dividends per Share.
b. Assume a 12.5% discount rate.
c. Calculate an estimated value of a share of the stock using the constant-growth model (Eq. 8-6 in the textbook), also known as the Gordon growth model.
d. Compare and contrast your valuation results with the current share price in the market.
e. Respond to this question: What changes in the variables would be necessary in your valuation to best approximate the market valuation?
Part B - Relative Valuation:
a. Estimate a growth rate for your firm's Earnings per Share (EPS).
b. Determine an applicable Price-Earnings (P/E) ratio for your firm in 5 years.
c. Calculate an estimated value of a share of the stock in 5 years using the P/E ratio model (Eq. 8-10 in the textbook).
d. Respond to this question: Would you characterize your stock as undervalued or overvalued? Explain.
e. Respond to this question: Based on your valuations in parts A and B, would you invest in this stock? Explain.
Attachment:- Assignment Files.rar