Good afternoon Course HERO EXPERT! I am in MBA615 working on Unit 6's homework and am stuck. I've attached my excel sheet for reference. Please provide step-by-step instructions along with the final ANSWER to ALL PARTS A, B & C, please.

MBA615_Unit 6 HOMEWORK.xlsx - Saved . Search Esther Colvin EC X File Home Insert Draw Page Layout Formulas Data Review View Help ProjectWise Acrobat Share Comments AutoSum Calibri 11 ~ A" A ap Wrap Text Accounting Fill AY O Paste BIU HA BEE E Merge & Center $ ~ % 9 08 328 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Sensitivity Formatting Table S Styles Clear Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing deas Sensitivity AutoSave Off) B6 X fix A B C N You are considering how to invest part of your retirement savings. You have decided to put $200,000 into three stocks: 55% of the money in GoldFinger (currently $26/share), 30% of the money in Moosehead (currently $91/share), and the remainder in Venture Associates (currently $10/share). If GoldFinger stock goes up to $42/share, Moosehead stock drops to $64/share, and Venture Associates stock 4 to $3 per share 5 a. What is the new value of the portfolio? b. What return did the portfolio earn? c. If you don't buy or sell any shares after the price change, what are 6 your new portfolio weights? 7 To find the value of the new portfolio, you first need to find the # of 8 shares you own in each stock. Let n; equal the # of shares of stock / : ni = Percentage in Stock / x Total investment 9 Original price of Stock i MBA615_UNIT6 Homework GRADE MBA615_Unit6, Q1 MBA615_Unit6, Q2 MBA615_Unit6, Q3 MBA615_Unit6, ... + 4 Ready + 100%