Retirement Calculator

Plan Information Retirement Needs

Current Age 25 Salary During Retirement (in today's dollars) 50,000
Age at Retirement 65 Inflation-Adjusted Salary at Retirement 163,102
Years to Pay Out After Retire. 25 Total Needed to Fund 100% of Retirement 4,077,547
Years to Invest Before Retire. 40
Current Retirement Savings
Rates and Inflation Current Retirement Savings Balance 20,000
Return Before Retirement 6.00% Value of Current Savings at Retirement 205,714
Return After Retirement 3.00% Value of Current Contributions at Retirement 1,312,623
Annual Inflation 3.00%
Other Retirement Income
Salary Age When Income Begins 65
Current Annual Salary 50,000 Initial Annual Amount 0
Annual Increase in Salary 2.00% Annual Increase 2.80%
Years of Retirement Income 25
Current Savings Contributions Value of Other Income at Retirement 0
% of Salary Saved 10.00%
Employer 401(k) Match 100.00% Other Assets (Lump-sum Pension, Sellable Real Estate)
Max Employee % Contribution 3.00% Value of Other Assets at Retirement 0
My Annual Contribution 5,000 .
Employer's Annual Contribution 1,500 Shortfall at Retirement 2,559,210
Total Annual Contribution 6,500 Years Payout Will Last Without Additional Savings 9.3
. Additional Annual Savings Needed 12,673
Total % of Salary to Save to Reach Goal 35.35%

$4,500,000
Retirement Savings Balance
$4,000,000
$3,500,000 Goal: Saving 35.35% of Salary
$3,000,000
$2,500,000 Current: Saving 10% of Salary
$2,000,000
$1,500,000
$1,000,000
$500,000 Series 1 Goal: Saving 35.35% of Salary
Series 2 Current: Saving 10% of Salary
$-
Payments
$(500,000) 20 Per Year
30 1
40 50 60 70 80 90 100
Withdrawal Payment Type 1
Age
Table Based on 35.35% Salary Contribution Scenario Note: Results are only estimates!
Salary Annual Employer Retirement Payout Est. Inv.
Year Age Return Basis Contribution Match Income (Withdrawal) Return Balance
$ 20,000.00
1 25 6.00% 50,000 17,673 1,500 0 0 1,200.00 40,373.00
2 26 6.00% 51,000 18,026 1,530 0 0 2,422.38 62,351.84
3 27 6.00% 52,020 18,387 1,561 0 0 3,741.11 86,040.54
4 28 6.00% 53,060 18,755 1,592 0 0 5,162.43 111,549.51
5 29 6.00% 54,122 19,130 1,624 0 0 6,692.97 138,995.95
6 30 6.00% 55,204 19,512 1,656 0 0 8,339.76 168,504.24
7 31 6.00% 56,308 19,903 1,689 0 0 10,110.25 200,206.41
8 32 6.00% 57,434 20,301 1,723 0 0 12,012.38 234,242.54
9 33 6.00% 58,583 20,707 1,757 0 0 14,054.55 270,761.32
10 34 6.00% 59,755 21,121 1,793 0 0 16,245.68 309,920.51
11 35 6.00% 60,950 21,543 1,828 0 0 18,595.23 351,887.52
 Salary Annual Employer Retirement Payout Est. Inv.
Year Age Return Basis Contribution Match Income (Withdrawal) Return Balance
12 36 6.00% 62,169 21,974 1,865 0 0 21,113.25 396,839.98
13 37 6.00% 63,412 22,414 1,902 0 0 23,810.40 444,966.38
14 38 6.00% 64,680 22,862 1,940 0 0 26,697.98 496,466.68
15 39 6.00% 65,974 23,319 1,979 0 0 29,788.00 551,553.05
16 40 6.00% 67,293 23,786 2,019 0 0 33,093.18 610,450.56
17 41 6.00% 68,639 24,261 2,059 0 0 36,627.03 673,398.01
18 42 6.00% 70,012 24,746 2,100 0 0 40,403.88 740,648.72
19 43 6.00% 71,412 25,241 2,142 0 0 44,438.92 812,471.41
20 44 6.00% 72,841 25,746 2,185 0 0 48,748.28 889,151.13
21 45 6.00% 74,297 26,261 2,229 0 0 53,349.07 970,990.26
22 46 6.00% 75,783 26,786 2,273 0 0 58,259.42 1,058,309.55
23 47 6.00% 77,299 27,322 2,319 0 0 63,498.57 1,151,449.19
24 48 6.00% 78,845 27,869 2,365 0 0 69,086.95 1,250,770.03
25 49 6.00% 80,422 28,426 2,413 0 0 75,046.20 1,356,654.79
26 50 6.00% 82,030 28,994 2,461 0 0 81,399.29 1,469,509.42
27 51 6.00% 83,671 29,574 2,510 0 0 88,170.57 1,589,764.43
28 52 6.00% 85,344 30,166 2,560 0 0 95,385.87 1,717,876.43
29 53 6.00% 87,051 30,769 2,612 0 0 103,072.59 1,854,329.67
30 54 6.00% 88,792 31,385 2,664 0 0 111,259.78 1,999,637.71
31 55 6.00% 90,568 32,012 2,717 0 0 119,978.26 2,154,345.21
32 56 6.00% 92,379 32,652 2,771 0 0 129,260.71 2,319,029.74
33 57 6.00% 94,227 33,305 2,827 0 0 139,141.78 2,494,303.82
34 58 6.00% 96,112 33,972 2,883 0 0 149,658.23 2,680,816.99
35 59 6.00% 98,034 34,651 2,941 0 0 160,849.02 2,879,258.05
36 60 6.00% 99,994 35,344 3,000 0 0 172,755.48 3,090,357.41
37 61 6.00% 101,994 36,051 3,060 0 0 185,421.44 3,314,889.61
38 62 6.00% 104,034 36,772 3,121 0 0 198,893.38 3,553,675.96
39 63 6.00% 106,115 37,507 3,183 0 0 213,220.56 3,807,587.35
40 64 6.00% 108,237 38,258 3,247 0 0 228,455.24 4,077,547.24
41 65 3.00% 163,102 0 0 0 163,102 117,433.36 4,031,878.71
42 66 3.00% 167,995 0 0 0 167,995 115,916.51 3,979,800.28
43 67 3.00% 173,035 0 0 0 173,035 114,202.96 3,920,968.45
44 68 3.00% 178,226 0 0 0 178,226 112,282.28 3,855,024.89
45 69 3.00% 183,573 0 0 0 183,573 110,143.57 3,781,595.84
46 70 3.00% 189,080 0 0 0 189,080 107,775.48 3,700,291.53
47 71 3.00% 194,752 0 0 0 194,752 105,166.18 3,610,705.53
48 72 3.00% 200,595 0 0 0 200,595 102,303.32 3,512,414.10
49 73 3.00% 206,613 0 0 0 206,613 99,174.05 3,404,975.55
50 74 3.00% 212,811 0 0 0 212,811 95,764.94 3,287,929.51
51 75 3.00% 219,195 0 0 0 219,195 92,062.03 3,160,796.24
52 76 3.00% 225,771 0 0 0 225,771 88,050.75 3,023,075.83
53 77 3.00% 232,544 0 0 0 232,544 83,715.95 2,874,247.48
54 78 3.00% 239,521 0 0 0 239,521 79,041.81 2,713,768.67
55 79 3.00% 246,706 0 0 0 246,706 74,011.87 2,541,074.30
56 80 3.00% 254,107 0 0 0 254,107 68,609.01 2,355,575.87
57 81 3.00% 261,731 0 0 0 261,731 62,815.36 2,156,660.58
58 82 3.00% 269,583 0 0 0 269,583 56,612.34 1,943,690.34
59 83 3.00% 277,670 0 0 0 277,670 49,980.61 1,716,000.90
60 84 3.00% 286,000 0 0 0 286,000 42,900.02 1,472,900.78
61 85 3.00% 294,580 0 0 0 294,580 35,349.62 1,213,670.24
62 86 3.00% 303,418 0 0 0 303,418 27,307.58 937,560.26
63 87 3.00% 312,520 0 0 0 312,520 18,751.21 643,791.38
64 88 3.00% 321,896 0 0 0 321,896 9,656.87 331,552.56
65 89 3.00% 331,553 0 0 0 331,553 0.00 0.00
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
 Salary Annual Employer Retirement Payout Est. Inv.
Year Age Return Basis Contribution Match Income (Withdrawal) Return Balance
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

Table Based on 10.00% Salary Contribution Scenario Note: Results are only estimates!
Salary Annual Employer Retirement Payout Interest
Year Age Return Basis Contribution Match Income (Withdrawal) Earned Balance
$ 20,000.00
1 25 6.00% 50,000 5,000 1,500 0 0 1,200.00 27,700.00
2 26 6.00% 51,000 5,100 1,530 0 0 1,662.00 35,992.00
3 27 6.00% 52,020 5,202 1,561 0 0 2,159.52 44,914.12
4 28 6.00% 53,060 5,306 1,592 0 0 2,694.85 54,506.82
5 29 6.00% 54,122 5,412 1,624 0 0 3,270.41 64,813.04
6 30 6.00% 55,204 5,520 1,656 0 0 3,888.78 75,878.34
7 31 6.00% 56,308 5,631 1,689 0 0 4,552.70 87,751.10
8 32 6.00% 57,434 5,743 1,723 0 0 5,265.07 100,482.62
9 33 6.00% 58,583 5,858 1,757 0 0 6,028.96 114,127.37
10 34 6.00% 59,755 5,975 1,793 0 0 6,847.64 128,743.11
11 35 6.00% 60,950 6,095 1,828 0 0 7,724.59 144,391.16
12 36 6.00% 62,169 6,217 1,865 0 0 8,663.47 161,136.56
13 37 6.00% 63,412 6,341 1,902 0 0 9,668.19 179,048.33
14 38 6.00% 64,680 6,468 1,940 0 0 10,742.90 198,199.67
15 39 6.00% 65,974 6,597 1,979 0 0 11,891.98 218,668.27
16 40 6.00% 67,293 6,729 2,019 0 0 13,120.10 240,536.51
17 41 6.00% 68,639 6,864 2,059 0 0 14,432.19 263,891.80
18 42 6.00% 70,012 7,001 2,100 0 0 15,833.51 288,826.88
19 43 6.00% 71,412 7,141 2,142 0 0 17,329.61 315,440.09
20 44 6.00% 72,841 7,284 2,185 0 0 18,926.41 343,835.77
21 45 6.00% 74,297 7,430 2,229 0 0 20,630.15 374,124.58
22 46 6.00% 75,783 7,578 2,273 0 0 22,447.47 406,423.88
23 47 6.00% 77,299 7,730 2,319 0 0 24,385.43 440,858.18
24 48 6.00% 78,845 7,884 2,365 0 0 26,451.49 477,559.52
25 49 6.00% 80,422 8,042 2,413 0 0 28,653.57 516,667.93
26 50 6.00% 82,030 8,203 2,461 0 0 31,000.08 558,331.95
27 51 6.00% 83,671 8,367 2,510 0 0 33,499.92 602,709.08
28 52 6.00% 85,344 8,534 2,560 0 0 36,162.54 649,966.39
29 53 6.00% 87,051 8,705 2,612 0 0 38,997.98 700,281.03
30 54 6.00% 88,792 8,879 2,664 0 0 42,016.86 753,840.88
31 55 6.00% 90,568 9,057 2,717 0 0 45,230.45 810,845.18
32 56 6.00% 92,379 9,238 2,771 0 0 48,650.71 871,505.22
33 57 6.00% 94,227 9,423 2,827 0 0 52,290.31 936,045.05
34 58 6.00% 96,112 9,611 2,883 0 0 56,162.70 1,004,702.26
35 59 6.00% 98,034 9,803 2,941 0 0 60,282.14 1,077,728.79
36 60 6.00% 99,994 9,999 3,000 0 0 64,663.73 1,155,391.80
37 61 6.00% 101,994 10,199 3,060 0 0 69,323.51 1,237,974.57
38 62 6.00% 104,034 10,403 3,121 0 0 74,278.47 1,325,777.50
39 63 6.00% 106,115 10,611 3,183 0 0 79,546.65 1,419,119.09
40 64 6.00% 108,237 10,824 3,247 0 0 85,147.15 1,518,337.08
41 65 3.00% 163,102 0 0 0 163,102 40,657.06 1,395,892.24
42 66 3.00% 167,995 0 0 0 167,995 36,836.92 1,264,734.22
43 67 3.00% 173,035 0 0 0 173,035 32,750.98 1,124,450.40
44 68 3.00% 178,226 0 0 0 178,226 28,386.74 974,611.30
45 69 3.00% 183,573 0 0 0 183,573 23,731.16 814,769.85
46 70 3.00% 189,080 0 0 0 189,080 18,770.70 644,460.76
47 71 3.00% 194,752 0 0 0 194,752 13,491.26 463,199.83
 Salary Annual Employer Retirement Payout Est. Inv.
Year Age Return Basis Contribution Match Income (Withdrawal) Return Balance
48 72 3.00% 200,595 0 0 0 200,595 7,878.15 270,483.23
49 73 3.00% 206,613 0 0 0 206,613 1,916.12 65,786.76
50 74 3.00% 212,811 0 0 0 212,811 -4,410.73 -151,434.94
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
HELP
https://www.vertex42.com/Calculators/retirement-calculator.html

About this Template

This calculator is designed to estimate how much of your salary you may need to
contribute towards savings to meet your retirement goal. It was designed based
on combining a 401(k) savings calculator with a retirement withdrawal calculator.

Caution: There are a large number of assumptions and estimations made by

this calculator, so be careful how you use and interpret the results. For example,
it does not take into account current debt, taxes, large future expenses or
disasters, etc.

Due to the complexity of retirement planning, you may need to seek help from a
certified professional to understand how a calculator like this works and its
limitations.

Instructions
Only edit the cells with the light gray border.

Read the cell comments to learn more about some of the inputs and outputs.

Additional Help
The link at the top of this worksheet will take you to the web page on
vertex42.com that talks about this template.

Related Templates and Resources

► Home Mortgage Calculator

► 401(k) Savings Calculator

► Retirement Withdrawal Calculator

► Money Management Template

► More Financial Calculators

© 2015-2020 Vertex42 LLC
Retirement Calculator

By Vertex42.com
https://www.vertex42.com/Calculators/retirement-calculator.html

© 2015-2020 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a

copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or

online template gallery.

Please review the following license agreement to learn how you may or
may not use this template. Thank you.

License Agreement
https://www.vertex42.com/licensing/EULA_personaluse.html

Do not delete this worksheet