U 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: Both L and Courtney are 30 years old and plan to retire when they reach age 65. Their estimated level of annual current household expenditures is $65,000. They estimate that they will need 80% in retirement. They will receive $1,556 per month of Social Security income and no other sources of income (except pension). They talked with friends and believe that is a realistic rate of return on their investments once they retire. eril Factors dure Vil Periods 20 25 30 35 40 3.00% 1.810 2.653 2.090 2:420 2.810 3.200 . 9.00% 5.000 8.620 11.200 20,410 21410 . Use the following tables to identify the necessary future value interest factors 5.00% 6.00% 8.00% 3.210 4.601 3.386 4,290 6.048 4.322 5740 16.062 5.516 14,785 7.690 7,040 10.280 21.224 . . reacoes the Value of any U will have worked at Target for his entire career and wit have an annual pension amount of $16,875. Courtney will have worked at General Electric for her entre career and will have an annual pension amount of $12,500. Based on their interest research, they will use 0% as the average annual inflation rate for retirement calculations After contacting their savings and loan, they found out a savings account is currently saying If your answer type 022) var ar Use the following tables to identify the necessary future value interest factors. Interest Factors-Future Value Interest Factors-Future Value of an Annuity Periods 3.00% 5.00% 6.00% 8.00% 9.00% 26.870 33.066 36.780 45.762 51.160 36.460 47.726 54.860 73.105 84.700 47.570 66.438 79.060 113.282 136.300 60.460 90.318 111.430 172.314 215.700 75.400 120.797 154.760 259.052 337.870 20 25 30 35 40 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 Name(s): Li and Courtney I. Estimated Household Expenditures in Retirement A. Approximate number of years to retirement B. Current level of annual household expenditures, excluding savings C. Estimated household expenses in retirement as a percentage of current expenses D. Estimated annual household expenditures in retirement (B x C) 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 H. Total annual income (E+F+ G) 1. Additional required income, or annual shortfall (D-H) S $0.00 $ $ Projecting Retirement Income and Investment Needs III. Inflation Factor 1. Expected average annual inflation rate over the period to retirement K. Inflation factor. (a) Years to retirement (A) (b) Average annual inflation rate (3) L Size of inflation-adjusted annual shortfall 35 6% ing Retirement Income and Investment Needs 6% $ Date: May 2015 35 $ 80% S Projecting Retirement Income and Investment Needs III. Inflation Factor J. Expected average annual inflation rate over the period to retirement K. Inflation factor (a) Years to retirement (A) (b) Average annual inflation rate (1) 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 P. Compound interest factor (a) Years to retirement (A) (b) Expected rate of return on investments prior to retirement (0) Q. Annual savings required to fund retirement nest egg (N+P) 35 6% 35 5% 8% 6% 5% $ 141 U 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: Both L and Courtney are 30 years old and plan to retire when they reach age 65. Their estimated level of annual current household expenditures is $65,000. They estimate that they will need 80% in retirement. They will receive $1,556 per month of Social Security income and no other sources of income (except pension). They talked with friends and believe that is a realistic rate of return on their investments once they retire. eril Factors dure Vil Periods 20 25 30 35 40 3.00% 1.810 2.653 2.090 2:420 2.810 3.200 . 9.00% 5.000 8.620 11.200 20,410 21410 . Use the following tables to identify the necessary future value interest factors 5.00% 6.00% 8.00% 3.210 4.601 3.386 4,290 6.048 4.322 5740 16.062 5.516 14,785 7.690 7,040 10.280 21.224 . . reacoes the Value of any U will have worked at Target for his entire career and wit have an annual pension amount of $16,875. Courtney will have worked at General Electric for her entre career and will have an annual pension amount of $12,500. Based on their interest research, they will use 0% as the average annual inflation rate for retirement calculations After contacting their savings and loan, they found out a savings account is currently saying If your answer type 022) var ar Use the following tables to identify the necessary future value interest factors. Interest Factors-Future Value Interest Factors-Future Value of an Annuity Periods 3.00% 5.00% 6.00% 8.00% 9.00% 26.870 33.066 36.780 45.762 51.160 36.460 47.726 54.860 73.105 84.700 47.570 66.438 79.060 113.282 136.300 60.460 90.318 111.430 172.314 215.700 75.400 120.797 154.760 259.052 337.870 20 25 30 35 40 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 Name(s): Li and Courtney I. Estimated Household Expenditures in Retirement A. Approximate number of years to retirement B. Current level of annual household expenditures, excluding savings C. Estimated household expenses in retirement as a percentage of current expenses D. Estimated annual household expenditures in retirement (B x C) 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 H. Total annual income (E+F+ G) 1. Additional required income, or annual shortfall (D-H) S $0.00 $ $ Projecting Retirement Income and Investment Needs III. Inflation Factor 1. Expected average annual inflation rate over the period to retirement K. Inflation factor. (a) Years to retirement (A) (b) Average annual inflation rate (3) L Size of inflation-adjusted annual shortfall 35 6% ing Retirement Income and Investment Needs 6% $ Date: May 2015 35 $ 80% S Projecting Retirement Income and Investment Needs III. Inflation Factor J. Expected average annual inflation rate over the period to retirement K. Inflation factor (a) Years to retirement (A) (b) Average annual inflation rate (1) 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 P. Compound interest factor (a) Years to retirement (A) (b) Expected rate of return on investments prior to retirement (0) Q. Annual savings required to fund retirement nest egg (N+P) 35 6% 35 5% 8% 6% 5% $ 141