Question: https: / / www . chegg.com / homework - help / questions - and - answers / someone - help - need - years -

https://www.chegg.com/homework-help/questions-and-answers/someone-help-need-years-1-5-done-part-part-b-need-parts-table-titles-shown-part-hang-calcu-q119993500
Provided the above link, can someone help continue by completing the following:
Part C. Assume that the salary annual salary growth rate, the annual inflation rate, and the annual investment rate are now normally distributed random variables, with a mean as given and a standard deviation equal to 15% of the mean. These variables will now change each year. Redo part A. Determine how much extra will be needed to deposit each year to be 90% sure you will meet your retirement objective. Complete a new table for this part.
Part D. For part C assume the deposit could be adjusted each year and the withdrawals can be adjusted each year to make the balance come out to zero. Construct a sheet that does this as the simulation trials proceed. Create a forecast cell that keeps track of the total amount that will need to be deposited and another forecast cell for the total amount of money withdrawn for each cycle.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!