How Much Money Do I Need to Retire Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Optimize Your Retirement - How Much Money Do I Need To Retire?
Go To File - Make a Copy to create an editable copy you can use.
2
Test (do not change these columns - this is a math check)
3
AssumptionsInputs
Explanation
Year in RetirementAmount You Need To Retire (from PV formula)Year Income (with inflation)
4
Periodic payment $ 50,000 PMT
Annual Expenses in Retirement
1 $ 1,250,000 $ 50,000
5
Growth rate per period
4%g
Inflation Rate
2 1,248,000 52,000
6
Discount rate per period
4%i
Expected Return on Investment
3 1,243,840 54,080
7
Number of periods25n
Number of Years Spent in Retirement
4 1,237,351 56,243
8
5 1,228,352 58,493
9
Calculation6 1,216,653 60,833
10
Present Value $ 1,201,923 PV
ordinary annuity (amount to the left is for comparison)
7 1,202,054 63,266
11
Present Value $ 1,250,000 PV
annuity due (this is the amount you'll need prior to retiring)
8 1,184,339 65,797
12
Factor12.59 1,163,284 68,428
13
Multiplier25.010 1,138,650 71,166
14
11 1,110,184 74,012
15
Resources12 1,077,618 76,973
16
Personal CapitalThe first step in securing your financial future is to sign up with Personal Capital. It's a completely free tool that I recommend to everyone.13 1,040,672 80,052
17
LendingTreeI believe that retirees SHOULD carry a mortgage in retirement to optimize their finances. Make banks compete for your business so that you can get the best rate. 14 999,045 83,254
18
RealtySharesThe best real estate investment option in 2018. 15 952,423 86,584
19
16 900,472 90,047
20
17 842,842 93,649
21
18 779,161 97,395
22
For more information, you can email me at matt@optimizeyourretirement.com or see the associated post: 19 709,037 101,291
23
20 632,056 105,342
24
21 547,782 109,556
25
www.optimizeyourretirement.com/how-much-do-i-need-to-retire22 455,755 113,938
26
23 355,489 118,496
27
24 246,473 123,236
28
25 128,166 128,165
29
26 1 133,292
30
27 (138,622) 138,623
31
28 (288,336) 144,168
32
29 (449,804) 149,935
33
30 (623,729) 155,933
34
31 (810,848) 162,170
35
32 (1,011,939) 168,657
36
33 (1,227,819) 175,403
37
34 (1,459,351) 182,419
38
35 (1,707,441) 189,716
39
36 (1,973,043) 197,304
40
37 (2,257,161) 205,197
41
38 (2,560,852) 213,404
42
39 (2,885,227) 221,941
43
40 (3,231,454) 230,818
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
Loading...
 
 
 
PV of Annuity with Inflation
 
 
Main menu