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&P500