Compound Interest Schedule

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

  • Beg. Bal: Beginning Balance: How much money are you starting with?
  • Cont’n: Investment Contribution: How much money are you putting in your Investment Account each year?
  • Sub-Ttl: Sub-Total: Beginning Balance + Investment Contribution
  • ROI: After Tax Return: What “after-tax” percentage return are you planning on earning? Write that down (a 7% return is a good place to start), and multiply that percentage by the Sub-Total Amount.
  • Total: Total Investment Account: Sub-Total + After-Tax Return on Investment

Compound Interest Schedule

After-Tax % Return: ______ %

YearBeg. BalCont’nSub-TtlROI Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

Compound Interest Schedule Example

After-Tax % Return: 7 %

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,97223,298342,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,370943,586
38943,5865,500949,08666,4361,015,522
391,015,4935,5001,021,02271,4721,092,493
401,092,4935,5001,097,99376,8601,174,853