. Use Excel to calculate the following measures

Ford motor company and General Motors

Ford motor company and General Motors

1. Download the monthly prices for companies you chose and S&P 500 index prices for last 5 years (5Y) from the finance.yahoo.com
2. Calculate the monthly returns for each company and Market index.
3. Calculate the average return for each company and Market Index (S&P 500 index)
4. Calculate the standard deviation for each company and Market Index.
5. Calculate the correlation between each company and Market Index.
6. Estimate Beta and the R-squared for each company using Excel functions SLOPE and RSQ.