Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi I need help for the following questions ,Monte Carlo Simulation , ,Problem: Suppose an employee starts working after completing her MBA at age 30

Hi I need help for the following questions

,Monte Carlo Simulation , ,Problem: Suppose an employee starts working after completing her MBA at age 30 at a starting salary of ,$50,000. She expects an annual salary increase to be at minimum 1%, at maximum 5%, with a uniform distribution. Her retirement plan requires that she contribute 8% of her salary, and her employer matches that by adding an additional 35% of her contribution. She anticipates an annual return on her retirement portfolio (i.e., return on investment) to be a normal distribution with a mean of 4% and standard deviation of 3.5%. She plans to retire at age 60. Create a spreadsheet model to forecast her average return on investment (i.e., retirement account balance) when she retires at age 60 based on 5,000 simulation trials. , ,What is the expected average balance of her retirement account when she retires at age 60? ,What is the probability that her ending retirement balance at age 60 will be over $450k? Generate a histogram or density chart that shows this. ,

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Mathematics questions