Compound Interest Schedule Example

 

Instructions for completing this schedule: (A completed example is included below.)

Beg. Bal: Beginning Balance: This is how much money we are starting out with.

Cont’n: Investment Contribution: This is how much money we are adding to our Investment Account each year.

Sub-Ttl: Sub-Total: Beginning Balance + Investment Contribution

ROI: After Tax Return: This is the “after-tax” percentage return we are planning on earning each year. We multiply that percentage by the Sub-Total Amount.

Total: Total Investment Account: Sub-Total + After-Tax Return on Investment

 

After-Tax % Return: ______ %

YearBeg BalCont'nSub-TtlROITotal
$$$$$
105,5005,5003855,885
25,8855,50011,38579712,182
312,1825,50017,6821,23818,920
418,9205,50024,4201,70926,129
526,1295,50031,6292,21433,843
633,8435,50039,3432,75442,097
742,0975,50047,5973,33250,929
850,9295,50056,4293,95060,379
960,3795,50065,8794,61270,490
1070,4905,50075,9905,31981,310
1181,3105,50086,8106,07792,886
1292,8865,50098,3866,887105,274
13105,2745,500110,7747,754118,528
14118,5285,500124,0288,682132,710
15132,7105,500138,2109,675147,884
16147,8845,500153,38410,737164,121
17164,1215,500169,62111,873181,495
18181,4955,500186,99513,090200,084
19200,0845,500205,58414,391219,975
20219,9755,500225,47515,783241,258
21241,2585,500246,75817,273264,032
22264,0325,500269,53218,867288,399
23288,3995,500293,89920,573314,472
24314,4725,500319,97222,398342,370
25342,3705,500347,87024,351372,221
26372,2215,500377,72126,440404,161
27404,1615,500409,66128,676438,337
28438,3375,500443,83731,069474,906
29474,9065,500480,40633,628514,034
30514,0345,500519,53436,367555,902
31555,9025,500561,40239,298600,700
32600,7005,500606,20042,434648,634
33648,6345,500654,13445,789699,923
34699,9235,500705,42349,380754,803
35754,8035,500760,30353,221813,524
36813,5245,500819,02457,332876,356
37876,3565,500881,85661,730943,586
38943,5865,500949,08666,4361,015,522
391,015,5225,5001,021,02271,4721,092,493
401,092,4935,5001,097,99376,8601,174,853