Dollar Cost Averaging worksheet

1. Average cost per share: $40.15

1. Multiply each purchase's shares by its price to get what it cost

   $\text{14 × \$56.00 = \$784.00; 13 × \$38.00 = \$494.00; 18 × \$24.00 = \$432.00; 10 × \$48.00 = \$480.00; 10 × \$42.00 = \$420.00}$

2. Add up all the shares you bought

   $14+13+18+10+10$$=65$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,610.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,610.00}}{65}$$=\mathrm{\$40.15}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$41.60}$

6. Find what your shares are worth now, at $42.00 a share

   $65\times \mathrm{\$42.00}$$=\mathrm{\$2,730.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$2,730.00}-\mathrm{\$2,610.00}}{\mathrm{\$2,610.00}}\times 100$$=\mathrm{4.5977\%}$

2. Average cost per share: $39.52

1. Multiply each purchase's shares by its price to get what it cost

   $\text{6 × \$65.00 = \$390.00; 15 × \$44.00 = \$660.00; 20 × \$25.00 = \$500.00; 16 × \$38.00 = \$608.00; 9 × \$50.00 = \$450.00}$

2. Add up all the shares you bought

   $6+15+20+16+9$$=66$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,608.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,608.00}}{66}$$=\mathrm{\$39.52}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$44.40}$

6. Find what your shares are worth now, at $50.00 a share

   $66\times \mathrm{\$50.00}$$=\mathrm{\$3,300.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,300.00}-\mathrm{\$2,608.00}}{\mathrm{\$2,608.00}}\times 100$$=\mathrm{26.5337\%}$

3. Average cost per share: $34.30

1. Find how many shares each $475.00 purchase buys: the amount ÷ that day's price, so lower prices buy more

   $\text{\$475.00 ÷ \$50.00 = 9.5; \$475.00 ÷ \$26.00 = 18.2692; \$475.00 ÷ \$24.00 = 19.7917; \$475.00 ÷ \$36.00 = 13.1944; \$475.00 ÷ \$56.00 = 8.4821}$

2. Add up all the shares you bought

   $9.5+18.2692+19.7917+13.1944+8.4821$$=69.2375$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,375.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,375.00}}{69.2375}$$=\mathrm{\$34.30}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$38.40}$

6. Find what your shares are worth now, at $56.00 a share

   $69.2375\times \mathrm{\$56.00}$$=\mathrm{\$3,877.30}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,877.30}-\mathrm{\$2,375.00}}{\mathrm{\$2,375.00}}\times 100$$=\mathrm{63.2547\%}$

4. Average cost per share: $37.31

1. Find how many shares each $600.00 purchase buys: the amount ÷ that day's price, so lower prices buy more

   $\text{\$600.00 ÷ \$60.00 = 10; \$600.00 ÷ \$26.00 = 23.0769; \$600.00 ÷ \$28.00 = 21.4286; \$600.00 ÷ \$55.00 = 10.9091; \$600.00 ÷ \$40.00 = 15}$

2. Add up all the shares you bought

   $10+23.0769+21.4286+10.9091+15$$=80.4146$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$3,000.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$3,000.00}}{80.4146}$$=\mathrm{\$37.31}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$41.80}$

6. Find what your shares are worth now, at $40.00 a share

   $80.4146\times \mathrm{\$40.00}$$=\mathrm{\$3,216.58}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,216.58}-\mathrm{\$3,000.00}}{\mathrm{\$3,000.00}}\times 100$$=\mathrm{7.2194\%}$

5. Average cost per share: $36.63

1. Find how many shares each $600.00 purchase buys: the amount ÷ that day's price, so lower prices buy more

   $\text{\$600.00 ÷ \$46.00 = 13.0435; \$600.00 ÷ \$38.00 = 15.7895; \$600.00 ÷ \$26.00 = 23.0769; \$600.00 ÷ \$40.00 = 15; \$600.00 ÷ \$40.00 = 15}$

2. Add up all the shares you bought

   $13.0435+15.7895+23.0769+15+15$$=81.9099$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$3,000.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$3,000.00}}{81.9099}$$=\mathrm{\$36.63}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$38.00}$

6. Find what your shares are worth now, at $40.00 a share

   $81.9099\times \mathrm{\$40.00}$$=\mathrm{\$3,276.40}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,276.40}-\mathrm{\$3,000.00}}{\mathrm{\$3,000.00}}\times 100$$=\mathrm{9.2132\%}$

6. Average cost per share: $34.80

