ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Principal Investment ($)
Interest on principal
2
1250000
*This calculation assumes that you begin retirement
3
20000
with $1,250,000, which generates 2% interest per year,
4
1240000
and you spend $30,000 per year so you'll need to withdraw
5
19840
the difference between $30,000 and the amount in
6
1229840
Column B from the principal.
7
19677.44
8
1219517.44
This rough calculation tells you how long your principal
9
19512.27904
will last if nothing changes. See F145 for final number.
10
1209029.719
11
19344.4755
12
1198374.195
13
19173.98711
14
1187548.182
15
19000.77091
16
1176548.953
17
18824.78324
18
1165373.736
19
18645.97977
20
1154019.716
21
18464.31545
22
1142484.031
23
18279.7445
24
1130763.776
25
18092.22041
26
1118855.996
27
17901.69593
28
1106757.692
29
17708.12307
30
1094465.815
31
17511.45304
32
1081977.268
33
17311.63629
34
1069288.904
35
17108.62247
36
1056397.527
37
16902.36043
38
1043299.887
39
16692.79819
40
1029992.685
41
16479.88297
42
1016472.568
43
16263.56109
44
1002736.129
45
16043.77807
46
988779.9075
47
15820.47852
48
974600.386
49
15593.60618
50
960193.9922
51
15363.10387
52
945557.0961
53
15128.91354
54
930686.0096
55
14890.97615
56
915576.9857
57
14649.23177
58
900226.2175
59
14403.61948
60
884629.837
61
14154.07739
62
868783.9144
63
13900.54263
64
852684.457
65
13642.95131
66
836327.4083
67
13381.23853
68
819708.6469
69
13115.33835
70
802823.9852
71
12845.18376
72
785669.169
73
12570.7067
74
768239.8757
75
12291.83801
76
750531.7137
77
12008.50742
78
732540.2211
79
11720.64354
80
714260.8646
81
11428.17383
82
695689.0385
83
11131.02462
84
676820.0631
85
10829.12101
86
657649.1841
87
10522.38695
88
638171.5711
89
10210.74514
90
618382.3162
91
9894.117059
92
598276.4332
93
9572.422932
94
577848.8562
95
9245.581699
96
557094.4379
97
8913.511006
98
536007.9489
99
8576.127182
100
514584.0761