please answer the questions from the first 2 photos. table 8.6 is the example

stock portfolios. Jane views herself as a rather conservative investor. She is able to Jane is considering investing in three different stocks or creating three distinct obtain historical returns for the three securities for the years 2012 through 2018. The ADSHEET EXERCISE two- data are given in the following table. Stock A 10% 13 15 Year 2012 2013 2014 2015 2016 2017 2018 Stock B 10% 11 8 12 10 15 15 Stock C 12% 14 10 11 9 14 16 14 12 10 In any of the possible two-stock portfolios, the weight of each stock in the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC. TO DO Create a spreadsheet similar to Tables 8.6 and 8.7 to answer the following: a. Calculate the average return for each individual stock. b. Calculate the standard deviation for each individual stock. c. Calculate the average returns for portfolios AB, AC, and BC. d. Calculate the standard deviations for portfolios AB, AC, and BC. e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of stocks A and B? Explain your answer from a risk-return viewpoint. f. Would you recommend that Jane invest in the single stock B or the portfolio con- sisting of stocks B and C? Explain your answer from a risk-return viewpoint. TABLE 8.6 Historical Returns, Average Return, and Standard Deviation for Portfolio XY A. Historical portfolio returns Year 2014 2015 2016 2017 2018 Asset X return, 8 % 10 12 14 16 Asset Y return, 16% 14 12 10 8 Portfolio return (0.50 X 8%) + (0.50 X 16%) 12% (0.50 X 10%) + (0.50 x 14%) = 12% (0.50 x 12%) + (0.50 X 12%) 12% (0.50 X 14%) + (0.50 X 10%) = 12% (0.50 X 16%) + (0.50 X 8%) 12% B. Average portfolio return, 2014-2018 12% + 12% + 12% + 12% + 12% 5 12% 7 C. Standard deviation of portfolio returns (12% 12%)2 + (12% - 12%)2 + (12% -12%)2 + (12% - 12%)+ (12% - 12%) S - 1 0% "Using Equation 8.5 Using Equation 8.3a