We have the following information and assumptions about Ted's retirement planning process. Based on the information and assumptions, perform a 4 step approach analysis. Show your numbers/calculations for each of the steps. For steps completed in Excel, indicate the input numbers for each of the variables (PV, FV, Rate, NPER, PMT, Type) (20 Points total; 5 Points per Step) Current Salary: $72000 Current Age: 26 Wage replacement ratio at retirement: 85% Expected Retirement Age: 63 Inflation (both pre- and post-retirement: 3.5 % Life Expectancy: 91 Pre-retirement Nominal Return: 8.25% Expected Social Security: 22,000 Post-retirement Nominal Return: 6.5%