A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Dividend Growth | 1.07 | ||||
2 | Dividend Yield | 0.03 | ||||
3 | Monthly Investment | 3000 | ||||
4 | ||||||
5 | Month | Shares | Share Price | Dividend | Mthly Income | |
6 | 1 | 10,000.00 | 1.000 | 0.00250 | 25.00 | |
7 | 2 | 13,025.00 | 1.000 | 0.00250 | 32.56 | |
8 | 3 | 16,057.56 | 1.000 | 0.00250 | 40.14 | |
9 | 4 | 19,097.71 | 1.000 | 0.00250 | 47.74 | |
10 | 5 | 22,145.45 | 1.000 | 0.00250 | 55.36 | |
11 | 6 | 25,200.81 | 1.000 | 0.00250 | 63.00 | |
12 | 7 | 28,263.82 | 1.000 | 0.00250 | 70.66 | |
13 | 8 | 31,334.48 | 1.000 | 0.00250 | 78.34 | |
14 | 9 | 34,412.81 | 1.000 | 0.00250 | 86.03 | |
15 | 10 | 37,498.84 | 1.000 | 0.00250 | 93.75 | |
16 | 11 | 40,592.59 | 1.000 | 0.00250 | 101.48 | |
17 | 12 | 43,694.07 | 1.000 | 0.00250 | 109.24 | |
18 | 13 | 46,599.90 | 1.070 | 0.00268 | 124.65 | |
19 | 14 | 49,520.14 | 1.070 | 0.00268 | 132.47 | |
20 | 15 | 52,447.68 | 1.070 | 0.00268 | 140.30 | |
21 | 16 | 55,382.53 | 1.070 | 0.00268 | 148.15 | |
22 | 17 | 58,324.73 | 1.070 | 0.00268 | 156.02 | |
23 | 18 | 61,274.28 | 1.070 | 0.00268 | 163.91 | |
24 | 19 | 64,231.20 | 1.070 | 0.00268 | 171.82 | |
25 | 20 | 67,195.52 | 1.070 | 0.00268 | 179.75 | |
26 | 21 | 70,167.25 | 1.070 | 0.00268 | 187.70 | |
27 | 22 | 73,146.40 | 1.070 | 0.00268 | 195.67 | |
28 | 23 | 76,133.01 | 1.070 | 0.00268 | 203.66 | |
29 | 24 | 79,127.08 | 1.070 | 0.00268 | 211.66 | |
30 | 25 | 81,932.27 | 1.145 | 0.00286 | 234.51 | |
31 | 26 | 84,757.42 | 1.145 | 0.00286 | 242.60 | |
32 | 27 | 87,589.63 | 1.145 | 0.00286 | 250.70 | |
33 | 28 | 90,428.92 | 1.145 | 0.00286 | 258.83 | |
34 | 29 | 93,275.31 | 1.145 | 0.00286 | 266.98 | |
35 | 30 | 96,128.81 | 1.145 | 0.00286 | 275.14 | |
36 | 31 | 98,989.45 | 1.145 | 0.00286 | 283.33 | |
37 | 32 | 101,857.24 | 1.145 | 0.00286 | 291.54 | |
38 | 33 | 104,732.20 | 1.145 | 0.00286 | 299.77 | |
39 | 34 | 107,614.34 | 1.145 | 0.00286 | 308.02 | |
40 | 35 | 110,503.70 | 1.145 | 0.00286 | 316.29 | |
41 | 36 | 113,400.27 | 1.145 | 0.00286 | 324.58 | |
42 | 37 | 116,114.12 | 1.225 | 0.00306 | 355.61 | |
43 | 38 | 118,853.30 | 1.225 | 0.00306 | 364.00 | |
44 | 39 | 121,599.33 | 1.225 | 0.00306 | 372.41 | |
45 | 40 | 124,352.22 | 1.225 | 0.00306 | 380.84 | |
46 | 41 | 127,111.99 | 1.225 | 0.00306 | 389.29 | |
47 | 42 | 129,878.66 | 1.225 | 0.00306 | 397.77 | |
48 | 43 | 132,652.26 | 1.225 | 0.00306 | 406.26 | |
49 | 44 | 135,432.78 | 1.225 | 0.00306 | 414.78 | |
50 | 45 | 138,220.26 | 1.225 | 0.00306 | 423.31 | |
51 | 46 | 141,014.70 | 1.225 | 0.00306 | 431.87 | |
52 | 47 | 143,816.13 | 1.225 | 0.00306 | 440.45 | |
53 | 48 | 146,624.56 | 1.225 | 0.00306 | 449.05 | |
54 | 49 | 149,255.83 | 1.311 | 0.00328 | 489.11 | |
55 | 50 | 151,917.66 | 1.311 | 0.00328 | 497.83 | |
56 | 51 | 154,586.13 | 1.311 | 0.00328 | 506.58 | |
57 | 52 | 157,261.29 | 1.311 | 0.00328 | 515.34 | |
58 | 53 | 159,943.12 | 1.311 | 0.00328 | 524.13 | |
59 | 54 | 162,631.67 | 1.311 | 0.00328 | 532.94 | |
60 | 55 | 165,326.93 | 1.311 | 0.00328 | 541.77 | |
61 | 56 | 168,028.94 | 1.311 | 0.00328 | 550.63 | |
62 | 57 | 170,737.69 | 1.311 | 0.00328 | 559.51 | |
63 | 58 | 173,453.22 | 1.311 | 0.00328 | 568.40 | |
64 | 59 | 176,175.54 | 1.311 | 0.00328 | 577.33 | |
65 | 60 | 178,904.67 | 1.311 | 0.00328 | 586.27 | |
66 | 61 | 181,461.63 | 1.403 | 0.00351 | 636.27 | |
67 | 62 | 184,054.24 | 1.403 | 0.00351 | 645.36 | |
68 | 63 | 186,653.33 | 1.403 | 0.00351 | 654.48 | |
69 | 64 | 189,258.93 | 1.403 | 0.00351 | 663.61 | |
70 | 65 | 191,871.03 | 1.403 | 0.00351 | 672.77 | |
71 | 66 | 194,489.67 | 1.403 | 0.00351 | 681.95 | |
72 | 67 | 197,114.85 | 1.403 | 0.00351 | 691.16 | |
73 | 68 | 199,746.60 | 1.403 | 0.00351 | 700.39 | |
74 | 69 | 202,384.92 | 1.403 | 0.00351 | 709.64 | |
75 | 70 | 205,029.84 | 1.403 | 0.00351 | 718.91 | |
76 | 71 | 207,681.38 | 1.403 | 0.00351 | 728.21 | |
77 | 72 | 210,339.54 | 1.403 | 0.00351 | 737.53 | |
78 | 73 | 212,830.01 | 1.501 | 0.00375 | 798.50 | |
79 | 74 | 215,361.11 | 1.501 | 0.00375 | 808.00 | |
80 | 75 | 217,898.54 | 1.501 | 0.00375 | 817.52 | |
81 | 76 | 220,442.32 | 1.501 | 0.00375 | 827.06 | |
82 | 77 | 222,992.45 | 1.501 | 0.00375 | 836.63 | |
83 | 78 | 225,548.96 | 1.501 | 0.00375 | 846.22 | |
84 | 79 | 228,111.85 | 1.501 | 0.00375 | 855.84 | |
85 | 80 | 230,681.16 | 1.501 | 0.00375 | 865.48 | |
86 | 81 | 233,256.89 | 1.501 | 0.00375 | 875.14 | |
87 | 82 | 235,839.06 | 1.501 | 0.00375 | 884.83 | |
88 | 83 | 238,427.68 | 1.501 | 0.00375 | 894.54 | |
89 | 84 | 241,022.78 | 1.501 | 0.00375 | 904.28 | |
90 | 85 | 243,454.17 | 1.606 | 0.00401 | 977.34 | |
91 | 86 | 245,931.05 | 1.606 | 0.00401 | 987.28 | |
92 | 87 | 248,414.13 | 1.606 | 0.00401 | 997.25 | |
93 | 88 | 250,903.41 | 1.606 | 0.00401 | 1,007.24 | |
94 | 89 | 253,398.92 | 1.606 | 0.00401 | 1,017.26 | |
95 | 90 | 255,900.67 | 1.606 | 0.00401 | 1,027.30 | |
96 | 91 | 258,408.67 | 1.606 | 0.00401 | 1,037.37 | |
97 | 92 | 260,922.94 | 1.606 | 0.00401 | 1,047.46 | |
98 | 93 | 263,443.50 | 1.606 | 0.00401 | 1,057.58 | |
99 | 94 | 265,970.35 | 1.606 | 0.00401 | 1,067.73 | |
100 | 95 | 268,503.53 | 1.606 | 0.00401 | 1,077.89 |