1 FINANCE QUESTION.Due in 4 HOURS

1 FINANCE QUESTION.Due in 4 HOURS

I need help with the following problem.Its DUE IN 4 HOURS.YOU should only use EXCEL 2013.

 

1 Portfolio Composition

Rocky the Bull has won $1,000,000 in Florida Lottery and wants to invest it in shares. He is interested 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?

 

NOTE

 

 

You should create  create a 3 stock portfolio  using EXCEL 2013 VERSION ONLY and answer the questions above.