6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Carlos and Ankti know that you are completing a personal finance course and that you understand how to complete a Projecting Retirement Income and Investment Needs worksheet. They have gathered the following information for you: Use the following tables to identify the necessary future value interest factors. Use the following tables to identify the necessary future value interest factors. \begin{tabular}{l|l} Interest Factors-Future Value & Interest Factors_Future Value of an Annuity \end{tabular} \begin{tabular}{llllll} \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} Complete the following sections of the worksheet. Note: 1 ) Every field must have a value (if your answer is zero, type " 0 "); 2 ) some values are repeated; and 3) round the average annual inflation rate and the expected rate of return on investments prior to retirement to three decimal places, and round everything else to two decimal places (or the nearest whole number if it does not let you enter decimals). Projecting Retirement Income and Investment Needs III. Inflation Factor J. Expected average annual inflation rate over the period to retirement 6% K. Inflation factor (a) Years to retirement (A)30 (b) Average annual inflation rate (J) 6% L. Size of inflation-adjusted annual shortfall Projecting Retirement Income and Investment Needs IV. Funding the Shortfall M. Anticipated return on assets held after retirement 8% N. Amount of retirement fund required (your nest egg) $ O. Expected rate of return on investments prior to retirement 5% P. Compound interest factor (a) Years to retirement (A) 30 (b) Expected rate of return on investments prior to retirement (O)5% Q. Annual savings required to fund retirement nest egg (NP) $