Spreadsheet: 71289d1271960577-stopping-spreadsheet-at-a-certain-number-roadmap-template
Sheet: Savings

 | Retirement Planning Spreadsheet
 | Retirement Savings Plan |  |  |  | Estimated Future Value |  |  |  | Estimated FV Making Annual
 |  |  |  |  |  |  |  |  | Payment Each Year
 |  | Present Value of Investment | 50000 |  |  | Estimated Future Value | 107946.2498636393 |  | 107946.2498636394
 |  | Expected Annual Return | 0.08
 |  |  |  |  |  | Total Payments | 50000
 |  | Current Age | 55 |  |  | Total Interest | 57946.24986363934
 |  | Age at Retirement | 65
 |  | Annual Payment | 0
 |  | # of Payments (First N Years) | 0
 |  | Years until retirement | 10
Year | Age | Rate | Invested  (Payments) | Cumulative Payments | Interest | Cumulative Interest | Balance
 |  |  | 50000 |  |  |  | 50000
1 | 55 | 0.08 | 0 | 50000 | 4000 | 4000 | 54000
2 | 56 | 0.08 | 0 | 50000 | 4320 | 8320 | 58320
3 | 57 | 0.08 | 0 | 50000 | 4665.6 | 12985.6 | 62985.6 |  | Random Rates | min | -0.04
4 | 58 | 0.08 | 0 | 50000 | 5038.848 | 18024.448 | 68024.448 |  |  | [NAME] | 0.1
5 | 59 | 0.08 | 0 | 50000 | 5441.955840000001 | 23466.40384 | 73466.40384 |  |  | average | 0.07999999999999999
6 | 60 | 0.08 | 0 | 50000 | 5877.3123072 | 29343.7161472 | 79343.7161472
7 | 61 | 0.08 | 0 | 50000 | 6347.497291776001 | 35691.213438976 | 85691.213438976 |  |  |  | 0
8 | 62 | 0.08 | 0 | 50000 | 6855.29707511808 | 42546.51051409409 | 92546.51051409409
9 | 63 | 0.08 | 0 | 50000 | 7403.720841127527 | 49950.23135522161 | 99950.23135522161
10 | 64 | 0.08 | 0 | 50000 | 7996.018508417729 | 57946.24986363934 | 107946.2498636393
11 | 65 | 0.08 | 0 | 50000 | 8635.699989091148 | 66581.9498527305 | 116581.9498527305
12 | 66 | 0.08 | 0 | 50000 | 9326.55598821844 | 75908.50584094894 | 125908.5058409489
13 | 67 | 0.08 | 0 | 50000 | 10072.68046727592 | 85981.18630822486 | 135981.1863082249
14 | 68 | 0.08 | 0 | 50000 | 10878.49490465799 | 96859.68121288285 | 146859.6812128829
15 | 69 | 0.08 | 0 | 50000 | 11748.77449703063 | 108608.4557099135 | 158608.4557099135
16 | 70 | 0.08 | 0 | 50000 | 12688.67645679308 | 121297.1321667065 | 171297.1321667065
17 | 71 | 0.08 | 0 | 50000 | 13703.77057333652 | 135000.9027400431 | 185000.9027400431
18 | 72 | 0.08 | 0 | 50000 | 14800.07221920344 | 149800.9749592465 | 199800.9749592465
19 | 73 | 0.08 | 0 | 50000 | 15984.07799673972 | 165785.0529559862 | 215785.0529559862
20 | 74 | 0.08 | 0 | 50000 | 17262.8042364789 | 183047.8571924651 | 233047.8571924651
21 | 75 | 0.08 | 0 | 50000 | 18643.82857539721 | 201691.6857678623 | 251691.6857678623
22 | 76 | 0.08 | 0 | 50000 | 20135.33486142899 | 221827.0206292913 | 271827.0206292913
23 | 77 | 0.08 | 0 | 50000 | 21746.1616503433 | 243573.1822796346 | 293573.1822796346
24 | 78 | 0.08 | 0 | 50000 | 23485.85458237077 | 267059.0368620054 | 317059.0368620054
25 | 79 | 0.08 | 0 | 50000 | 25364.72294896044 | 292423.7598109658 | 342423.7598109659
26 | 80 | 0.08 | 0 | 50000 | 27393.90078487727 | 319817.660595843 | 369817.6605958431
27 | 81 | 0.08 | 0 | 50000 | 29585.41284766745 | 349403.0734435105 | 399403.0734435106
28 | 82 | 0.08 | 0 | 50000 | 31952.24587548085 | 381355.3193189914 | 431355.3193189914
29 | 83 | 0.08 | 0 | 50000 | 34508.42554551931 | 415863.7448645107 | 465863.7448645107
30 | 84 | 0.08 | 0 | 50000 | 37269.09958916086 | 453132.8444536716 | 503132.8444536716
31 | 85 | 0.08 | 0 | 50000 | 40250.62755629373 | 493383.4720099653 | 543383.4720099653
32 | 86 | 0.08 | 0 | 50000 | 43470.67776079723 | 536854.1497707625 | 586854.1497707625
33 | 87 | 0.08 | 0 | 50000 | 46948.331981661 | 583802.4817524236 | 633802.4817524236
34 | 88 | 0.08 | 0 | 50000 | 50704.19854019389 | 634506.6802926174 | 684506.6802926174
35 | 89 | 0.08 | 0 | 50000 | 54760.53442340939 | 689267.2147160268 | 739267.2147160268
36 | 90 | 0.08 | 0 | 50000 | 59141.37717728214 | 748408.5918933089 | 798408.5918933089
37 | 91 | 0.08 | 0 | 50000 | 63872.68735146472 | 812281.2792447737 | 862281.2792447737
38 | 92 | 0.08 | 0 | 50000 | 68982.5023395819 | 881263.7815843555 | 931263.7815843555
39 | 93 | 0.08 | 0 | 50000 | 74501.10252674844 | 955764.884111104 | 1005764.884111104
40 | 94 | 0.08 | 0 | 50000 | 80461.19072888832 | 1036226.074839992 | 1086226.074839992
41 | 95 | 0.08 | 0 | 50000 | 86898.08598719937 | 1123124.160827192 | 1173124.160827192
42 | 96 | 0.08 | 0 | 50000 | 93849.93286617532 | 1216974.093693367 | 1266974.093693367
43 | 97 | 0.08 | 0 | 50000 | 101357.9274954694 | 1318332.021188836 | 1368332.021188836
44 | 98 | 0.08 | 0 | 50000 | 109466.5616951069 | 1427798.582883943 | 1477798.582883943
45 | 99 | 0.08 | 0 | 50000 | 118223.8866307155 | 1546022.469514659 | 1596022.469514659
46 | 100 | 0.08 | 0 | 50000 | 127681.7975611727 | 1673704.267075832 | 1723704.267075832
47 | 101 | 0.08 | 0 | 50000 | 137896.3413660665 | 1811600.608441898 | 1861600.608441898
48 | 102 | 0.08 | 0 | 50000 | 148928.0486753519 | 1960528.65711725 | 2010528.65711725
49 | 103 | 0.08 | 0 | 50000 | 160842.29256938 | 2121370.94968663 | 2171370.94968663
50 | 104 | 0.08 | 0 | 50000 | 173709.6759749304 | 2295080.62566156 | 2345080.62566156
51 | 105 | 0.08 | 0 | 50000 | 187606.4500529248 | 2482687.075714485 | 2532687.075714485
52 | 106 | 0.08 | 0 | 50000 | 202614.9660571588 | 2685302.041771644 | 2735302.041771644
53 | 107 | 0.08 | 0 | 50000 | 218824.1633417315 | 2904126.205113375 | 2954126.205113375
54 | 108 | 0.08 | 0 | 50000 | 236330.09640907 | 3140456.301522445 | 3190456.301522445
55 | 109 | 0.08 | 0 | 50000 | 255236.5041217956 | 3395692.805644241 | 3445692.805644241
56 | 110 | 0.08 | 0 | 50000 | 275655.4244515392 | 3671348.23009578 | 3721348.23009578
57 | 111 | 0.08 | 0 | 50000 | 297707.8584076624 | 3969056.088503442 | 4019056.088503442
58 | 112 | 0.08 | 0 | 50000 | 321524.4870802754 | 4290580.575583718 | 4340580.575583718
59 | 113 | 0.08 | 0 | 50000 | 347246.4460466974 | 4637827.021630416 | 4687827.021630416
60 | 114 | 0.08 | 0 | 50000 | 375026.1617304333 | 5012853.183360849 | 5062853.183360849