Using the information below, answer the following questions Carry all the answers to two decimal points,...

 

Transcribed Image Text:

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. (25%) Calculate the answers of a. b. c. in both with inflution and with inflation (assume the inflution rate is 3% per year). 2. (20%) Conduct an secnario analysis to show the answers of a., b., c. below (without inflation) with the follow two scenarios Make sure you define the cell names before you run the scenario analysis: Scenario X: Rate of return before retirement at 8%, Rate of return during retirement at 3% Scenario Y: Rate of return before retirement at 6%, Rate of return during retirement at 5% Retirement Worksheet with Growing Income and Savings Annual Retirement Income Need Years until Retirement Years in Retirement Expected Inflation Rate Rate of Return before Retirement Rate of Return during Retirement a. Savings Required at Retirement b. Investment Required Today c. Annual Investment required Without Inflation 120,000 30 25 3.00% 7.00% 4.00% With Inflation 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. (25%) Calculate the answers of a. b. c. in both with inflution and with inflation (assume the inflution rate is 3% per year). 2. (20%) Conduct an secnario analysis to show the answers of a., b., c. below (without inflation) with the follow two scenarios Make sure you define the cell names before you run the scenario analysis: Scenario X: Rate of return before retirement at 8%, Rate of return during retirement at 3% Scenario Y: Rate of return before retirement at 6%, Rate of return during retirement at 5% Retirement Worksheet with Growing Income and Savings Annual Retirement Income Need Years until Retirement Years in Retirement Expected Inflation Rate Rate of Return before Retirement Rate of Return during Retirement a. Savings Required at Retirement b. Investment Required Today c. Annual Investment required Without Inflation 120,000 30 25 3.00% 7.00% 4.00% With Inflation