0 Determining Retirement Shortfall Rodrigo und Jense have 30 years to retirement. They are taking a personal finance course and have calculated their projected retirement income and wivestment seeds Based on their calculations and taking into account their Social Security and pension incomes, they have a projected shortfall of $5,000.00 per yor Use the following tables to answer the questions about future value interest actors Factors. Faro Pure Valueetan Art Periods 3,00% 5.00% 6.00% 5.00% 5.00% 20 1010 2,633 3.210 4.561 5.600 25 2.000 306 4290 0.630 30 2.1110 4322 3.700 10.06 13 260 35 2010 Sie 7.60 14.705 20 410 An 51 11 The impact of the nation factor Conting the worst that des professor De key whereves that they can expect the vergelinflation rate to be who Complete the table by calculation used and short for drag and desse at S Then calculate the short based on the toproteroided by Dr. Interest Factors-Future Value Interest FactorsFuture Value of an Annuity Periods 3.00% 5.00% 6.00% 8.00% 9.00% 20 26.870 33.066 36.780 45.762 51.160 25 36.460 47.726 54.860 73.105 84.700 30 47.570 66.438 79.060 113.282 136.300 35 60.460 90.318 111.430 172.314 215.700 40 75.400 120.797 154.760 259.052 337.870 The impact of the inflation factor Continuing their worksheet, they consult a friend, economics professor Dr. Blakely, who believes that they can expect the average annual inflation rate to be 5%, possibly 6% tops. Complete the following table by calculating inflation-adjusted annual shortfall for Rodrigo and Jesse at 5%. Then recalculate the shortfal based on the top rate provided by Dr. Blakely Interest rate (Percent) 5 Inflation-adjusted annual shortfall (Dollars) Funding the shortfall In addition to determining a realistic inflation rate, Rodrigo and Jesse talked to their financial advisor to understand rates of return now and after they reach retirement. First, their advisor projects that in 30 years, they can realistically earn 5% on their nest egg. Second, he recommends an investment vehicle that is earning 6% annually Complete the following table using the inflation-adjusted annual shortfall at 5% as previously calculated Interest rate (Percent) 5 Amount of retirement funds required (Dollars) Description Amount of retirement fund required Annual savings required to fund nest egg 6