Retirement Intelligence 101
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Start of the year, how much you haveDuring the year, how much you saveHow much you earned in interestHow much you have total at the end of the yearInputs:During the year, how much you saveInterest rate on savings
2
Year0$0$34,000$0$34,000$34,0002.50%
3
Year1$34,000$34,000$850$68,850
4
Year2$68,850$34,000$1,721$104,571
5
Year3$104,571$34,000$2,614$141,186
6
Year4$141,186$34,000$3,530$178,715It takes 17 years to save $750,000 if you invest your money in a 2.5% Certificate of Deposit
7
Year5$178,715$34,000$4,468$217,183
8
Year6$217,183$34,000$5,430$256,613
9
Year7$256,613$34,000$6,415$297,028
10
Year8$297,028$34,000$7,426$338,454
11
Year9$338,454$34,000$8,461$380,915
12
Year10$380,915$34,000$9,523$424,438
13
Year11$424,438$34,000$10,611$469,049
14
Year12$469,049$34,000$11,726$514,775
15
Year13$514,775$34,000$12,869$561,644
This spreadsheet is a supplement to the article found here http://attemptedliving.com/2018/11/19/retirement-intelligence-101-part-3-how-to-achieve-fire-financial-independence-and-retire-early/
16
Year14$561,644$34,000$14,041$609,686
17
Year15$609,686$34,000$15,242$658,928
18
Year16$658,928$34,000$16,473$709,401
19
Year17$709,401$34,000$17,735$761,136
20
Year18$761,136$34,000$19,028$814,164
21
Year19$814,164$34,000$20,354$868,518
22
Year20$868,518$34,000$21,713$924,231
23
Year21$924,231$34,000$23,106$981,337
24
Year22$981,337$34,000$24,533$1,039,871
25
Year23$1,039,871$34,000$25,997$1,099,867
26
Year24$1,099,867$34,000$27,497$1,161,364
27
Year25$1,161,364$34,000$29,034$1,224,398
28
Year26$1,224,398$34,000$30,610$1,289,008
29
Year27$1,289,008$34,000$32,225$1,355,233
30
Year28$1,355,233$34,000$33,881$1,423,114
31
Year29$1,423,114$34,000$35,578$1,492,692
32
Year30$1,492,692$34,000$37,317$1,564,009
33
Year31$1,564,009$34,000$39,100$1,637,109
34
Year32$1,637,109$34,000$40,928$1,712,037
35
Year33$1,712,037$34,000$42,801$1,788,838
36
Year34$1,788,838$34,000$44,721$1,867,559
37
Year35$1,867,559$34,000$46,689$1,948,248
38
Year36$1,948,248$34,000$48,706$2,030,954
39
Year37$2,030,954$34,000$50,774$2,115,728
40
Year38$2,115,728$34,000$52,893$2,202,621
41
Year39$2,202,621$34,000$55,066$2,291,687
42
Year40$2,291,687$34,000$57,292$2,382,979
43
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...
Main menu