Attempts Average/4 & Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs L and Courtney know that you are completing a personal finance course and that you understand how to complete a Projecting Retement Income and Investment Needs worksheet. They have gathered the following information for you Both and Courtney are 30 years old and plan to retire when they reach ag 65 Theit estimated level of annual current household expenditures is $55,000. They estimate that they will need BON They will receive $1,550 per month of Social Security income and no other sources of income (except pension). They talked with friends and believe that 8% in a realistic rate of veturn on their investments once they retire, . . . . Use the following tables to identify the necessary future value interest factors U will have worked at Target for his entire career and will have an annual pension amount of $16,875 orked at General Electric for her entire Courtney will have career and will have an annual pension $12.500 Based on their botemet research, they will use has the average annual inflation rate for retirement calcu After contacting their savings and loan, they found out a savings account is currently paving 5% 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% 1-810 2.090 2.420 2.810 20 25 30 35 40. 5.00% 6.00% 8.00% 2.653 3.210 4.661 3.386 4.290 6.848 5,740 10.062 7,690 14,785 10.30 21.224 5.516 2.040 9.00% 5.000 8.620 13.260 20.410 31am Complete the following sections of the worksheet. Note: 1) Every held must have a value (if your answercers type 0; 2) me values are feat care and the expected rate of return on investments prior to retirement to three decimal places 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% 25,870 33.065 36.780 45.762 54,860 73.105 36.460 47.725 47,570 66.438 79,060 113.282 172.314 250.052 60.460 75.400 90.318 120.707 111.430 154 760 20 25 30 35 An 9.00% 51.1507 84.700 136.300 215.700 332.120 Complete the following sections of the worksheet. Note: 1) Every field must have a value of your answer is ze type 707; 2) some values are ented and3) round the average annual inflation rate and the expected rate of return on investments prior to retirement to three decimal places demais! Tuning for Retirement Complete the following sections of the workshout Note: 1) Every felt must have a value your answer tre 02:2) e valove are reputed; and 33 round the average annual inflation rate and the expected rate of return on instante prior to retirement to three decimal plac and round everything else to two decimal places for the neare whole number if it does not let you enter decima Projecting Retirement Income and Investment Needs Name(s): Land Courtney 1. Estimated Household Expenditures in Retirement A. Appreviniaba number of years to retirement B. Current level of annual bousehold expenditures, excluding savings C. Estimated household expenses in retirement as a percentage of corrent expenses D. Estimated annuaal hounnhold expenditures in retirement (C) Projecting Retirement Income and Investment Needs IL Estimated Income in Retirement E Social Security, atual income Company/employer pensioe an annual amounts G. Other sources, annual amounts H. Total annual income (EF+G 1. Additional requered income, or anual shortfall (0-10 | $0.00 1 Projecting Retirement Income and Investment Needs Cate: May 2015 D L 50% N Projecting Retirement Income and Investment Needs 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 (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 epp) 0. 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) O. Annual savings required to fund retirement nest ego (N+P) 35 65 35 5% 506 6% 6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Used 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 and Courtney am 30 years old and plan to retire when they reach age 65 The estimated level of annual current household expenditures is 65,000. They stimate that they will need 80% intretant They will receive 1,556 per month of Social Security Income bed moothie sources of lecome (cept pension). They talked with ends and believe that is a realistic rate nebar on their investments, once they retir * * . . Use the foong tables moy the necessary future valce interest factions U will have worked at Target for his entire career and will have an annual pension amount of $16,875 Courthey will have worked at General Electric for her entire career and will have an annual pension amount of $12,500. Based on their Internet research, they will use 6% as the average annual inflation rate for retirement calculations, After contacting their savings and lean, they found i savings account is currently paying 3% R 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% 1.810 2.653 3.210 4.661 5.600 3.386 4.290 6.848 8.620 4.322 5.740 10.062 13.260 5.516 7.690 14.785 20.410 31.410. 7.040 10.280 21.224 20 25 30 35 ALL 2.090 2:420 2.810 3.360. 7 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 84,700 36.460 47.726 54.860 73,105 47.570 66.438 29.060 113.282 60.460 90.318 111.430 172,314 136.300 215.700 25.400 120.297 154,250 250.052 337 820 20 25 30 35 An Complete the following sections of the worksheet. Note: 1) Every field must have a value (if your answer is er type 03:27 some values are pated and 3) round the average annual inflation rate and the expected rate of return on investments prior to retirement to three decimal plecins, and round everything site to two decimal places for the nearest whole number if it does not let you enter decimal Projecting Retirement Income and Investment Needs Nam(): Er and Courtney L Estimated Household Expenditures in Retirement A Approximate number of years to retirement B. Current level annual household expenditures, exudeg savings C. Estimated household expenses in retirement as a percentage of current expenses Projecting Retirement Income and lovestment Needs Company/employer pension plans, annual amounts aalounts Center in th shortfall (D-H) $0.00 S Date: May 2015 35 $ 80% 1 Projecting Retirement Income and Investment Needs III. Inflation Factor 1. Expected average annual leffation rate over the period to retirement K Inflation factor (a) Years to retrement (A) (b) Average annual leftation rate (1) Lsx of inflation-adjusted annual shortfall Projecting Retirement Income and Investment Needs IV. Funding the shortfall M. Arnicipated return on asta held after retirement N. Amount of retirement fund required (your nest mo C. Expected rate of turn investmarts prior to retiosmeet Compound interest factor (A) Yours to retirement (A) (b) Expected rate of return on investments prior to rement (0) QAnnual savings rea fund retirement (NP) 35 6% 35 6 15 Attempts Average/4 & Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs L and Courtney know that you are completing a personal finance course and that you understand how to complete a Projecting Retement Income and Investment Needs worksheet. They have gathered the following information for you Both and Courtney are 30 years old and plan to retire when they reach ag 65 Theit estimated level of annual current household expenditures is $55,000. They estimate that they will need BON They will receive $1,550 per month of Social Security income and no other sources of income (except pension). They talked with friends and believe that 8% in a realistic rate of veturn on their investments once they retire, . . . . Use the following tables to identify the necessary future value interest factors U will have worked at Target for his entire career and will have an annual pension amount of $16,875 orked at General Electric for her entire Courtney will have career and will have an annual pension $12.500 Based on their botemet research, they will use has the average annual inflation rate for retirement calcu After contacting their savings and loan, they found out a savings account is currently paving 5% 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% 1-810 2.090 2.420 2.810 20 25 30 35 40. 5.00% 6.00% 8.00% 2.653 3.210 4.661 3.386 4.290 6.848 5,740 10.062 7,690 14,785 10.30 21.224 5.516 2.040 9.00% 5.000 8.620 13.260 20.410 31am Complete the following sections of the worksheet. Note: 1) Every held must have a value (if your answercers type 0; 2) me values are feat care and the expected rate of return on investments prior to retirement to three decimal places 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% 25,870 33.065 36.780 45.762 54,860 73.105 36.460 47.725 47,570 66.438 79,060 113.282 172.314 250.052 60.460 75.400 90.318 120.707 111.430 154 760 20 25 30 35 An 9.00% 51.1507 84.700 136.300 215.700 332.120 Complete the following sections of the worksheet. Note: 1) Every field must have a value of your answer is ze type 707; 2) some values are ented and3) round the average annual inflation rate and the expected rate of return on investments prior to retirement to three decimal places demais! Tuning for Retirement Complete the following sections of the workshout Note: 1) Every felt must have a value your answer tre 02:2) e valove are reputed; and 33 round the average annual inflation rate and the expected rate of return on instante prior to retirement to three decimal plac and round everything else to two decimal places for the neare whole number if it does not let you enter decima Projecting Retirement Income and Investment Needs Name(s): Land Courtney 1. Estimated Household Expenditures in Retirement A. Appreviniaba number of years to retirement B. Current level of annual bousehold expenditures, excluding savings C. Estimated household expenses in retirement as a percentage of corrent expenses D. Estimated annuaal hounnhold expenditures in retirement (C) Projecting Retirement Income and Investment Needs IL Estimated Income in Retirement E Social Security, atual income Company/employer pensioe an annual amounts G. Other sources, annual amounts H. Total annual income (EF+G 1. Additional requered income, or anual shortfall (0-10 | $0.00 1 Projecting Retirement Income and Investment Needs Cate: May 2015 D L 50% N Projecting Retirement Income and Investment Needs 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 (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 epp) 0. 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) O. Annual savings required to fund retirement nest ego (N+P) 35 65 35 5% 506 6% 6. Projecting retirement income and the investment needs worksheet Estimating Future Retirement Needs Used 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 and Courtney am 30 years old and plan to retire when they reach age 65 The estimated level of annual current household expenditures is 65,000. They stimate that they will need 80% intretant They will receive 1,556 per month of Social Security Income bed moothie sources of lecome (cept pension). They talked with ends and believe that is a realistic rate nebar on their investments, once they retir * * . . Use the foong tables moy the necessary future valce interest factions U will have worked at Target for his entire career and will have an annual pension amount of $16,875 Courthey will have worked at General Electric for her entire career and will have an annual pension amount of $12,500. Based on their Internet research, they will use 6% as the average annual inflation rate for retirement calculations, After contacting their savings and lean, they found i savings account is currently paying 3% R 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% 1.810 2.653 3.210 4.661 5.600 3.386 4.290 6.848 8.620 4.322 5.740 10.062 13.260 5.516 7.690 14.785 20.410 31.410. 7.040 10.280 21.224 20 25 30 35 ALL 2.090 2:420 2.810 3.360. 7 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 84,700 36.460 47.726 54.860 73,105 47.570 66.438 29.060 113.282 60.460 90.318 111.430 172,314 136.300 215.700 25.400 120.297 154,250 250.052 337 820 20 25 30 35 An Complete the following sections of the worksheet. Note: 1) Every field must have a value (if your answer is er type 03:27 some values are pated and 3) round the average annual inflation rate and the expected rate of return on investments prior to retirement to three decimal plecins, and round everything site to two decimal places for the nearest whole number if it does not let you enter decimal Projecting Retirement Income and Investment Needs Nam(): Er and Courtney L Estimated Household Expenditures in Retirement A Approximate number of years to retirement B. Current level annual household expenditures, exudeg savings C. Estimated household expenses in retirement as a percentage of current expenses Projecting Retirement Income and lovestment Needs Company/employer pension plans, annual amounts aalounts Center in th shortfall (D-H) $0.00 S Date: May 2015 35 $ 80% 1 Projecting Retirement Income and Investment Needs III. Inflation Factor 1. Expected average annual leffation rate over the period to retirement K Inflation factor (a) Years to retrement (A) (b) Average annual leftation rate (1) Lsx of inflation-adjusted annual shortfall Projecting Retirement Income and Investment Needs IV. Funding the shortfall M. Arnicipated return on asta held after retirement N. Amount of retirement fund required (your nest mo C. Expected rate of turn investmarts prior to retiosmeet Compound interest factor (A) Yours to retirement (A) (b) Expected rate of return on investments prior to rement (0) QAnnual savings rea fund retirement (NP) 35 6% 35 6 15