ssignment: Chapter 14 Planning for Retirement L and Courtney 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 vafues are repeated; and 3) round the average annual inflation rate and the expected rate of retum on investments prior to retirement to three decimal places and round everything else to two decimal puaces (or the nearest whole number if it does not let you enter decimals). Projecting Retirement Income and Investment Needs II. Estimated Income in Retirement E. Social Security, annual income F. Company/employer pension plans, annual amounts G. Other sources, annual amounts $$0.00 H. Total annual income (E+F+G) I. Additional required income, or annual shortfall (DH) Projecting Retirement Income and Investment Needs III. Inflation Factor 3. Expected average annual inflation rate over the period to retirement 6% K. Infiation 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 return on assets held after retirement 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) 35 (b) Expected rate of return on investments prior to retirement (O)5% Q. Annual savings required to fund retirement nest egg (NP)