Hi can anyone help with this
I have the data below showing returns for the market and 5 stocks over the last 6 years I need to use solver to create 5 portfolios from the data below
Year Market risk free A B C D E
return rate
1 7.05 2.5 8.25 6.4 9.25 10.5 11
2 6.2 3 7.9 6.2 6.25 10.25 8.5
3 9.3 3.25 11 7 8.5 12.75 10.5
4 10 3 13 7.5 10 13 14
5 9.5 4 12.5 8 12.5 12.5 12.5
6 11 4.25 13 9.6 12.25 13 14.5
Bookmarks