6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Alex and Jesse 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. Complete the following sections of the worksheet. Note: 1) Every field must have a value (if your answer is zero, type "O.); 2) some values are. repeated; and 3) round the average annuai innlation rate and the expected rate of return on investments prior to retirement to three decimat piaces, 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 3. Expected average annual inflation rate over the period to retirement 6% K. Inflation factor (a) Years to retirement (A) 35 (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 retum on assets held after retirement 8% N. Amount of retirement fund required (your nest egg) O. Expected rate of retum on investments prior to retirement 5% P. Compound interest factor (a) Years to retirement (A) 35 (b) Expected rate of return on investments prior to retirement (O) 5% Q. Annual savings required to fund retirement nest egg (NP) 6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Alex and Jesse 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. Complete the following sections of the worksheet. Note: 1) Every field must have a value (if your answer is zero, type "O.); 2) some values are. repeated; and 3) round the average annuai innlation rate and the expected rate of return on investments prior to retirement to three decimat piaces, 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 3. Expected average annual inflation rate over the period to retirement 6% K. Inflation factor (a) Years to retirement (A) 35 (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 retum on assets held after retirement 8% N. Amount of retirement fund required (your nest egg) O. Expected rate of retum on investments prior to retirement 5% P. Compound interest factor (a) Years to retirement (A) 35 (b) Expected rate of return on investments prior to retirement (O) 5% Q. Annual savings required to fund retirement nest egg (NP)