April 1, 20X8 Victoria sold 2,000 shares of River Ltd. for $20 per share and she pays 1,000 commission for CIBC Investor Edge, to handle this transaction. The original of the shares; she had inherited 1,500 of the shares from her late father in 20X4. Her father had paid $ 7 per share when he purchased the shares in 20X1, and the fair market value at the time of his death was 12 per share. Also, In 20X5 Victoria purchased an additional 1,500 shares for 14 per share, and paid $300 commission.

How to calculate the taxable capital gain for Victoria in the excel.