PLEASE COMPLETE IN EXCEL

Mike is 25 years old. He has a new job and intends to save $10,000 today and in each of the next 39 years (40 deposits altogether). He has decided on an investment policy in which he invests 30% of his assets in a risk-free bond with 4% annual interest and the remainder in the market portfolio that follows a normal distribution of an average returns =12% and = 32%. Write a spreadsheet showing Mike's accumulation by the time he is 65 . Mike decides that he needs at least $2.5 million by the time he hits 65 . 1. Run 500 simulations in order to determine the approximate probability of achieving this goal. 2. Compute the average and standard deviation of the terminal wealth. 3. Create a Data Table to determine the relation between the proportion invested in the risky assets and the probability of achieving the $2.5 million at age 65 . Set the proportions in the risky assets to 0%,10%,,100%