Dividend Reinvestment worksheet

1. Value after 18 years with dividends reinvested: $41,470.48

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$10,000.00}}{\mathrm{\$52.00}}$$=192.3077$

2. Each quarterly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{4\%}}{4}$$=1.01$

3. After 72 payments, the share count has grown by that factor 72 times over

   $192.3077\times {1.01}^{72}$$=393.6729$

4. Grow the share price by 4% a year for 18 years

   $\mathrm{\$52.00}\times {\left(1+0.04\right)}^{18}$$=\mathrm{\$105.34}$

5. Multiply the shares you own by the final share price to get their value

   $393.672945\times \mathrm{\$105.34}$$=\mathrm{\$41,470.48}$

2. Value after 16 years with dividends reinvested: $36,688.67

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$9,000.00}}{\mathrm{\$45.00}}$$=200$

2. Each yearly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{3\%}}{1}$$=1.03$

3. After 16 payments, the share count has grown by that factor 16 times over

   $200\times {1.03}^{16}$$=320.9413$

4. Grow the share price by 6% a year for 16 years

   $\mathrm{\$45.00}\times {\left(1+0.06\right)}^{16}$$=\mathrm{\$114.32}$

5. Multiply the shares you own by the final share price to get their value

   $320.941288\times \mathrm{\$114.32}$$=\mathrm{\$36,688.67}$

3. Value after 29 years with dividends reinvested: $221,868.88

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$10,000.00}}{\mathrm{\$50.00}}$$=200$

2. Each yearly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{4\%}}{1}$$=1.04$

3. After 29 payments, the share count has grown by that factor 29 times over

   $200\times {1.04}^{29}$$=623.7303$

4. Grow the share price by 7% a year for 29 years

   $\mathrm{\$50.00}\times {\left(1+0.07\right)}^{29}$$=\mathrm{\$355.71}$

5. Multiply the shares you own by the final share price to get their value

   $623.73029\times \mathrm{\$355.71}$$=\mathrm{\$221,868.88}$

4. Value after 22 years with dividends reinvested: $67,398.18

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$12,000.00}}{\mathrm{\$55.00}}$$=218.1818$

2. Each yearly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{4\%}}{1}$$=1.04$

3. After 22 payments, the share count has grown by that factor 22 times over

   $218.1818\times {1.04}^{22}$$=517.0732$

4. Grow the share price by 4% a year for 22 years

   $\mathrm{\$55.00}\times {\left(1+0.04\right)}^{22}$$=\mathrm{\$130.35}$

5. Multiply the shares you own by the final share price to get their value

   $517.073191\times \mathrm{\$130.35}$$=\mathrm{\$67,398.18}$

5. Value after 18 years with dividends reinvested: $27,576.53

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$9,500.00}}{\mathrm{\$45.00}}$$=211.1111$

2. Each monthly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{2\%}}{12}$$=1.00166667$

3. After 216 payments, the share count has grown by that factor 216 times over

   $211.1111\times {1.00166667}^{216}$$=302.5011$

4. Grow the share price by 4% a year for 18 years

   $\mathrm{\$45.00}\times {\left(1+0.04\right)}^{18}$$=\mathrm{\$91.16}$

5. Multiply the shares you own by the final share price to get their value

   $302.501102\times \mathrm{\$91.16}$$=\mathrm{\$27,576.53}$

6. Value after 13 years with dividends reinvested: $46,599.06

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$13,000.00}}{\mathrm{\$28.00}}$$=464.2857$

2. Each monthly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{4\%}}{12}$$=1.00333333$

3. After 156 payments, the share count has grown by that factor 156 times over

   $464.2857\times {1.00333333}^{156}$$=780.2664$

4. Grow the share price by 6% a year for 13 years

   $\mathrm{\$28.00}\times {\left(1+0.06\right)}^{13}$$=\mathrm{\$59.72}$

5. Multiply the shares you own by the final share price to get their value

   $780.266385\times \mathrm{\$59.72}$$=\mathrm{\$46,599.06}$

7. Value after 16 years with dividends reinvested: $34,956.01

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$10,000.00}}{\mathrm{\$64.00}}$$=156.25$

2. Each quarterly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{2\%}}{4}$$=1.005$

3. After 64 payments, the share count has grown by that factor 64 times over

   $156.25\times {1.005}^{64}$$=215.0047$

4. Grow the share price by 6% a year for 16 years

   $\mathrm{\$64.00}\times {\left(1+0.06\right)}^{16}$$=\mathrm{\$162.58}$

5. Multiply the shares you own by the final share price to get their value

   $215.004712\times \mathrm{\$162.58}$$=\mathrm{\$34,956.01}$

8. Value after 15 years with dividends reinvested: $25,252.30

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$9,000.00}}{\mathrm{\$52.00}}$$=173.0769$

2. Each yearly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{3\%}}{1}$$=1.03$

3. After 15 payments, the share count has grown by that factor 15 times over

   $173.0769\times {1.03}^{15}$$=269.6482$

4. Grow the share price by 4% a year for 15 years

   $\mathrm{\$52.00}\times {\left(1+0.04\right)}^{15}$$=\mathrm{\$93.65}$

5. Multiply the shares you own by the final share price to get their value

   $269.648207\times \mathrm{\$93.65}$$=\mathrm{\$25,252.30}$

9. Value after 20 years with dividends reinvested: $45,343.83

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$9,400.00}}{\mathrm{\$60.00}}$$=156.6667$

2. Each quarterly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{3\%}}{4}$$=1.0075$

3. After 80 payments, the share count has grown by that factor 80 times over

   $156.6667\times {1.0075}^{80}$$=284.8269$

4. Grow the share price by 5% a year for 20 years

   $\mathrm{\$60.00}\times {\left(1+0.05\right)}^{20}$$=\mathrm{\$159.20}$

5. Multiply the shares you own by the final share price to get their value

   $284.82689\times \mathrm{\$159.20}$$=\mathrm{\$45,343.83}$

10. Value after 18 years with dividends reinvested: $36,873.97

1. Divide your money by the share price to see how many shares it buys

   $\frac{\mathrm{\$9,000.00}}{\mathrm{\$45.00}}$$=200$

2. Each yearly payment buys more shares. So the share count grows by this factor every period

   $1+\frac{\mathrm{3\%}}{1}$$=1.03$

3. After 18 payments, the share count has grown by that factor 18 times over

   $200\times {1.03}^{18}$$=340.4866$

4. Grow the share price by 5% a year for 18 years

   $\mathrm{\$45.00}\times {\left(1+0.05\right)}^{18}$$=\mathrm{\$108.30}$

5. Multiply the shares you own by the final share price to get their value

   $340.486612\times \mathrm{\$108.30}$$=\mathrm{\$36,873.97}$