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: ______ %
Year | Beg Bal | Cont'n | Sub-Ttl | ROI | Total |
$ | $ | $ | $ | $ | |
1 | 0 | 5,500 | 5,500 | 385 | 5,885 |
2 | 5,885 | 5,500 | 11,385 | 797 | 12,182 |
3 | 12,182 | 5,500 | 17,682 | 1,238 | 18,920 |
4 | 18,920 | 5,500 | 24,420 | 1,709 | 26,129 |
5 | 26,129 | 5,500 | 31,629 | 2,214 | 33,843 |
6 | 33,843 | 5,500 | 39,343 | 2,754 | 42,097 |
7 | 42,097 | 5,500 | 47,597 | 3,332 | 50,929 |
8 | 50,929 | 5,500 | 56,429 | 3,950 | 60,379 |
9 | 60,379 | 5,500 | 65,879 | 4,612 | 70,490 |
10 | 70,490 | 5,500 | 75,990 | 5,319 | 81,310 |
11 | 81,310 | 5,500 | 86,810 | 6,077 | 92,886 |
12 | 92,886 | 5,500 | 98,386 | 6,887 | 105,274 |
13 | 105,274 | 5,500 | 110,774 | 7,754 | 118,528 |
14 | 118,528 | 5,500 | 124,028 | 8,682 | 132,710 |
15 | 132,710 | 5,500 | 138,210 | 9,675 | 147,884 |
16 | 147,884 | 5,500 | 153,384 | 10,737 | 164,121 |
17 | 164,121 | 5,500 | 169,621 | 11,873 | 181,495 |
18 | 181,495 | 5,500 | 186,995 | 13,090 | 200,084 |
19 | 200,084 | 5,500 | 205,584 | 14,391 | 219,975 |
20 | 219,975 | 5,500 | 225,475 | 15,783 | 241,258 |
21 | 241,258 | 5,500 | 246,758 | 17,273 | 264,032 |
22 | 264,032 | 5,500 | 269,532 | 18,867 | 288,399 |
23 | 288,399 | 5,500 | 293,899 | 20,573 | 314,472 |
24 | 314,472 | 5,500 | 319,972 | 22,398 | 342,370 |
25 | 342,370 | 5,500 | 347,870 | 24,351 | 372,221 |
26 | 372,221 | 5,500 | 377,721 | 26,440 | 404,161 |
27 | 404,161 | 5,500 | 409,661 | 28,676 | 438,337 |
28 | 438,337 | 5,500 | 443,837 | 31,069 | 474,906 |
29 | 474,906 | 5,500 | 480,406 | 33,628 | 514,034 |
30 | 514,034 | 5,500 | 519,534 | 36,367 | 555,902 |
31 | 555,902 | 5,500 | 561,402 | 39,298 | 600,700 |
32 | 600,700 | 5,500 | 606,200 | 42,434 | 648,634 |
33 | 648,634 | 5,500 | 654,134 | 45,789 | 699,923 |
34 | 699,923 | 5,500 | 705,423 | 49,380 | 754,803 |
35 | 754,803 | 5,500 | 760,303 | 53,221 | 813,524 |
36 | 813,524 | 5,500 | 819,024 | 57,332 | 876,356 |
37 | 876,356 | 5,500 | 881,856 | 61,730 | 943,586 |
38 | 943,586 | 5,500 | 949,086 | 66,436 | 1,015,522 |
39 | 1,015,522 | 5,500 | 1,021,022 | 71,472 | 1,092,493 |
40 | 1,092,493 | 5,500 | 1,097,993 | 76,860 | 1,174,853 |