Video 1: Downloading Data
Follow this link to choose your company.
Video 2: Creating the Model
These links are needed to complete the assignment, I will have the rest of the instructions needed below the attahmenta are needed to
complete the assignment
This week, your topic is Excel. In particular, you will be learning how to calculate the following in Excel:
1. Beta
2. HPR
3. CAPM return
4. alpha (HPR-CAPM return)
You will choose your company from the list found by following the link in STEP 1.
In doing so, you will also learn the following skills:
1. Downloading historical stock data from finance.yahoo.com into Excel
2. Writing and IF function
3. Creating a data table
4. Using Goal Seek
Here is what you need to do:
Steps
Open the attached template, then rename it using your last name.
Watch these two videos and follow along to create your models in the template.
