401(k) Savings Calculator
http://www.vertex42.com/Calculators/401k-savings-calculator.html © 2008 Vertex42 LLC
401(k) Plan Assumptions
43 Age at Retirement 65 Balance and Salary Current 401(k) Balance $ Annual Salary $ 200,000 Annual Increase in Salary 2.0% Contributions % of Salary to Contribute 7.50% Employer Match (% of contrib.) 0.0% Employer Maximum (% of salary) 6.0%
Current Age .
Summary of Results
Years to Invest
22
Future Value
Estimated Value After 22 Years Ending Salary
$ $
810,205 303,133
Total Contributions
Your Contributions Employer Contributions Total Contributions
$ $ $
409,485 409,485
Return
Annual Rate of Return Payments Per Year $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $20 Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
6.00% 24
Balance
[42] Contribution My
Total Contribution
Min Max Average
Use Random Rates FALSE
-4.00% 10.00% 6.00%
(Press F9 to Recalculate)
30 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%
40 Salary
200,000
204,000 208,080 212,242 216,486 220,816 225,232 229,737 234,332 239,019 243,799 248,675 253,648 258,721 263,896 269,174 274,557
Age
50
60 Employer Contribution
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
70 Interest
Age
43
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
Annual Contribution
15,000 15,300 15,606 15,918 16,236 16,561 16,892 17,230 17,575 17,926 18,285 18,651 19,024 19,404 19,792 20,188 20,592
[42] Balance
$ 439.26 1,401.53 2,441.93 3,565.65 4,778.24 6,085.55 7,493.85 9,009.77 10,640.37 12,393.15 14,276.10 16,297.68 18,466.91 20,793.35 23,287.19 25,959.24 28,820.98 15,439.26 32,140.79 50,188.72 69,672.49 90,687.21 113,333.98 137,720.27 163,960.32 192,175.58 222,495.12 255,056.14 290,004.43 327,494.96 367,692.41 410,771.79 456,919.05 506,331.82 © 2008 Vertex42.com
Year
18 19 20 21 22 23 24 25 26 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
60 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 95 96 97 98 99 100 101 102
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% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Salary
280,048 285,649 291,362 297,189 303,133 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 0 0 0 0
Annual Contribution
21,004 21,424 21,852 22,289 22,735 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 0 0 0 0
Employer Contribution
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 0 0 0 0 0 0 0 0 0
Interest
31,884.63 35,163.15 38,670.34 42,420.82 46,430.18 50,035.84 53,125.91 56,406.81 59,890.33 63,588.97 67,516.04 71,685.63 76,112.73 80,813.22 85,804.01 91,103.01 96,729.26 102,702.98 109,045.61 115,779.94 122,930.17 130,521.97 138,582.63 147,141.08 156,228.08 165,876.26 176,120.29 186,996.96 198,545.34 210,806.91 223,825.72 237,648.54 252,325.01 267,907.86 284,453.05 302,020.03 320,671.90 340,475.65 361,502.42 383,827.74 407,531.80 432,699.76 459,422.02
Balance
559,220.07 615,806.91 676,329.41 741,039.45 810,204.62 860,240.47 913,366.38 969,773.18 1,029,663.51 1,093,252.48 1,160,768.53 1,232,454.16 1,308,566.88 1,389,380.11 1,475,184.12 1,566,287.13 1,663,016.39 1,765,719.37 1,874,764.98 1,990,544.92 2,113,475.09 2,243,997.07 2,382,579.69 2,529,720.77 2,685,948.85 2,851,825.11 3,027,945.40 3,214,942.36 3,413,487.70 3,624,294.61 3,848,120.33 4,085,768.87 4,338,093.88 4,606,001.73 4,890,454.79 5,192,474.82 5,513,146.71 5,853,622.36 6,215,124.78 6,598,952.51 7,006,484.31 7,439,184.08 7,898,606.10
© 2008 Vertex42.com
Tracking 401(k) Rate of Return
http://www.vertex42.com/Calculators/401k-savings-calculator.html © 2008 Vertex42 LLC
Cumulative Contribution
Date
IRR
Total Gain (Loss) 11.00 105.64 53.69 24.77 9.84 16.15 (68.87) Cash Flow (Total Contrib) 1250.00 201.00 201.00 201.00 201.00 300.00 201.00 0.00 0.00 0.00 0.00
Begin: S T A T E M E N T S
31-Dec-08 31-Jan-09 28-Feb-09 31-Mar-09 30-Apr-09 31-May-09 30-Jun-09
My Employer Value Contribution Contribution (Balance) 826.00 413.00 1250.00 134.00 67.00 1545.64 134.00 67.00 1694.69 134.00 67.00 1866.77 134.00 67.00 2052.84 200.00 100.00 2359.15 134.00 67.00 2475.13
My
Contribution
Employer
Contribution
Total
Contribution
826.00 960.00 1094.00 1228.00 1362.00 1562.00 1696.00
413.00 480.00 547.00 614.00 681.00 781.00 848.00
1239.00 1440.00 1641.00 1842.00 2043.00 2343.00 2544.00
Insert new rows above this one
45.94% -2475.13 186.5% Portfolio IRR: -2475.13 -8.86%
30-Jun-09
Personal IRR: $3,000 $2,500 $2,000 $1,500 $1,000
$500
Company Match Your Contributions VALUE
$Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09