Using MICROSOFT Excel ONLY, respond to the following requirements. All work must be shown to obtain full marks.

Prepare a critical thinking analysis to determine whether the sale of the cottage would be considered business income or a capital gain. If you determine the sale would be a capital gain, then determine whether it would qualify for the principal residence exemption.

Prepare a calculation to determine the best use of the principal residence exemption. Clearly indicate the years designated to each property included in your analysis.

Determine John’s minimum Business Income for 2022.

Determine the minimum Net Income for Tax Purposes and Taxable Income for John, Mary, Dean, Rowena, Crowley and Castiel. Ignore any GST or PST considerations. Show all work, even if the result is zero.

Determine any amounts available for carry forward by the family at the end of 2022.