DO NOT ANSWER IN EXCEL Stocks A and B have the following historical returns: Year rA rB 2015 -18% 56% 2016 44% 8% 2017 -22% -4% 2018 22% 24% 2019 34% -24% A. Calculate the average rate of return for...

Extracted text: DO NOT ANSWER IN EXCEL Stocks A and B have the following historical returns: Year rA rB 2015 -18% 56% 2016 44% 8% 2017 -22% -4% 2018 22% 24% 2019 34% -24% A. Calculate the average rate of return for each stock during the 5-year period. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio for the 5-year period? B. Now calculate the standard deviation of returns for each stock and for the portfolio. C. Looking at the annual returns data on the two stocks, would you guess that the correlation coefficient between returns on the two stocks is closer to 0.8 or to 20.8? D. If you added more stocks at random to the portfolio, which of the following is the most accurate statement of what would happen to o,? I. O, would remain constant. II. O, would decline to somewhere in the vicinity of 20%. II. O, would decline to zero if enough stocks were included.