Spreadsheet Exercise

Jane is considering investing in three different stocks or creating three distinct twostock portfolios. Jane considers herself to be a rather conservative investor. She is able to obtain forecasted returns for the three securities for the years $2015$ through $2021.$

The data are given in the following table. Stock A ; $2015$ is $10\%,2016$ is $13\%,2017$ is $15\%,2018$ is $14\%,2019$ is $16\%,2020$ is $14\%,2021$ is $12\%.$ Stock B; $2015$ is $10\%,2016$ is $11\%,2017$ is $8\%,2018$ is $12\%,2019$ is $10\%,2020$ is $15\%,2021$ is $15\%.$ Stock C; $2015$ is $12\%,2016$ is $14\%,2017$ is $10\%,2018$ is $11\%,2019$ is $9\%,2020$ is $9\%,2021$ is $10\%.$ If any of the possible $2$ stock portfolios, the weight of each stock in the portfolio will be $50\%.$The three possibke combinations are AB$,$ AC$,$ BC$.$