Share this Page URL
Help

Part: 5 Here's Our Advice > Worksheet 10: Determining Additional Money Required... - Pg. 269

Worksheets Years to Re- tirement 14 15 16 17 18 19 20 Rates of Return 4% 1.7 3 1.8 0 1.8 7 1.9 5 2.0 3 2.1 0 2.1 9 6% 2.26 2.40 2.54 2.69 2.85 3.03 3.21 8% 2.9 4 3.1 7 3.4 3 3.7 0 4.0 0 4.3 2 4.6 6 10% 3.80 4.18 4.59 5.05 5.56 6.12 6.73 12% 4.89 5.47 6.13 6.87 7.69 8.61 9.65 Years to Re- tirement 34 35 36 37 38 39 40 Rates of Return 4% 3.79 3.95 4.10 4.27 4.44 4.62 4.80 6% 7.25 7.69 8.15 8.64 9.15 9.70 10.29 8% 13.69 14.79 15.97 17.25 18.63 20.12 21.72 10% 25.55 28.10 30.91 34.00 37.40 41.14 45.26 269 12% 47.14 52.80 59.14 66.23 74.18 83.08 93.05 Worksheet 10: Determining Additional Money Required to Fund Your Retirement Goal Total money required to fund retirement goal (from Worksheet 8) minus Total value of retirement assets (from Worksheet 9) equals Excess/(Deficit) $___________(H) ­ $___________(I) = $___________(J) Worksheet 11: Determining How Much You Need to Save Each Year to Meet Your Retirement Goal Annual retirement money needed (from Worksheet 10) times Savings factor to retirement (from the following table) equals Amount to be saved each year until retirement age from all sources (including con- tributions by you and your company) minus Your gross annual pay equals Total % of Annual Gross Income that must be saved to meet goal * Round $___________(J) × ____________ = $___________(K) - $___________ = ____________% * to the nearest whole percentage Table A-6. Savings Factor to Retirement Years to Re- tirement 1 2 3 Rates of Return 4% 1.000 0.490 0.320 6% 1.000 0.485 0.314 8% 1.000 0.481 0.308 10% 1.000 0.476 0.302 12% 1.000 0.472 0.296 Years to Re- tirement 21 22 23 Rates of Return 4% 0.031 0.029 0.027 6% 0.025 0.023 0.021 8% 0.020 0.018 0.016 10% 0.016 0.014 0.013 12% 0.012 0.011 0.010