you own three stocks: 600 shares of apple computer, 10,000 shares of cisco systems, and 5000 shares of colgate -palmolive the current share prices and expected returns of apple, cisco, and colgate-Palmolive are, respectively, $515,$15,$95 and 12%, 10%, 8%.

a. what are the portfolio weights of the three stocks in your portfolio?

b. what is the expected return of your portfolio?

c. suppose the price of apple stock goes up by $21, cisco rises by$7, and Colgate-Palmolive falls by $13. What are the new portfolio weights?

d. Assuming the stocks' expected returns remain the same, what is the expected return of the portfolio at the new prices?

Needed ASAP in excel spreadsheet. which can be used for similar problems.

time now

12:11 AM EST 02/06/2017