Question
Revise Tims Retirement Plan to take probabilities into account. Assume the salary increase will have a normal distribution with a mean of 4% and a
Revise Tims Retirement Plan to take probabilities into account. Assume the salary increase will have a normal distribution with a mean of 4% and a standard distribution of 1% Assume the annual rate of return will follow at table as follows 10% chance it will be 2% 20% chance it will be 3% 40% chance it will be 4% 20% chance it will be 5% 10% chance it will be 6% Assume he will contribute between a random uniform distribution between a minimum of 4% and a maximum of 8% Run 1000 simulations Prepare a Summary statistics for the amount Tim will have at retirement age of 65 Prepare a bin covering the max and min of the amount Tim could have at 65 Prepare a chart ( histogram) showing the frequencies of the amounts in each bin. Will Tim reach his retirement goal? And if not, what recommendations could you offer
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