Please solve this problem directly on Excel spreadsheet. Make sure to include the calculations performed using Excel formulas.

Sharon Slotten purchased shares in ATCO Ltd. during the current year as follows: Jan. l: 200 shares for $25 per share April 2: 300 shares for $30 per share July l: 100 shares sold for $45 per share Sept. 8: 500 shares for $24 per share On December 22, of the current year Sharon sells 200 ATCO Ltd. shares for $35 per share and pays S 100 in sales commission. Required: Calculate the taxable capital gain or loss included in Sharon's NET INCOME under 11 12 13 14 15 17 18 19 21 paragraph 3(b) of the Income Tax Act. Solution: Date Jan.l Apr.2 Subtotal No. ofshares Ol-Jul Sept.8 Total Calculation of Capital Gain: Proceeds of disposition Selling costs Adjusted cost base Cost per share Ol-Jul Cost in Pool Dec.22 22 23 24 25 26 27 28 29 31 32 33 Capital Gain (loss) Capital Gains reserve Capital Gain Inclusion rate Taxable capital gain Total