Retirement Savings Calculator
More Excel Templates
© 2008 Vertex42 LLC
Retirement Savings Plan Current Age Age at Retirement Present Value of Investment Expected Annual Return Annual Payment # of Payments (First N Years)
Estimated Future Value Years until retirement Estimated Future Value
35 65 $ 10,000 6.0% 2,000 15
30 $ $ $ 168,999 40,000 128,999
Total Invested Total Interest
$180,000 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $Balance Cumulative Payments
$
Use Random Rates FALSE Min Max Average
-2.00% 8.00%
6.00%
25 Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
35
45
55
65 Age 75 Balance
$ 10,000 12,600.00 15,356.00 18,277.36 21,374.00 24,656.44 28,135.83 31,823.98 35,733.42 39,877.42 44,270.07 48,926.27 53,861.85 59,093.56 64,639.17 70,517.52 74,748.57 79,233.49 83,987.50 89,026.75 94,368.35 100,030.45 106,032.28 112,394.22 119,137.87 126,286.14 133,863.31
Age
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
Rate
6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Invested (Payments)
10,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 0 0 0 0 0 0 0 0 0 0 0
Cumulative Payments
12,000 14,000 16,000 18,000 20,000 22,000 24,000 26,000 28,000 30,000 32,000 34,000 36,000 38,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000
Interest
600.00 756.00 921.36 1,096.64 1,282.44 1,479.39 1,688.15 1,909.44 2,144.00 2,392.65 2,656.20 2,935.58 3,231.71 3,545.61 3,878.35 4,231.05 4,484.91 4,754.01 5,039.25 5,341.60 5,662.10 6,001.83 6,361.94 6,743.65 7,148.27 7,577.17
Cumulative Interest
600.00 1,356.00 2,277.36 3,374.00 4,656.44 6,135.83 7,823.98 9,733.42 11,877.42 14,270.07 16,926.27 19,861.85 23,093.56 26,639.17 30,517.52 34,748.57 39,233.49 43,987.50 49,026.75 54,368.35 60,030.45 66,032.28 72,394.22 79,137.87 86,286.14 93,863.31
Year
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
Age
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94
Rate
6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Invested (Payments)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cumulative Payments
40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000
Interest
8,031.80 8,513.71 9,024.53 9,566.00 10,139.96 10,748.36 11,393.26 12,076.86 12,801.47 13,569.55 14,383.73 15,246.75 16,161.56 17,131.25 18,159.13 19,248.67 20,403.59 21,627.81 22,925.48 24,301.01 25,759.07 27,304.61 28,942.89 30,679.46 32,520.23 34,471.44 36,539.73 38,732.11 41,056.04 43,519.40 46,130.56 48,898.40 51,832.30 54,942.24
Cumulative Interest
101,895.11 110,408.81 119,433.34 128,999.34 139,139.31 149,887.66 161,280.92 173,357.78 186,159.25 199,728.80 214,112.53 229,359.28 245,520.84 262,652.09 280,811.21 300,059.88 320,463.48 342,091.29 365,016.76 389,317.77 415,076.84 442,381.45 471,324.33 502,003.79 534,524.02 568,995.46 605,535.19 644,267.30 685,323.34 728,842.74 774,973.30 823,871.70 875,704.00 930,646.24
Balance
141,895.11 150,408.81 159,433.34 168,999.34 179,139.31 189,887.66 201,280.92 213,357.78 226,159.25 239,728.80 254,112.53 269,359.28 285,520.84 302,652.09 320,811.21 340,059.88 360,463.48 382,091.29 405,016.76 429,317.77 455,076.84 482,381.45 511,324.33 542,003.79 574,524.02 608,995.46 645,535.19 684,267.30 725,323.34 768,842.74 814,973.30 863,871.70 915,704.00 970,646.24