Please respond on excel only and $1$ tab only otherwise the assignment will not be Graded

John Lackey lives in Northern Ontario. He is an employee of the Canadian Tire Corporation. In $2023$ his employment income was $$61,500\mathrm{.}00($t$-4).$ Also he received interest income of $$2,600\mathrm{.}00$ and taxable non eligible dividend income of $$5,000.$This dividend also has a dividend tax credit of $$1,500.$

John also owns a sole proprietorship called Lackey$$s Small Repairs. The business was profitable until $2023$ where he had a business loss of $$10,750\mathrm{.}00.$ He tells you that in the addition of the business loss, he has obsolete inventory that he has accumulated over the year. The inventory cost of $$20,750$ and Mr$.$ Lackey was wondering if he could get capital loss to apply to his capital gains for the current year.

In addition, Mr$.$ Lackey also has net rental income of $ $4,500.$

Mr$.$ Lackey also has investments in share of Bell Canada and Enbridge Inc.In $2020$ he purchased Bell shares $2000$@ $$200\mathrm{.}00$ each and Enbridge $1,500$ shares @ $75\mathrm{.}00$ each. During $2023$ the year he sold Bell Shares $200$ @ $$175\mathrm{.}00$ and Enbridge shares $200$ @ $$150\mathrm{.}00.$ These transactions were on December $1,2023.$ On December $20$ Mr$..$Lackey purchased $300$ share of Bell Stock @ $$180\mathrm{.}00$ and $250$ shares of Enbridge Stock @ $$145\mathrm{.}00.$ MR Lackey is hoping that the capital loss will negate the capital gains.

Mr$.$ Lackey sold his Principal Residence in June $2023$ for $ $750,000$ and his purchase price was $$425,000\mathrm{.}00$ back in $1999.$ He then moved to his camp which used to be rented out until June $2023.$ The cost of the camp and the UCC was $$250,000\mathrm{.}00$ and the FMV was $$375,000($Mr$.$ Lackey never took CCA as he was going to retire at camp, he purchased in $2010)$

Please calculate the division B Income, Capital Loss carry forward $($if any$).$ Show all of your calculation for the stock transactions for the inclusion or exclusion in the Division B Income. Also show the ACB of the Bell and Enbridge Stock.

Show all calculation with regards to the principal residence rule and the tax consequence of moving to the Camp. Please note any solution that is $0\mathrm{.}00$ insert this amount or put nil, otherwise it will be marked that you did not respond lose a mark

Please do in excel sheet and compute in entries and show all the calculation.