Get documents about "401(k) Savings Calculator
Description
With this free 401k savings calculator for Excel from Spreadsheet123.com, you can estimate an amount that you could have for your retirement after investing for a number of years. http://www.spreadsheet123.com/ExcelTemplates/401k-savings-calculator.html
Document Sample
401(k) Savings Calculator
http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
© 2009 Spreadsheet123.com
Variables Summary & Results
Enter your current age: 30 Years to your retirement: 35
Enter your retirement age: 65
Salary Future Value
Enter your current annual salary: 70,000 Estimated value after 35 years: 1,455,674.29
Enter you annual salary increase: 2%
Your current savings or 401K balance: 10,000 Interest Earned after you are 65 for 20 year(s): 1,074,803
Contributions Total Contributions
Contributions To-Date: 5,000.00
Employer contributions To-Date: 1,500.00
Contribution as a % of your salary: 10.0% Your contributions: 354,961
Enter your annual contribution: 2,400 Employer contributions: 106,488
Increase contribution each year by: 5.0% Total contributed: 461,450
Employer match (% of contribution): 50%
Employer maximum (% of salary): 6.0%
Current annual limit of contributions 15,000
Contributions made: Monthly Number of contributions per year: 12
Return Rate (Interest) Variable Return Rate
Estimated annual rate of return: 6.0% Average Rate: 6.0%
Interest Rate: Fixed Min: -2.0%
Max: 9.0%
Press F9 to recalculate
Desired Retirement Income Estimated Income (Based on Desired Income & Current Salary)
Estimate the rate of inflation: 2.0%
Desired monthly income: 4,300 Your desired monthly income will start at: 8,599.53
Desired monthly income as a % of salary: 75% At retirement you will need: 2,507,350
Number of years to live on your savings: 20 Your Savings will last for 20 years and 1 month.
1,600,000
1,400,000
1,200,000
1,000,000 Your Contributions
800,000 Employer Match
600,000 Balance
400,000
All Contributions
200,000
0
30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
401(k) Savings Detailed
http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
© 2009 Spreadsheet123.com
Annual Your Contributions Employer Match Contributions Return Interest
Year Age Balance
Salary Additional Annual Cumulative Annual Cumulative Total Rate
5,000.00 1500 10000
1 30 70,000 7,000 12,000 2,100 3,600 9,100 6% 19,971.25 871.25
2 31 71,400 7,140 19,140 2,142 5,742 16,240 6% 30,744.59 1,491.34
3 32 72,828 7,283 26,423 2,185 7,927 23,523 6% 42,373.23 2,161.01
4 33 74,285 7,428 33,851 2,229 10,155 30,951 6% 54,913.76 2,883.53
5 34 75,770 7,577 41,428 2,273 12,428 38,528 6% 68,426.30 3,662.40
6 35 77,286 7,729 49,157 2,319 14,747 46,257 6% 82,974.77 4,501.34
7 36 78,831 7,883 57,040 2,365 17,112 54,140 6% 98,627.12 5,404.27
8 37 80,408 8,041 65,081 2,412 19,524 62,181 6% 115,455.57 6,375.41
9 38 82,016 8,202 73,282 2,460 21,985 70,382 6% 133,536.87 7,419.20
10 39 83,656 8,366 81,648 2,510 24,494 78,748 6% 152,952.58 8,540.37
11 40 85,330 8,533 90,181 2,560 27,054 87,281 6% 173,789.41 9,743.98
12 41 87,036 8,704 98,885 2,611 29,665 95,985 6% 196,139.47 11,035.35
13 42 88,777 8,878 107,762 2,663 32,329 104,862 6% 220,100.65 12,420.18
14 43 90,552 9,055 116,818 2,717 35,045 113,918 6% 245,776.97 13,904.51
15 44 92,364 9,236 126,054 2,771 37,816 123,154 6% 273,278.98 15,494.75
16 45 94,211 9,421 135,475 2,826 40,642 132,575 6% 302,724.12 17,197.73
17 46 96,095 9,609 145,084 2,883 43,525 142,184 6% 334,237.16 19,020.69
18 47 98,017 9,802 154,886 2,941 46,466 151,986 6% 367,950.69 20,971.33
19 48 99,977 9,998 164,884 2,999 49,465 161,984 6% 404,005.56 23,057.84
20 49 101,977 10,198 175,082 3,059 52,524 172,182 6% 442,551.44 25,288.89
21 50 104,016 10,402 185,483 3,120 55,645 182,583 6% 483,747.29 27,673.73
22 51 106,097 10,610 196,093 3,183 58,828 193,193 6% 527,762.02 30,222.16
23 52 108,219 10,822 206,915 3,247 62,074 204,015 6% 574,775.04 32,944.61
24 53 110,383 11,038 217,953 3,311 65,386 215,053 6% 624,976.96 35,852.14
25 54 112,591 11,259 229,212 3,378 68,764 226,312 6% 678,570.25 38,956.51
26 55 114,842 11,484 240,696 3,445 72,209 237,796 6% 735,769.97 42,270.21
27 56 117,139 11,714 252,410 3,514 75,723 249,510 6% 796,804.59 45,806.51
28 57 119,482 11,948 264,358 3,584 79,308 261,458 6% 861,916.77 49,579.51
29 58 121,872 12,187 276,546 3,656 82,964 273,646 6% 931,364.26 53,604.18
30 59 124,309 12,431 288,977 3,729 86,693 286,077 6% 1,005,420.86 57,896.41
31 60 126,795 12,680 301,656 3,804 90,497 298,756 6% 1,084,377.34 62,473.09
32 61 129,331 12,933 314,589 3,880 94,377 311,689 6% 1,168,542.57 67,352.17
33 62 131,918 13,192 327,781 3,958 98,334 324,881 6% 1,258,244.59 72,552.70
34 63 134,556 13,456 341,237 4,037 102,371 338,337 6% 1,353,831.82 78,094.92
35 64 137,247 13,725 354,961 4,117 106,488 352,061 6% 1,455,674.29 84,000.31
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
Desired Income
Annuity Calculator
http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
© 2009 Spreadsheet123.com
Years of 401K Savings Desired Annual Return Return on Investment
Age Balance
Retirement Balance Income Rate
1 65 1,455,674.29 103,194.30 6.0% 83,418.01 1,435,897.99
2 66 1,435,897.99 105,258.19 6.0% 82,070.95 1,412,710.75
3 67 1,412,710.75 107,363.35 6.0% 80,510.97 1,385,858.38
4 68 1,385,858.38 109,510.62 6.0% 78,722.34 1,355,070.09
5 69 1,355,070.09 111,700.83 6.0% 76,688.30 1,320,057.56
6 70 1,320,057.56 113,934.85 6.0% 74,391.01 1,280,513.72
7 71 1,280,513.72 116,213.54 6.0% 71,811.49 1,236,111.67
8 72 1,236,111.67 118,537.81 6.0% 68,929.51 1,186,503.36
9 73 1,186,503.36 120,908.57 6.0% 65,723.56 1,131,318.35
10 74 1,131,318.35 123,326.74 6.0% 62,170.72 1,070,162.32
11 75 1,070,162.32 125,793.28 6.0% 58,246.62 1,002,615.66
12 76 1,002,615.66 128,309.14 6.0% 53,925.31 928,231.83
13 77 928,231.83 130,875.33 6.0% 49,179.20 846,535.71
14 78 846,535.71 133,492.83 6.0% 43,978.92 757,021.80
15 79 757,021.80 136,162.69 6.0% 38,293.23 659,152.35
16 80 659,152.35 138,885.94 6.0% 32,088.89 552,355.30
17 81 552,355.30 141,663.66 6.0% 25,330.56 436,022.20
18 82 436,022.20 144,496.93 6.0% 17,980.64 309,505.90
19 83 309,505.90 147,386.87 6.0% 9,999.15 172,118.18
20 84 172,118.18 150,334.61 6.0% 1,343.56 23,127.13
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
#N/A #N/A #N/A #N/A #N/A #N/A #N/A
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
401K Balance
http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
© 2009 Spreadsheet123.com
Your Age: 35
Your Annual Salary: 77,286
90,000
Your contributions this year: 7,729
80,000
Cumulative Contributions To-Date: 49,157 70,000
Employer Match this year: 2,319 60,000
Employer Contributions To-Date: 14,747 50,000
40,000
401k Balance: 82,975 30,000
20,000
10,000
Average Return Rate: 6% 0
Interest Earned: 4,501.34
30 31 32 33 34 35
Your Contributions
Employer Contributions
401k Balance
© 2009 Spreadsheet123.com 401k Saving Calculator by Spreadsheet123
401(k) Savings Calculator EULA
http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
© 2009 Spreadsheet123.com
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that
covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) and software ("SOFTWARE") made
by Spreadsheet123.com.
By downloading, copying, accessing or otherwise using any TEMPLATES or/and SOFTWARE, you agree to be bound by the
terms of this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual
property laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
This EULA grants you the right to download the TEMPLATES free of charge for personal use only.
You may customize this TEMPLATE with you personal information and use for its intended purpose in personal calculations
documentation or/and communications, but you may not remove or alter any logo, trademark, copyright, hyperlinks,
disclaimers, terms of use or other proprietary notices within this TEMPLATE.
You may not sell, resell, license, rent, lease, lend or otherwise transfer for value without written
permission of SPREADSHEET123.COM
You may not distribute the TEMPLATE in any stand-alone products that contain only the TEMPLATES, or as part of any other
product. You may not copy or post any TEMPLATE on any network computer or broadcast it in any media without
written permission of SPREADSHEET123.COM.
2. RESERVATION OF RIGHTS.
All title and copyrights in and to the Templates, and any copies of the Templates, are owned by Spreadsheet123.com.
All rights not expressly granted are reserved by Spreadsheet123.com. In particular, this EULA does not grant you any
rights in connection with any trademarks or service marks ofSpreadsheet123.com. Use of any Template for any purpose
other than expressly permitted in this EULA is prohibited, and may result in severe civil and criminal penalties.
3. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the
terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
4. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS
ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED
“AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL
WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED
WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE
AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,
INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS
OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
ANY REFERENCES TO EVENTS, PEOPLE, PLACES, OR ENTITIES IN THE TEMPLATES IS PURELY FICTITIOUS AND NOT INTENDED TO REPRESENT ANY ACTUAL EVENT,
PERSON, PLACE, OR ENTITY. SPREADSHEET123.COM DISCLAIMS ANY LIKENESS OR SIMILARITIES TO ACTUAL EVENTS, PEOPLE, PLACES, OR ENTITIES, AND
ANY SUCH LIKENESS OR SIMILARITIES ARE UNINTENTIONAL AND PURELY COINCIDENTAL.
5. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential
damages, so the above limitation may not apply to you.
© 2009 Spreadsheet123.com http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
Disclaimer: This template is for
educational purposes only. We
do not guarantee the results.
Use this template at your own
risk. You should seek the advice
of qualified professionals
regarding your 401k savings
plan.
401k Estimator
401k Detailed
Desired Income
401k Balance
EULA
Help
F A Q's
© 2009 Spreadsheet123.com http://www.spreadsheet123.com/ExcelTemplates/401k-saving-calculator.html
