This needs to be complete on excel 2013 1 portfolio
This needs to be complete on EXCEL 2013
1 Portfolio Composition
Rocky the Bull has won $1,000,000 in Florida Lottery and wants to invest it in shares. He isinterested in investing in General Mills, GE and Intel shares only. He wants to invest half hiswindfall in the safest possible portfolio (Portfolio A) and wants the other half (Portfolio B) togenerate maximum return for him.
a) Chart the feasible set, with the efficient frontier, available to him.b) How many shares of each firm will he buy in Portfolio A?c) How many shares of each firm will he buy in Portfolio B?