Value of investment portfolio after price changes, RRI

You are considering how to invest part of your retirement savings. You have decided to put $200,000 into three stocks: 50% of the money in GoldFinger (currently $25/share), 25% of the money in Moosehead (currently $80/share), and the remainder in Venture Associates (currently $2/share). If Goldfinger stock goes up to $30/share, Moosehead stock drops to $60/share, and Venture Associates stock rises to $3 per share.

a. What is the new value of the portfolio?
b. What return did the portfolio earn?
c. If you don't buy or sell shares after the price change, what are your new portfolio weights?

Please show in excel.

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/value-of-investment-portfolio-after-price-changes-rri-7eas