Create a stock allocation simulation model and solve it using Analytic Solver for Excel:

You are about to graduate, and will soon accept a job. While a distant prospective, your personal finance classes have taught you that it is important to plan for your retirement. To ensure a stress-free retirement, you plan to invest $5,000 of your annual salary into a tax-sheltered IRA retirement fund (Vanguard VBIAX 60/40% stocks/bonds) every year. Looking at the past eighteen years of the VBIAX's existence, you find its average annual rate of return is 6.84% with a standard deviation of 12.58%. You assume that returns are normally distributed. c. a. If you start saving for retirement at 25 years old, how much money should you expect to have in her retirement fund at age 59? b. Construct a 95% confidence interval for the average amount you will have at age 59. What is the probability that you will have more than $1 million in your retirement fund when you reach age 59? d. How much should you invest each year if you want there to be a 90% chance of having at least $1 million in your retirement fund at age 59? How much should you invest each year if you want there to be a 75% chance of having at least $1 million in your retirement fund at age 59? e. Suppose that you contribute $5,000 annually to your retirement fund for nine years and then stop these contributions. How much of your salary would you have contributed to this retirement plan and how much money could you expect to have at age 59? f. Now suppose that you contribute nothing to your retirement fund for nine years and then begin to contribute $5,000 annually until age 59. How much of your salary would you have contributed to this retirement plan and how much money could you expect to have at age 59? You are about to graduate, and will soon accept a job. While a distant prospective, your personal finance classes have taught you that it is important to plan for your retirement. To ensure a stress-free retirement, you plan to invest $5,000 of your annual salary into a tax-sheltered IRA retirement fund (Vanguard VBIAX 60/40% stocks/bonds) every year. Looking at the past eighteen years of the VBIAX's existence, you find its average annual rate of return is 6.84% with a standard deviation of 12.58%. You assume that returns are normally distributed. c. a. If you start saving for retirement at 25 years old, how much money should you expect to have in her retirement fund at age 59? b. Construct a 95% confidence interval for the average amount you will have at age 59. What is the probability that you will have more than $1 million in your retirement fund when you reach age 59? d. How much should you invest each year if you want there to be a 90% chance of having at least $1 million in your retirement fund at age 59? How much should you invest each year if you want there to be a 75% chance of having at least $1 million in your retirement fund at age 59? e. Suppose that you contribute $5,000 annually to your retirement fund for nine years and then stop these contributions. How much of your salary would you have contributed to this retirement plan and how much money could you expect to have at age 59? f. Now suppose that you contribute nothing to your retirement fund for nine years and then begin to contribute $5,000 annually until age 59. How much of your salary would you have contributed to this retirement plan and how much money could you expect to have at age 59