Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It says to ignore risk free rate. You can charge me for more questions if you need to. Sorry that it is such a long
It says to ignore risk free rate.
You can charge me for more questions if you need to. Sorry that it is such a long question!
In HW 3_Part you will need to download and manage the data from finance.yahoo.com, and use excel to calculate: 1. The time range is Jan 1st, 2018 through Jan 1st, 2019, monthly data; 2. The mean return of Facebook; 3. The variance of FB stock return; 4. The standard deviation of FB stock return; 5. The return per unit of risk (return/SD) of FB stock return. 6. Please calculate the beta of FB. 7. You will need to do the above in excel. You need to follow the format of the Walmart Example posted (two tabs: "Original Data" and "Calculations"). The video shows how to do all the above. Slide 55 on Chapter 6 has the formula of CAPM. So we need to find out the stock return, and the market return (S&P 500) to calculate beta. I am using Walmart as the example. Symbol of S&P 500 is AGSPC. For this HW, we ignore risk free rate. Please also write a memo in word document: 1. Explain the definition of Beta 2. Use the concept of beta to explain how risky FB stock is relative to the S&P500. In HW 3_Part you will need to download and manage the data from finance.yahoo.com, and use excel to calculate: 1. The time range is Jan 1st, 2018 through Jan 1st, 2019, monthly data; 2. The mean return of Facebook; 3. The variance of FB stock return; 4. The standard deviation of FB stock return; 5. The return per unit of risk (return/SD) of FB stock return. 6. Please calculate the beta of FB. 7. You will need to do the above in excel. You need to follow the format of the Walmart Example posted (two tabs: "Original Data" and "Calculations"). The video shows how to do all the above. Slide 55 on Chapter 6 has the formula of CAPM. So we need to find out the stock return, and the market return (S&P 500) to calculate beta. I am using Walmart as the example. Symbol of S&P 500 is AGSPC. For this HW, we ignore risk free rate. Please also write a memo in word document: 1. Explain the definition of Beta 2. Use the concept of beta to explain how risky FB stock is relative to the S&P500Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started