6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Carlos and Anikti 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. Interest Factors - Future Value of an Annuity Name(s): Carlos and Ankti Date: May 2015 I. Estimated Household Expenditures in Retirement A. Approximate number of years to retirement B. Current level of annual household expenditures, exduding savings C. Estimated household expenses in retirement as a percentage of current expenses D. Estimated annual household expenditures in retirement (BC) II. Estimated Income in Retirement E. Social Security, annual income F. Company/employer pension plans, annual amounts 6. Other sources, annual amounts H. Total annual income (E+F+G) L. Additional required income, or annual shortfall (DH) III. Inflation Factor 3. Expected average annual inflation rate over the period to retirement K. Inflation factor (a) Years to retirement (A) (b) Average annual inflation rate ( ) ) L. Size of inflation-adjusted annual shortfall IV. Funding the Shortfall M. Anticipated return on assets held after retirement N. Amount of retirement fund required (your nest ego) o. Expected rate of return on investments prior to retirement P. Compound interest factor (a) Years to retirement (A) (b) Expected rate of return on investments prior to retirement (O) Q. Annual savings required to fund retirement nest egg (N+P)