Docstoc

401k Calculator

Document Sample
401k Calculator Powered By Docstoc
					401(k) Calculator
Current Annual Income Exp'd Annual Salary Increase Current Balance Your Contr. up to now Employer's Contr. up to now Withheld Salary for 401k 40,000 3.00 0 0.00 0.00 6.00 % % Employer Match up to Current Age Retirement Age Avg. Annual Interest Rate Payments per Year 6.00 50.00 % of salary 25 40 7.00 1 % %

Year

Beginning Balance
0.00 3,600.00 7,560.00 11,908.44 16,675.85 21,894.99 27,601.02 33,831.68 40,627.45 48,031.74 56,091.15 64,855.63 74,378.76 84,718.02 95,935.00

Salary
40,000.00 41,200.00 42,436.00 43,709.08 45,020.35 46,370.96 47,762.09 49,194.95 50,670.80 52,190.93 53,756.66 55,369.35 57,030.44 58,741.35 60,503.59

Your Contributions
2,400.00 2,472.00 2,546.16 2,622.54 2,701.22 2,782.26 2,865.73 2,951.70 3,040.25 3,131.46 3,225.40 3,322.16 3,421.83 3,524.48 3,630.22

Employer 's Contributions
1,200.00 1,236.00 1,273.08 1,311.27 1,350.61 1,391.13 1,432.86 1,475.85 1,520.12 1,565.73 1,612.70 1,661.08 1,710.91 1,762.24 1,815.11

Interest Earnings
0.00 252.00 529.20 833.59 1,167.31 1,532.65 1,932.07 2,368.22 2,843.92 3,362.22 3,926.38 4,539.89 5,206.51 5,930.26 6,715.45

Ending Balance
3,600.00 7,560.00 11,908.44 16,675.85 21,894.99 27,601.02 33,831.68 40,627.45 48,031.74 56,091.15 64,855.63 74,378.76 84,718.02 95,935.00 108,095.77

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

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

Calculator
Contribution Your Up to now Coming 15 yrs Final Interest Earnings Final Balance 0 44,637 44,637 41,140 108,096 Employer 0 22,319 22,319 Total 0 66,956 66,956

Cumulative Contributions to Balance

50,000 40,000 30,000
20,000 10,000

Your

Employer's

Interest

0 1 3 4 6 7 9 10 12 13 15

Balance Distribution

Your Interest 41% 38%

Employer's 21%

Yearly Balance Growth

120000

100000 80000 60000 40000
20000

0 1 3 4 6 7 9 10 12 13 15

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Your 2,400.00 4,872.00 7,418.16 10,040.70 12,741.93 15,524.18 18,389.91 21,341.61 24,381.85 27,513.31 30,738.71 34,060.87 37,482.70 41,007.18 44,637.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Employer Interest Total 1,200.00 0.00 3600 2,436.00 252.00 7560 3,709.08 781.20 11908.44 5,020.35 1,614.79 16675.848 6,370.96 2,782.10 21894.98908 7,762.09 4,314.75 27601.02498 9,194.95 6,246.82 33831.68499 10,670.80 8,615.04 40627.44886 12,190.93 11,458.96 48031.74257 13,756.66 14,821.18 56091.14802 15,369.35 18,747.56 64855.62734 17,030.44 23,287.46 74378.76319 18,741.35 28,493.97 84718.01581 20,503.59 34,424.23 95934.99828 22,318.70 41,139.68 108095.7712 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0.00 0

15 0 2 3 4 5 6 7 8 9 10

1 3 4 6 7 9 10 12 13 15

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Your 2,400 7,418 10,041 15,524 18,390 24,382 27,513 34,061 37,483 44,637

Employer's Interest 1,200 0.00 3,709 781 5,020 1,615 7,762 4,315 9,195 6,247 12,191 11,459 13,757 14,821 17,030 23,287 18,741 28,494 22,319 41,140

Total 1 3 4 6 7 9 10 12 13 15 3600 11,908 16,676 27,601 33,832 48,032 56,091 74,379 84,718 108,096

Your Employer's Interest

44,637 22,319 41,140

Follow the steps to enable your online 401(k) Calculator.
>> 1) Your 401(k) Calculator is ready to use, following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your online calculator. 2) Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. 3) >> >> Click "Add Web Application" to upload this file. Your online dashboard will be created automatically. You can simply use the calculator from that link or place it on your website. Your online calculator will look like: https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=eb01d31e-c3fb-4f19-8949-0e676147cfa3 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

19-8949-0e676147cfa3


				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:727
posted:5/25/2009
language:English
pages:11
Description: This calculator quickly simulates the future 401k savings and displays yearly values of Balance, Your Conrtributions, Employer's Contributions and Interest Earnings. The quick analysis of the distribution of contributions the growth of the balance over years is carried out. The Excel template also contains the necessary code for SpreadsheetWEB. Hence, the calculator can be placed on the web via SpreadsheetWEB, without the necessity of programming experience.