NOTE: USE GOOGLE SPREADSHEET ONLY IN ANSWERING THIS TASK, DON'T USE EXCEL!

Direction: Answer the following task below using google spreadsheet, and paste here the link of the file of the google spreadsheet. SHOW THE COMPLETE SOLUTION using the formula in google spreadsheet.

Jane is considering investing in three different stocks or creating three distinct two- stock portfolios. Jane considers herself to be a rather conservative investor. She is able to obtain forecasted returns for the three securities for the years 2013 through 2019. The data are as follows: Year Stock A Stock B Stock C 2013 10% 10% 12% 2014 13 11 14 2015 15 8 10 2016 14 12 11 2017 16 10 9 2018 14 15 9 2019 12 15 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 expected return for each individual stock. b. Calculate the standard deviation for each individual stock. c. Calculate the expected returns for portfolio 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 con- sisting 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