Qoestion B (50%) Using the information below. answer the following questions Carry all the answers to two decimal points, unless otherwise specified. E.g. $12.34 or 12.34%. 1. Calculate the answers of a. b. c. in both without inflution and with inflation (assume the inflution rate is 3% per year) (25 %) 2. Conduct a secnario analysis on the "without infltion" part to show the answers of a, b, c. below with the following two scenarios Scenario X: Rate of return before retirement at 9%, Rate of return during retirement at 3% Scenario Y: Rate of return before retirement at 5%, Rate of return during retirement at 4% Retirement Worksheet with Growing Income and Savings Annual Retirement Income Need 100,000 Years until Retirement 35 Years in Retirement 30 Expected Inflation Rate 3.00% Rate of Return before Retirement 7.00% Rate of Return during Retirement 5.00% Without Inflation With Inflation a. Savings Required at Retirement b. Investment Required Today c. Annual Investment required Qoestion B (50%) Using the information below. answer the following questions Carry all the answers to two decimal points, unless otherwise specified. E.g. $12.34 or 12.34%. 1. Calculate the answers of a. b. c. in both without inflution and with inflation (assume the inflution rate is 3% per year) (25 %) 2. Conduct a secnario analysis on the "without infltion" part to show the answers of a, b, c. below with the following two scenarios Scenario X: Rate of return before retirement at 9%, Rate of return during retirement at 3% Scenario Y: Rate of return before retirement at 5%, Rate of return during retirement at 4% Retirement Worksheet with Growing Income and Savings Annual Retirement Income Need 100,000 Years until Retirement 35 Years in Retirement 30 Expected Inflation Rate 3.00% Rate of Return before Retirement 7.00% Rate of Return during Retirement 5.00% Without Inflation With Inflation a. Savings Required at Retirement b. Investment Required Today c. Annual Investment required