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 |
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 |
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 |
103 |
104 |
105 |
106 |
107 |
108 |
|
| 401(k) Savings Calculator | | | | | | | | Note: This spreadsheet is for illustrative purposes only. | | | | | | | | | | | http://www.vertex42.com/Calculators/401k-savings-calculator.html | | | | | | | © 2008 Vertex42 LLC | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 401(k) Plan Assumptions | | | Summary of Results | | | | | | | | | | | | | | Current Age | 35 | | Years to Invest | 30 | | | | | | | | | | | | | | Age at Retirement | 65 | | | | | | | | | | | | | | | | | | Balance and Salary | | | Future Value | | Note: | | | | | | | | | | | | Current 401(k) Balance | $- | | Estimated Value After 30 Years | $675,139 | | Taxes and IRS Contribution Limits are | | | | | | | | | | | | Current Annual Salary | $50,000 | | Ending Salary | $88,792 | | NOT factored into the calculations. You must | | | | | | | | | | | | Annual Increase in Salary | 2.0% | | | | | check to insure that you are not contributing | | | | | | | | | | | | | Contributions | | | Total Contributions | | more than the IRS Limit (2009 limit = $15,500 | | | | | | | | | | | | % of Salary to Contribute | 10.00% | | Your Contributions | $202,840 | | for age < 50 and $22,000 for age >= 50) | | | | | | | | | | | | Employer Match (% of contrib.) | 50.0% | | Employer Contributions | $60,852 | | | | | | | | | | | | | | Employer Maximum (% of salary) | 6.0% | | Total Contributions | $263,693 | | Set Chart Y-Axis to a Fixed Value | | | | | | | | | | | | | . | | | | | When making comparisons using the graph, | | | | | | | | | | | | | Return | | | | | it helps to set the y-axis on the chart to some | | | | | | | | | | | | Annual Rate of Return | 6.00% | | | | | maximum $ amount. Right-click on the $ axis, select | | | | | | | | | | | | Payments Per Year | 12 | | | | | Format Axis, go to the Scale tab, uncheck the box | | | | | | | | | | | | | | | | | | next to Maximum, and set the max value. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [42] | | | | | FALSE | | Using Random Rates. If you check the | | | | | | | | | | | | | | | Min | -4.00% | | "Use Random Rates" box, then the Rate column will | | | | | | | | | | | | | | | Max | 10.00% | | calculate a random rate between the min and max | | | | | | | | | | | | | | | Average | 6.00% | | that you specify. To recalculate, press F9. | | | | | | | | | | | | | | | | (Press F9 to Recalculate) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [42] | | | | | | | | | | | | Year | Age | Rate | Salary | Annual Contribution | Employer Contribution | Interest | Balance | | My Contribution | Total Contribution | | | | | | | | | | | | | | | $- | | | | | | | | | | | | 1 | 35 | 6.00% | 50,000 | 5,000 | 1,500 | 181.76 | 6,681.76 | | 5,000 | 6,500 | | | | | | | | | 2 | 36 | 6.00% | 51,000 | 5,100 | 1,530 | 597.51 | 13,909.28 | | 10,100 | 13,130 | | | | | | | | | 3 | 37 | 6.00% | 52,020 | 5,202 | 1,561 | 1,047.00 | 21,718.88 | | 15,302 | 19,893 | | | | | | | | | 4 | 38 | 6.00% | 53,060 | 5,306 | 1,592 | 1,532.46 | 30,149.19 | | 20,608 | 26,790 | | | | | | | | | 5 | 39 | 6.00% | 54,122 | 5,412 | 1,624 | 2,056.28 | 39,241.28 | | 26,020 | 33,826 | | | | | | | | | 6 | 40 | 6.00% | 55,204 | 5,520 | 1,656 | 2,621.00 | 49,038.80 | | 31,541 | 41,003 | | | | | | | | | 7 | 41 | 6.00% | 56,308 | 5,631 | 1,689 | 3,229.30 | 59,588.16 | | 37,171 | 48,323 | | | | | | | | | 8 | 42 | 6.00% | 57,434 | 5,743 | 1,723 | 3,884.06 | 70,938.67 | | 42,915 | 55,789 | | | | | | | | | 9 | 43 | 6.00% | 58,583 | 5,858 | 1,757 | 4,588.31 | 83,142.77 | | 48,773 | 63,405 | | | | | | | | | 10 | 44 | 6.00% | 59,755 | 5,975 | 1,793 | 5,345.29 | 96,256.16 | | 54,749 | 71,173 | | | | | | | | | 11 | 45 | 6.00% | 60,950 | 6,095 | 1,828 | 6,158.44 | 110,338.06 | | 60,844 | 79,097 | | | | | | | | | 12 | 46 | 6.00% | 62,169 | 6,217 | 1,865 | 7,031.41 | 125,451.40 | | 67,060 | 87,179 | | | | | | | | | 13 | 47 | 6.00% | 63,412 | 6,341 | 1,902 | 7,968.09 | 141,663.06 | | 73,402 | 95,422 | | | | | | | | | 14 | 48 | 6.00% | 64,680 | 6,468 | 1,940 | 8,972.60 | 159,044.10 | | 79,870 | 103,831 | | | | | | | | | 15 | 49 | 6.00% | 65,974 | 6,597 | 1,979 | 10,049.32 | 177,670.03 | | 86,467 | 112,407 | | | | | | | | | 16 | 50 | 6.00% | 67,293 | 6,729 | 2,019 | 11,202.93 | 197,621.11 | | 93,196 | 121,155 | | | | | | | | | 17 | 51 | 6.00% | 68,639 | 6,864 | 2,059 | 12,438.36 | 218,982.57 | | 100,060 | 130,078 | | | | | | | | | 18 | 52 | 6.00% | 70,012 | 7,001 | 2,100 | 13,760.88 | 241,845.02 | | 107,062 | 139,180 | | | | | | | | | 19 | 53 | 6.00% | 71,412 | 7,141 | 2,142 | 15,176.07 | 266,304.69 | | 114,203 | 148,464 | | | | | | | | | 20 | 54 | 6.00% | 72,841 | 7,284 | 2,185 | 16,689.89 | 292,463.85 | | 121,487 | 157,933 | | | | | | | | | 21 | 55 | 6.00% | 74,297 | 7,430 | 2,229 | 18,308.62 | 320,431.13 | | 128,917 | 167,592 | | | | | | | | | 22 | 56 | 6.00% | 75,783 | 7,578 | 2,273 | 20,038.98 | 350,321.94 | | 136,495 | 177,443 | | | | | | | | | 23 | 57 | 6.00% | 77,299 | 7,730 | 2,319 | 21,888.09 | 382,258.90 | | 144,225 | 187,492 | | | | | | | | | 24 | 58 | 6.00% | 78,845 | 7,884 | 2,365 | 23,863.51 | 416,372.26 | | 152,109 | 197,742 | | | | | | | | | 25 | 59 | 6.00% | 80,422 | 8,042 | 2,413 | 25,973.28 | 452,800.39 | | 160,151 | 208,197 | | | | | | | | | 26 | 60 | 6.00% | 82,030 | 8,203 | 2,461 | 28,225.94 | 491,690.27 | | 168,355 | 218,861 | | | | | | | | | 27 | 61 | 6.00% | 83,671 | 8,367 | 2,510 | 30,630.55 | 533,198.03 | | 176,722 | 229,738 | | | | | | | | | 28 | 62 | 6.00% | 85,344 | 8,534 | 2,560 | 33,196.74 | 577,489.53 | | 185,256 | 240,833 | | | | | | | | | 29 | 63 | 6.00% | 87,051 | 8,705 | 2,612 | 35,934.74 | 624,740.93 | | 193,961 | 252,150 | | | | | | | | | 30 | 64 | 6.00% | 88,792 | 8,879 | 2,664 | 38,855.44 | 675,139.36 | | 202,840 | 263,693 | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | | #N/A | #N/A | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
