Stock Average worksheet

1. Average cost per share: $33.53

1. Find what each purchase cost: its shares times its price

   $\text{92 × \$50.00 = \$4,600.00; 56 × \$32.00 = \$1,792.00; 150 × \$24.00 = \$3,600.00}$

2. Add up all the shares you bought

   $92+56+150$$=298$

3. Add up what you spent on all of them

   $\mathrm{\$4,600.00}+\mathrm{\$1,792.00}+\mathrm{\$3,600.00}$$=\mathrm{\$9,992.00}$

4. Divide the total cost by the total shares. This is your average cost per share

   $\frac{\mathrm{\$9,992.00}}{298}$$=\mathrm{\$33.53}$

2. Shares to buy: 24.0741

1. Find what your current shares cost in total: shares times average cost

   $130\times \mathrm{\$60.00}$$=\mathrm{\$7,800.00}$

2. Buying x more shares makes the new average (old cost + x × new price) ÷ (old shares + x). Set that equal to your target and solve for x

   $x$$=\frac{130\times \mathrm{\$60.00}-\mathrm{\$55.00}}{\mathrm{\$55.00}-\mathrm{\$28.00}}$$=24.0741$

3. Find what the new shares cost

   $24.0741\times \mathrm{\$28.00}$$=\mathrm{\$674.07}$

4. Check it: the total cost divided by the total shares lands on your target

   $\frac{\mathrm{\$7,800.00}+\mathrm{\$674.07}}{130+24.0741}$$=\mathrm{\$55.00}$

3. Shares to buy: 708.3333

1. Find what your current shares cost in total: shares times average cost

   $170\times \mathrm{\$65.00}$$=\mathrm{\$11,050.00}$

2. Buying x more shares makes the new average (old cost + x × new price) ÷ (old shares + x). Set that equal to your target and solve for x

   $x$$=\frac{170\times \mathrm{\$65.00}-\mathrm{\$40.00}}{\mathrm{\$40.00}-\mathrm{\$34.00}}$$=708.3333$

3. Find what the new shares cost

   $708.3333\times \mathrm{\$34.00}$$=\mathrm{\$24,083.33}$

4. Check it: the total cost divided by the total shares lands on your target

   $\frac{\mathrm{\$11,050.00}+\mathrm{\$24,083.33}}{170+708.3333}$$=\mathrm{\$40.00}$

4. Average cost per share: $29.81

1. Find what each purchase cost: its shares times its price

   $\text{108 × \$35.00 = \$3,780.00; 58 × \$30.00 = \$1,740.00; 150 × \$26.00 = \$3,900.00}$

2. Add up all the shares you bought

   $108+58+150$$=316$

3. Add up what you spent on all of them

   $\mathrm{\$3,780.00}+\mathrm{\$1,740.00}+\mathrm{\$3,900.00}$$=\mathrm{\$9,420.00}$

4. Divide the total cost by the total shares. This is your average cost per share

   $\frac{\mathrm{\$9,420.00}}{316}$$=\mathrm{\$29.81}$

5. Average cost per share: $31.36

1. Find what each purchase cost: its shares times its price

   $\text{85 × \$40.00 = \$3,400.00; 60 × \$25.00 = \$1,500.00; 150 × \$29.00 = \$4,350.00}$

2. Add up all the shares you bought

   $85+60+150$$=295$

3. Add up what you spent on all of them

   $\mathrm{\$3,400.00}+\mathrm{\$1,500.00}+\mathrm{\$4,350.00}$$=\mathrm{\$9,250.00}$

4. Divide the total cost by the total shares. This is your average cost per share

   $\frac{\mathrm{\$9,250.00}}{295}$$=\mathrm{\$31.36}$

6. Shares to buy: 220

1. Find what your current shares cost in total: shares times average cost

   $220\times \mathrm{\$45.00}$$=\mathrm{\$9,900.00}$

2. Buying x more shares makes the new average (old cost + x × new price) ÷ (old shares + x). Set that equal to your target and solve for x

   $x$$=\frac{220\times \mathrm{\$45.00}-\mathrm{\$38.00}}{\mathrm{\$38.00}-\mathrm{\$31.00}}$$=220$

3. Find what the new shares cost

   $220\times \mathrm{\$31.00}$$=\mathrm{\$6,820.00}$

4. Check it: the total cost divided by the total shares lands on your target

   $\frac{\mathrm{\$9,900.00}+\mathrm{\$6,820.00}}{220+220}$$=\mathrm{\$38.00}$

7. Average cost per share: $33.00

1. Find what each purchase cost: its shares times its price

   $\text{100 × \$39.00 = \$3,900.00; 50 × \$45.00 = \$2,250.00; 150 × \$25.00 = \$3,750.00}$

2. Add up all the shares you bought

   $100+50+150$$=300$

3. Add up what you spent on all of them

   $\mathrm{\$3,900.00}+\mathrm{\$2,250.00}+\mathrm{\$3,750.00}$$=\mathrm{\$9,900.00}$

4. Divide the total cost by the total shares. This is your average cost per share

   $\frac{\mathrm{\$9,900.00}}{300}$$=\mathrm{\$33.00}$

8. Shares to buy: 300

1. Find what your current shares cost in total: shares times average cost

   $180\times \mathrm{\$44.00}$$=\mathrm{\$7,920.00}$

2. Buying x more shares makes the new average (old cost + x × new price) ÷ (old shares + x). Set that equal to your target and solve for x

   $x$$=\frac{180\times \mathrm{\$44.00}-\mathrm{\$34.00}}{\mathrm{\$34.00}-\mathrm{\$28.00}}$$=300$

3. Find what the new shares cost

   $300\times \mathrm{\$28.00}$$=\mathrm{\$8,400.00}$

4. Check it: the total cost divided by the total shares lands on your target

   $\frac{\mathrm{\$7,920.00}+\mathrm{\$8,400.00}}{180+300}$$=\mathrm{\$34.00}$

9. Shares to buy: 1,700

1. Find what your current shares cost in total: shares times average cost

   $170\times \mathrm{\$50.00}$$=\mathrm{\$8,500.00}$

2. Buying x more shares makes the new average (old cost + x × new price) ÷ (old shares + x). Set that equal to your target and solve for x

   $x$$=\frac{170\times \mathrm{\$50.00}-\mathrm{\$30.00}}{\mathrm{\$30.00}-\mathrm{\$28.00}}$$=\mathrm{1,700}$

3. Find what the new shares cost

   $\mathrm{1,700}\times \mathrm{\$28.00}$$=\mathrm{\$47,600.00}$

4. Check it: the total cost divided by the total shares lands on your target

   $\frac{\mathrm{\$8,500.00}+\mathrm{\$47,600.00}}{170+\mathrm{1,700}}$$=\mathrm{\$30.00}$

10. Average cost per share: $32.93

1. Find what each purchase cost: its shares times its price

   $\text{92 × \$45.00 = \$4,140.00; 45 × \$36.00 = \$1,620.00; 180 × \$26.00 = \$4,680.00}$

2. Add up all the shares you bought

   $92+45+180$$=317$

3. Add up what you spent on all of them

   $\mathrm{\$4,140.00}+\mathrm{\$1,620.00}+\mathrm{\$4,680.00}$$=\mathrm{\$10,440.00}$

4. Divide the total cost by the total shares. This is your average cost per share

   $\frac{\mathrm{\$10,440.00}}{317}$$=\mathrm{\$32.93}$