ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions: change the yellow cells for the data below to change automatically
2
3
Net value at beginning of year 1
0
4
Annual income
10,000
5
Annual expenses
6,000
6
Annual (real) market returns
4%
7
8
Years to FI
 23.36
23 years and 4 months
9
10
YearNet value at beginning of yearMarket returnsSavings/ investmentNet value at year-endFI reached?
11
1 - - 4,000 4,000
12
2 4,000 160 4,000 8,160
13
3 8,160 326 4,000 12,486
14
4 12,486 499 4,000 16,986
15
5 16,986 679 4,000 21,665
16
6 21,665 867 4,000 26,532
17
7 26,532 1,061 4,000 31,593
18
8 31,593 1,264 4,000 36,857
19
9 36,857 1,474 4,000 42,331
20
10 42,331 1,693 4,000 48,024
21
11 48,024 1,921 4,000 53,945
22
12 53,945 2,158 4,000 60,103
23
13 60,103 2,404 4,000 66,507
24
14 66,507 2,660 4,000 73,168
25
15 73,168 2,927 4,000 80,094
26
16 80,094 3,204 4,000 87,298
27
17 87,298 3,492 4,000 94,790
28
18 94,790 3,792 4,000 102,582
29
19 102,582 4,103 4,000 110,685
30
20 110,685 4,427 4,000 119,112
31
21 119,112 4,764 4,000 127,877
32
22 127,877 5,115 4,000 136,992
33
23 136,992 5,480 4,000 146,472
34
24 146,472 5,859 4,000 156,330 FI reached
35
25 156,330 6,253 4,000 166,584 FI reached
36
26 166,584 6,663 4,000 177,247 FI reached
37
27 177,247 7,090 4,000 188,337 FI reached
38
28 188,337 7,533 4,000 199,870 FI reached
39
29 199,870 7,995 4,000 211,865 FI reached
40
30 211,865 8,475 4,000 224,340 FI reached
41
31 224,340 8,974 4,000 237,313 FI reached
42
32 237,313 9,493 4,000 250,806 FI reached
43
33 250,806 10,032 4,000 264,838 FI reached
44
34 264,838 10,594 4,000 279,432 FI reached
45
35 279,432 11,177 4,000 294,609 FI reached
46
36 294,609 11,784 4,000 310,393 FI reached
47
37 310,393 12,416 4,000 326,809 FI reached
48
38 326,809 13,072 4,000 343,881 FI reached
49
39 343,881 13,755 4,000 361,637 FI reached
50
40 361,637 14,465 4,000 380,102 FI reached
51
41 380,102 15,204 4,000 399,306 FI reached
52
42 399,306 15,972 4,000 419,278 FI reached
53
43 419,278 16,771 4,000 440,050 FI reached
54
44 440,050 17,602 4,000 461,652 FI reached
55
45 461,652 18,466 4,000 484,118 FI reached
56
46 484,118 19,365 4,000 507,482 FI reached
57
47 507,482 20,299 4,000 531,782 FI reached
58
48 531,782 21,271 4,000 557,053 FI reached
59
49 557,053 22,282 4,000 583,335 FI reached
60
50 583,335 23,333 4,000 610,668 FI reached
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