Get documents about "Retirement Savings Calculator
W
Description
Retirement Savings Calculator for Excel. Use this calculator to compare different savings plan offers and to estimate the future value of your savings.
Shared by: spreadsheet123
Categories
Tags
Retirement Savings Calculator, retirement savings, Retirement calculator, Retirement Planning, retirement income, Savings Calculator, rate of return, Retirement Calculators, financial calculators, retirement accounts, Retirement Planner, FREE Retirement, Personal Finance, retirement planning calculator,
-
Stats
- views:
- 510
- posted:
- 8/1/2010
- language:
- English
- pages:
- 4
Document Sample
Retirement Savings Plan
http://www.spreadsheet123.com/ExcelTemplates/retirement-savings-calculator.html
© 2010 Spreadsheet123.com
Savings Plan Entries Summary & Results
Current Age: 30 Years to Retirement: 35
Retirement Age: 65
Total Invested Interest Earned Future Value
Lump Sum: 20,000 Savings Plan 1 80,000.0 159,807.7 239,807.7
Savings Plan 2 80,000.0 338,198.2 418,198.2
Annual Deposit: 3,000 Savings Plan 3 80,000.0 236,545.5 316,545.5
Years to Pay: 20
Annual Return Rate Future Value
Savings Plan 1 4% Savings Plan 3
Savings Plan 2 6%
Savings Plan 3 5% Savings Plan 2
Savings Plan 1
Annual Table: Show
Thousands
0.0 100.0 200.0 300.0 400.0 500.0
Total Invested Interest Earned
Balance Interest
450,000.0 400,000.0
400,000.0 350,000.0
350,000.0 300,000.0
300,000.0 250,000.0
250,000.0
200,000.0
200,000.0
150,000.0
150,000.0
100,000.0 100,000.0
50,000.0 50,000.0
0.0 0.0
0 10 20 30 40 0 10 20 30 40
Savings Plan 1 Savings Plan 2 Savings Plan 3 Deposits
© 2010 Spreadsheet123.com. All rights reserved http://www.spreadsheet123.com/ExcelTemplates/retirement-savings-calculator.html
Savings Plan 1 Savings Plan 2 Savings Plan 3
Cumulative Cumulative Cumulative Cumulative
Year Deposits Interest Balance Interest Balance Interest Balance
Deposits Interest Interest Interest
20000 20000 20,000.0 20,000.0 20,000.0
1 3000 23000 800.0 800.0 23,800.0 1,200.0 1,200.0 24,200.0 1,000.0 1,000.0 24,000.0
2 3000 26000 952.0 1,752.0 27,752.0 1,452.0 2,652.0 28,652.0 1,200.0 2,200.0 28,200.0
3 3000 29000 1,110.1 2,862.1 31,862.1 1,719.1 4,371.1 33,371.1 1,410.0 3,610.0 32,610.0
4 3000 32000 1,274.5 4,136.6 36,136.6 2,002.3 6,373.4 38,373.4 1,630.5 5,240.5 37,240.5
5 3000 35000 1,445.5 5,582.0 40,582.0 2,302.4 8,675.8 43,675.8 1,862.0 7,102.5 42,102.5
6 3000 38000 1,623.3 7,205.3 45,205.3 2,620.5 11,296.3 49,296.3 2,105.1 9,207.7 47,207.7
7 3000 41000 1,808.2 9,013.5 50,013.5 2,957.8 14,254.1 55,254.1 2,360.4 11,568.0 52,568.0
8 3000 44000 2,000.5 11,014.1 55,014.1 3,315.2 17,569.4 61,569.4 2,628.4 14,196.4 58,196.4
9 3000 47000 2,200.6 13,214.6 60,214.6 3,694.2 21,263.5 68,263.5 2,909.8 17,106.3 64,106.3
10 3000 50000 2,408.6 15,623.2 65,623.2 4,095.8 25,359.3 75,359.3 3,205.3 20,311.6 70,311.6
11 3000 53000 2,624.9 18,248.1 71,248.1 4,521.6 29,880.9 82,880.9 3,515.6 23,827.1 76,827.1
12 3000 56000 2,849.9 21,098.1 77,098.1 4,972.9 34,853.8 90,853.8 3,841.4 27,668.5 83,668.5
13 3000 59000 3,083.9 24,182.0 83,182.0 5,451.2 40,305.0 99,305.0 4,183.4 31,851.9 90,851.9
14 3000 62000 3,327.3 27,509.3 89,509.3 5,958.3 46,263.3 108,263.3 4,542.6 36,394.5 98,394.5
15 3000 65000 3,580.4 31,089.6 96,089.6 6,495.8 52,759.1 117,759.1 4,919.7 41,314.3 106,314.3
16 3000 68000 3,843.6 34,933.2 102,933.2 7,065.5 59,824.6 127,824.6 5,315.7 46,630.0 114,630.0
17 3000 71000 4,117.3 39,050.5 110,050.5 7,669.5 67,494.1 138,494.1 5,731.5 52,361.5 123,361.5
18 3000 74000 4,402.0 43,452.6 117,452.6 8,309.6 75,803.7 149,803.7 6,168.1 58,529.5 132,529.5
19 3000 77000 4,698.1 48,150.7 125,150.7 8,988.2 84,792.0 161,792.0 6,626.5 65,156.0 142,156.0
20 3000 80000 5,006.0 53,156.7 133,156.7 9,707.5 94,499.5 174,499.5 7,107.8 72,263.8 152,263.8
21 0 80000 5,326.3 58,483.0 138,483.0 10,470.0 104,969.5 184,969.5 7,613.2 79,877.0 159,877.0
22 0 80000 5,539.3 64,022.3 144,022.3 11,098.2 116,067.6 196,067.6 7,993.9 87,870.9 167,870.9
23 0 80000 5,760.9 69,783.2 149,783.2 11,764.1 127,831.7 207,831.7 8,393.5 96,264.4 176,264.4
24 0 80000 5,991.3 75,774.5 155,774.5 12,469.9 140,301.6 220,301.6 8,813.2 105,077.6 185,077.6
25 0 80000 6,231.0 82,005.5 162,005.5 13,218.1 153,519.7 233,519.7 9,253.9 114,331.5 194,331.5
26 0 80000 6,480.2 88,485.7 168,485.7 14,011.2 167,530.9 247,530.9 9,716.6 124,048.1 204,048.1
27 0 80000 6,739.4 95,225.1 175,225.1 14,851.9 182,382.7 262,382.7 10,202.4 134,250.5 214,250.5
28 0 80000 7,009.0 102,234.1 182,234.1 15,743.0 198,125.7 278,125.7 10,712.5 144,963.0 224,963.0
29 0 80000 7,289.4 109,523.5 189,523.5 16,687.5 214,813.2 294,813.2 11,248.2 156,211.2 236,211.2
30 0 80000 7,580.9 117,104.4 197,104.4 17,688.8 232,502.0 312,502.0 11,810.6 168,021.7 248,021.7
31 0 80000 7,884.2 124,988.6 204,988.6 18,750.1 251,252.1 331,252.1 12,401.1 180,422.8 260,422.8
32 0 80000 8,199.5 133,188.2 213,188.2 19,875.1 271,127.2 351,127.2 13,021.1 193,443.9 273,443.9
33 0 80000 8,527.5 141,715.7 221,715.7 21,067.6 292,194.9 372,194.9 13,672.2 207,116.1 287,116.1
34 0 80000 8,868.6 150,584.3 230,584.3 22,331.7 314,526.6 394,526.6 14,355.8 221,471.9 301,471.9
35 0 80000 9,223.4 159,807.7 239,807.7 23,671.6 338,198.2 418,198.2 15,073.6 236,545.5 316,545.5
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
© 2010 Spreadsheet123.com. All rights reserved http://www.spreadsheet123.com/ExcelTemplates/retirement-savings-calculator.html
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
© 2010 Spreadsheet123.com. All rights reserved http://www.spreadsheet123.com/ExcelTemplates/retirement-savings-calculator.html
Retirement Savings Plan EULA
http://www.spreadsheet123.com/ExcelTemplates/retirement-savings-calculator.html
© 2010 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.
amages, so the above limitation may not apply to you.
