Question: https: / / www . chegg.com / homework - help / questions - and - answers / someone - help - need - years -
https:wwwchegg.comhomeworkhelpquestionsandanswerssomeonehelpneedyearsdonepartpartbneedpartstabletitlesshownparthangcalcuq
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 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
