You bought 200 shares of a stock at

\($17\) per share in 2001. After 12 months, the stock doubled in value, and you sold 100 shares. Eighteen months later, the stock reached \($60\) and split. After another year, the stock is now selling at \($52\) a share.

1. Calculate

(a) how much you received when you sold 100 shares in 2002;

(b) your capital gain;

(c) how many shares of this stock you own today.

(d) your gain on these shares.

2. Compute by using spreadsheet software to make these calculations.