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 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
Get step-by-step solutions from verified subject matter experts