1. Find how many shares each $550.00 purchase buys: the amount ÷ that day's price, so lower prices buy more

   $\text{\$550.00 ÷ \$40.00 = 13.75; \$550.00 ÷ \$44.00 = 12.5; \$550.00 ÷ \$22.00 = 25; \$550.00 ÷ \$36.00 = 15.2778; \$550.00 ÷ \$44.00 = 12.5}$

2. Add up all the shares you bought

   $13.75+12.5+25+15.2778+12.5$$=79.0278$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,750.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,750.00}}{79.0278}$$=\mathrm{\$34.80}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$37.20}$

6. Find what your shares are worth now, at $44.00 a share

   $79.0278\times \mathrm{\$44.00}$$=\mathrm{\$3,477.22}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,477.22}-\mathrm{\$2,750.00}}{\mathrm{\$2,750.00}}\times 100$$=\mathrm{26.4444\%}$

7. Average cost per share: $38.90

1. Multiply each purchase's shares by its price to get what it cost

   $\text{11 × \$42.00 = \$462.00; 15 × \$37.00 = \$555.00; 20 × \$22.00 = \$440.00; 13 × \$50.00 = \$650.00; 11 × \$56.00 = \$616.00}$

2. Add up all the shares you bought

   $11+15+20+13+11$$=70$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,723.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,723.00}}{70}$$=\mathrm{\$38.90}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$41.40}$

6. Find what your shares are worth now, at $56.00 a share

   $70\times \mathrm{\$56.00}$$=\mathrm{\$3,920.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,920.00}-\mathrm{\$2,723.00}}{\mathrm{\$2,723.00}}\times 100$$=\mathrm{43.9589\%}$

8. Average cost per share: $39.25

1. Multiply each purchase's shares by its price to get what it cost

   $\text{8 × \$50.00 = \$400.00; 10 × \$50.00 = \$500.00; 24 × \$25.00 = \$600.00; 11 × \$44.00 = \$484.00; 11 × \$48.00 = \$528.00}$

2. Add up all the shares you bought

   $8+10+24+11+11$$=64$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,512.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,512.00}}{64}$$=\mathrm{\$39.25}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$43.40}$

6. Find what your shares are worth now, at $48.00 a share

   $64\times \mathrm{\$48.00}$$=\mathrm{\$3,072.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,072.00}-\mathrm{\$2,512.00}}{\mathrm{\$2,512.00}}\times 100$$=\mathrm{22.293\%}$

9. Average cost per share: $37.69

1. Multiply each purchase's shares by its price to get what it cost

   $\text{8 × \$50.00 = \$400.00; 10 × \$40.00 = \$400.00; 22 × \$25.00 = \$550.00; 15 × \$40.00 = \$600.00; 10 × \$50.00 = \$500.00}$

2. Add up all the shares you bought

   $8+10+22+15+10$$=65$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,450.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,450.00}}{65}$$=\mathrm{\$37.69}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$41.00}$

6. Find what your shares are worth now, at $50.00 a share

   $65\times \mathrm{\$50.00}$$=\mathrm{\$3,250.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,250.00}-\mathrm{\$2,450.00}}{\mathrm{\$2,450.00}}\times 100$$=\mathrm{32.6531\%}$

10. Average cost per share: $38.46

1. Find how many shares each $540.00 purchase buys: the amount ÷ that day's price, so lower prices buy more

   $\text{\$540.00 ÷ \$50.00 = 10.8; \$540.00 ÷ \$40.00 = 13.5; \$540.00 ÷ \$25.00 = 21.6; \$540.00 ÷ \$40.00 = 13.5; \$540.00 ÷ \$50.00 = 10.8}$

2. Add up all the shares you bought

   $10.8+13.5+21.6+13.5+10.8$$=70.2$

3. Add up everything you put in

   $\text{total invested}$$=\mathrm{\$2,700.00}$

4. Find what you paid per share on average: total invested ÷ total shares

   $\frac{\mathrm{\$2,700.00}}{70.2}$$=\mathrm{\$38.46}$

5. For comparison, find the plain average of the prices, ignoring how many shares each bought

   $\frac{\text{sum of 5 prices}}{5}$$=\mathrm{\$41.00}$

6. Find what your shares are worth now, at $50.00 a share

   $70.2\times \mathrm{\$50.00}$$=\mathrm{\$3,510.00}$

7. Show the gain or loss as a percentage of what you put in

   $\frac{\mathrm{\$3,510.00}-\mathrm{\$2,700.00}}{\mathrm{\$2,700.00}}\times 100$$=\mathrm{30\%}$