find interest rate 5 and 6 in dollars and amount of retirement funds required

Interest Factors-Future Value Interest infy tors-Future Value of an Annuity \begin{tabular}{lllllll} \hline 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 \\ \hline \end{tabular} Funding the shortfall In addition to determining a realistic inflation rate, Ryan and Rebecca talked to their financial advisor to understand rates of return now and after they reach retirement. First, their advisor projects that in 25 years, they can realistically earn 5% on their nest egg. Second, he recommends an investment vehicle that is earning 6% annually. Complete the following tabie using the inflation-adjusted annual shortfall at 5% as previously calculated. Continuing their worksheet, they consult a frlend, economics professor Dr. Garcia, who believes that they can expect the average annial inflation rate to be 5%, possibly 6% tops. Complete the following table by calculating inflation-adjusted annual shortall for Ryan and Rebecca at 5%. Then recalculate the shortfall based on the top rate provided by Dr. Garcla. Funding the shortfall In sddition to determining a realistic inflation rate, Avan and Rebecca talked to their financial advibor to underatand rates of return now and after thery reach retirement. Fint, their advisor projects that in 25 years, they can realistically earn 5% on their nest eg9. Second, he recommends an investment vehicie that is earning 6% annually. 5. Funding the nest egg shortfall Determining Retirement Shortfall Ryan and Rebecca have 25 years to retirement. They are taking a personal finance course and have calculated their projected retirement income and investment needs. Based on their calculations and taking into account their Social Security and pension inomes, they have a projected shortfall of $7,250,00 per year. Use the following tables to answer the questions about future value interest factors