with a savings rate of 15%

You have recently graduated and just started your first job. Your financial advisor has recommended saving for retirement to ensure you have enough to live large and to leverage the time value of money. Data for your situation follows: Starting salary $60,000 (at end of first year) Annual raises 5% pa. Current age- 25 career 40 years ROR in career-10% pa. Retirement 30 years Amount needed in first year of retirement-80% of last year's salary Inflation in retirement-3% p.a ROR in retirement-5% pa. In the Retirement 1 tab, calculate the values going out to 40 years and graph the ending balances 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. Round monies to the nearest dollar and use the 1000 separator (). Provide your observations about the results of the sensitivity analysis. You have recently graduated and just started your first job. Your financial advisor has recommended saving for retirement to ensure you have enough to live large and to leverage the time value of money. Data for your situation follows: Starting salary $60,000 (at end of first year) Annual raises 5% pa. Current age- 25 career 40 years ROR in career-10% pa. Retirement 30 years Amount needed in first year of retirement-80% of last year's salary Inflation in retirement-3% p.a ROR in retirement-5% pa. In the Retirement 1 tab, calculate the values going out to 40 years and graph the ending balances 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. Round monies to the nearest dollar and use the 1000 separator (). Provide your observations about the results of the sensitivity analysis