Mike 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% annual interest and the remainder in the market portfolio that follows a normal distribution of an average returns = 12% and = 35%. Write a spreadsheet showing Marcuss accumulation by the time he is 60. Mike decides that he needs at least $2 million by the time he hits 60.

1. Run 100 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 asset and the probability of achieving the $2 million at age 60. Set the proportions in the risky to 0%, 10%, ... , 100%.