Question: Using Excel, determine the amount you need to have in your account the day you retire (PV) and conduct a sensitivity analysis to determine if

 Using Excel, determine the amount you need to have in your

Using Excel, determine the amount you need to have in your account the day you retire (PV) and conduct a sensitivity analysis to determine if you will have enough for retirement based on the various savings rates and RORs. Data for your situation follows: Starting salary = $60,000 (at end of first year) Annual raises = 5% p.a. Current age = 25 Career = 40 years Retirement = 30 years Amount needed in first year of retirement = 80% of last year's salary Inflation in retirement = 3% p.a. Round monies to the nearest dollar and use the 1000 separator (,). Provide your observations about the results of the sensitivity analysis

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!