Beta and Correlation Coefficients Assignment | Homework For You

Download and manage the data for beta and correlation coefficients from finance.yahoo.com, and use Excel to calculate:

1. The time range is Jan 1^st,2012 through Dec 31^st , 2019, monthly data;
2. The Beta of Tapestry (TPR);
3. The Beta of Nike (NKE);
4. The Correlation Coefficient between TPR and NKE;
5. The Correlation Coefficient between TPR and the market, S&P 500;
6. The Correlation Coefficient between NKE and the market, S&P 500;
7. You will need to do the above in excel. Use two tabs , “Stock Price and Return”. show how you get the stock return and S&P 500 return in “Stock Price and Return”, and how you calculate the beta and CC in “Beta and CC”

Then you need to write a memo using Microsoft word:

8. Explain what “beta” is;
9. Use the concept of beta to explain how risky your stock is relative to the S&P500;
10. Explain what “Correlation Coefficient” is;
11. Explain the CC between the two stocks;
12. Explain the CC between TPR and the market, S&P 500;

Explain the CC between NKE and the market, S&P 500. VGet Finance homework help today