Question 2: Please finish the question in the following picture: 8. Marcus is 25 years old. He has a new job and intends to save $10,000 today and in each of the next 34 years (35 deposits altogether). He has decided on an investment policy in which he invests 30% of his assets in a risk-free bond with 3% continuously compounded annual interest and the remainder in the market portfolio that has lognormal returns μ= 12% and σ=35%. Write a spreadsheet showing Marcus's accumulation by the time he is 60. A sample output is given below: 1 A B D MARCUS'S INVESTMENT/SAVINGS DECISION 2 Annual deposit 3 Risk-free rate 4 Market portfolio mean 5 Market portfolio sigma 6 Proportion in market portfolio 7 Accumulation at age 60 8 10,000 3% 12% 35% 70% 12,048,869 <-- B45 E Total investment at beginning of New Total investment at 9 Age period 10 25 0 10,000 11 26 13,065.44 10,000 12 27 27,795.31 10,000 13 28 52,906.64 10,000 investment end of period <--- 13,065.44 27,795.31 (B10+C10)*($B$6*EXP($B$4+ 52,906.64 $B$5 NORM.S.INV(RAND()))+(1- 58,590.40 $B$6) EXP($B$3)) 14 29 58,590.40 10,000 99,352.45