1) Task of best stock solutions:
Renee is considering investing in 3 various stocks or creating three different 2 stock portfolios. Renee considers herself to be the conservative investor. She is able to get forecasted returns for 3 securities for years 2013 through 2019. Data are as given below:
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 2 likely stock portfolios, weight of each stock in portfolio will be= 50%. Three possible portfolio combinations are= AB, AC, BC.
Carry out the following:
i) Make a spreadsheet to reply the following problems?
ii) Compute expected return for each individual stock .
iii) Compute the standard Deviation for each individual stock.
iv) Compute expected returns for portfolio AB, AC, BC.
iv) Compute standard Deviations for portfolios AB, AC, BC
v) Would you suggest that Jane invest in single stock A or portfolio consisting of stocks A and B? Describe your reply from the risk return view point.
vi) Would you suggest that Jane invest in single stock B or the portfolio consisting of stocks B and C? Describe your reply from a risk return view point.