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

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
Starting Year2019YearYearAgeAnnual SalaryAnnual ExpensesSurplus/SavingsSavings RateWealth Portfolio ValueInitial Annual Withdrawal IncomeWithdrawal Income - Expenses
3
Starting Age380201938$40,000$10,000$30,00075%$30,000$1,200-$8,800
4
Starting Lump Sum Wealth$0.001202039$41,600$10,400$31,20075%$62,700$2,508-$7,892
5
Starting Annual Salary$40,000.002202140$43,264$10,816$32,44875%$98,283$3,931-$6,885
6
Annual Expense % of Your Salary25.00%3202241$44,995$11,249$33,74675%$136,943$5,478-$5,771
7
Salary Growth4.00%4202342$46,794$11,699$35,09675%$178,886$7,155-$4,543
8
Wealth Portfolio Rate of Return5.00%5202443$48,666$12,167$36,50075%$224,330$8,973-$3,193
9
Financial Independence Withdrawal Rate4.00%6202544$50,613$12,653$37,96075%$273,506$10,940-$1,713
10
7202645$52,637$13,159$39,47875%$326,659$13,066-$93
11
The Age where you FI468202746$54,743$13,686$41,05775%$384,049$15,362$1,676
12
Duration (Years)89202847$56,932$14,233$42,69975%$445,951$17,838$3,605
13
Wealth Portfolio Value$384,04910202948$59,210$14,802$44,40775%$512,656$20,506$5,704
14
Annual Salary$54,74311203049$61,578$15,395$46,18475%$584,472$23,379$7,984
15
Annual Expense$13,68612203150$64,041$16,010$48,03175%$661,727$26,469$10,459
16
Annual Surplus/Savings$41,05713203251$66,603$16,651$49,95275%$744,765$29,791$13,140
17
Initial Annual Withdrawal Income$15,36214203352$69,267$17,317$51,95075%$833,954$33,358$16,041
18
Ready to FI?Yes!15203453$72,038$18,009$54,02875%$929,680$37,187$19,178
19
16203554$74,919$18,730$56,18975%$1,032,353$41,294$22,564
20
Legend17203655$77,916$19,479$58,43775%$1,142,408$45,696$26,217
21
Input18203756$81,033$20,258$60,77475%$1,260,303$50,412$30,154
22
Don't overwrite19203857$84,274$21,068$63,20575%$1,386,524$55,461$34,392
23
20203958$87,645$21,911$65,73475%$1,521,584$60,863$38,952
24
21204059$91,151$22,788$68,36375%$1,666,026$66,641$43,853
25
22204160$94,797$23,699$71,09875%$1,820,425$72,817$49,118
26
23204261$98,589$24,647$73,94175%$1,985,387$79,415$54,768
27
24204362$102,532$25,633$76,89975%$2,161,556$86,462$60,829
28
25204463$106,633$26,658$79,97575%$2,349,609$93,984$67,326
29
26204564$110,899$27,725$83,17475%$2,550,263$102,011$74,286
30
27204665$115,335$28,834$86,50175%$2,764,277$110,571$81,737
31
28204766$119,948$29,987$89,96175%$2,992,452$119,698$89,711
32
29204867$124,746$31,187$93,56075%$3,235,635$129,425$98,239
33
30204968$129,736$32,434$97,30275%$3,494,718$139,789$107,355
34
31205069$134,925$33,731$101,19475%$3,770,648$150,826$117,095
35
32205170$140,322$35,081$105,24275%$4,064,422$162,577$127,496
36
33205271$145,935$36,484$109,45175%$4,377,095$175,084$138,600
37
34205372$151,773$37,943$113,82975%$4,709,779$188,391$150,448
38
35205473$157,844$39,461$118,38375%$5,063,651$202,546$163,085
39
36205574$164,157$41,039$123,11875%$5,439,951$217,598$176,559
40
37205675$170,724$42,681$128,04375%$5,839,992$233,600$190,919
41
38205776$177,553$44,388$133,16475%$6,265,155$250,606$206,218
42
39205877$184,655$46,164$138,49175%$6,716,904$268,676$222,513
43
40205978$192,041$48,010$144,03175%$7,196,780$287,871$239,861
44
41206079$199,722$49,931$149,79275%$7,706,411$308,256$258,326
45
42206180$207,711$51,928$155,78475%$8,247,515$329,901$277,973
46
43206281$216,020$54,005$162,01575%$8,821,906$352,876$298,871
47
44206382$224,661$56,165$168,49575%$9,431,496$377,260$321,095
48
45206483$233,647$58,412$175,23575%$10,078,306$403,132$344,721
49
46206584$242,993$60,748$182,24575%$10,764,466$430,579$369,830
50
47206685$252,713$63,178$189,53475%$11,492,224$459,689$396,511
51
48206786$262,821$65,705$197,11675%$12,263,951$490,558$424,853
52
49206887$273,334$68,333$205,00075%$13,082,149$523,286$454,952
53
50206988$284,267$71,067$213,20175%$13,949,457$557,978$486,911
54
51207089$295,638$73,910$221,72975%$14,868,659$594,746$520,837
55
52207190$307,464$76,866$230,59875%$15,842,689$633,708$556,842
56
53207291$319,762$79,941$239,82275%$16,874,645$674,986$595,045
57
54207392$332,553$83,138$249,41475%$17,967,792$718,712$635,574
58
55207493$345,855$86,464$259,39175%$19,125,573$765,023$678,559
59
56207594$359,689$89,922$269,76775%$20,351,618$814,065$724,142
60
57207695$374,076$93,519$280,55775%$21,649,756$865,990$772,471
61
58207796$389,039$97,260$291,78075%$23,024,023$920,961$823,701
62
59207897$404,601$101,150$303,45175%$24,478,675$979,147$877,997
63
60207998$420,785$105,196$315,58975%$26,018,198$1,040,728$935,532
64
61208099$437,617$109,404$328,21275%$27,647,320$1,105,893$996,489
65
622081100$455,121$113,780$341,34175%$29,371,027$1,174,841$1,061,061
66
632082101$473,326$118,332$354,99575%$31,194,573$1,247,783$1,129,451
67
642083102$492,259$123,065$369,19475%$33,123,496$1,324,940$1,201,875
68
652084103$511,949$127,987$383,96275%$35,163,633$1,406,545$1,278,558
69
662085104$532,427$133,107$399,32175%$37,321,135$1,492,845$1,359,739
70
672086105$553,724$138,431$415,29375%$39,602,485$1,584,099$1,445,668
71
682087106$575,873$143,968$431,90575%$42,014,515$1,680,581$1,536,612
72
692088107$598,908$149,727$449,18175%$44,564,422$1,782,577$1,632,850
73
702089108$622,865$155,716$467,14975%$47,259,791$1,890,392$1,734,675
74
712090109$647,779$161,945$485,83475%$50,108,615$2,004,345$1,842,400
75
722091110$673,690$168,423$505,26875%$53,119,314$2,124,773$1,956,350
76
732092111$700,638$175,160$525,47975%$56,300,758$2,252,030$2,076,871
77
742093112$728,664$182,166$546,49875%$59,662,294$2,386,492$2,204,326
78
752094113$757,810$189,453$568,35875%$63,213,766$2,528,551$2,339,098
79
762095114$788,123$197,031$591,09275%$66,965,546$2,678,622$2,481,591
80
772096115$819,647$204,912$614,73675%$70,928,559$2,837,142$2,632,230
81
782097116$852,433$213,108$639,32575%$75,114,312$3,004,572$2,791,464
82
792098117$886,531$221,633$664,89875%$79,534,926$3,181,397$2,959,764
83
802099118$921,992$230,498$691,49475%$84,203,166$3,368,127$3,137,629
84
812100119$958,872$239,718$719,15475%$89,132,478$3,565,299$3,325,581
85
822101120$997,227$249,307$747,92075%$94,337,022$3,773,481$3,524,174
86
832102121$1,037,116$259,279$777,83775%$99,831,710$3,993,268$3,733,990
87
842103122$1,078,600$269,650$808,95075%$105,632,246$4,225,290$3,955,640
88
852104123$1,121,744$280,436$841,30875%$111,755,166$4,470,207$4,189,771
89
862105124$1,166,614$291,653$874,96075%$118,217,885$4,728,715$4,437,062
90
872106125$1,213,279$303,320$909,95975%$125,038,738$5,001,550$4,698,230
91
882107126$1,261,810$315,452$946,35775%$132,237,032$5,289,481$4,974,029
92
892108127$1,312,282$328,071$984,21275%$139,833,095$5,593,324$5,265,253
93
902109128$1,364,773$341,193$1,023,58075%$147,848,330$5,913,933$5,572,740
94
912110129$1,419,364$354,841$1,064,52375%$156,305,270$6,252,211$5,897,370
95
922111130$1,476,139$369,035$1,107,10475%$165,227,637$6,609,105$6,240,071
96
932112131$1,535,184$383,796$1,151,38875%$174,640,407$6,985,616$6,601,820
97
942113132$1,596,592$399,148$1,197,44475%$184,569,872$7,382,795$6,983,647
98
952114133$1,660,455$415,114$1,245,34275%$195,043,707$7,801,748$7,386,634
99
962115134$1,726,874$431,718$1,295,15575%$206,091,047$8,243,642$7,811,923
100
972116135$1,795,949$448,987$1,346,96175%$217,742,561$8,709,702$8,260,715
Loading...