11. Compute the standard deviation for Stock Y 12. Fill in the blank for the market's return in year 1 and compute the arithmetic mean. 13. Compute the geometric mean for the market. 14. Compute the standard deviation for the market. 15. Compute the correlation between Stock X and Stock Y 16. Compute the beta for Stock X. 17. Compute the beta for Stock Y EXCEL INVESTMENTS PROJECT Use this page as your coversheet for the spreadsheets you generate when solving the problems below. 1. Fill in the blank and compute the current price of a stock that will sell for $80 after % return 10 years if you want a 2. Fill in the blank and compute the current price of a stock that will sell for $90 after years, pay an annual dividend of $3 and return 12% annually. 3. Fill in the blank and compute the annual return on a stock purchased 7 years ago for $ So that now sells for $75. 4. Fill in the blank and compute the annual return on a stock purchased 10 years ago for $25 that pays an annual dividend of $2 and now sells for $ 5. Fill in the blank and compute the number of years it will take for a $30 stock to 10 % per year. appreciate to $45 if it returns Market Stock Y Stock X Year 8% 12% -8% 0% -4% 15% 10% 16% 3 8% 11% 9% 4 23% 21% 5 -2 % 0% 3% 18% 17% 22% 7 20% 14% 15% 7% 2% 6% 15% 12% 10 6. Fill in the blank for Stock X's return in year 10 and compute the arithmetic mean. 7. Compute the geometric mean for Stock X 8. Compute the standard deviation for Stock X. 9. Fill in the return for Stock Y's return in year 5 and compute the arithmetic mean. 10. Compute the geometric mean for Stock Y