Assignment: Equity Valuation
In this homework, you will use discounted dividend growth model and discounted free cash flow model to estimate the equity value of the company you/your team selected.
This will be a primary element of the quantitative analysis in your final project.
Recommended Steps:
o Download monthly prices of the past 5 years from Yahoo Finance
o Use Regression (A) in Excel and determine beta and the cost of equity
o Download related financial variables from Bloomberg, as specified in "Data
Download(B)" worksheet, calculate WACC
o Copy and paste related variable into the equity valuation model: worksheet C and worksheet D, and derive your projected equity price from both models.
o Submit the entire Excel file (including worksheet A, B, C, D)through Blackboard.
Attachment:- Worksheet.rar