Question
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
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 Mikes 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%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started