56 Using the information below, answer the following questions 57 Carry all the answers to two decimal points, unless otherwise specified. Eg. $12.34 or 12.34%. 58 1. (20%) Calculate the answers of a. b. c. in both with inflution and with inflation (assume the inflution rate is 3% per year) 59 2. (25%) Conduct an secnario analysis to show the answers of a,b,c, below (without inflation) with the follow two scenarios 60 Make sure all cell names are presented in your scenario outcome 61 Scenario X: Rate of return before retirement at 8%, Rate of retum during retirementat 3% 62 Scenario Y: Rate of return before retirement at 6%, Rate of return during retirement at 5% 63 Retirement Worksheet with Growing Income and Savings 65 Annual Retirement Income Need 100,000 66 Years until Retirement 67 Years in Retirement 68 Expected Inflation Rate 3.00% 69 Rate of Return before Retirement 7.00% 70 Rate of Return during Retirement 4,00 Without Inflation With Inflation 72 a. Savings Required at Retirement 73 b. Investment Required Today 74 c. Annual Investment required 71 Sheet1 + Sheet2 Shoot3 Ready