Please solve this problem directly on Excel spreadsheet ONLY.

Make sure to include the calculations performed using Excel formulas.

Sarah Smith purchased some vacant land on February 1, Year 1 for $30,000, hoping to build a cabin on the land when she had saved enough money for construction of the cabin. While she was saving her money, Sarah rented the land in Year I (entire year) to a farmer as pasture for an annual rent of $1,000. During this year, Sarah also paid $300 in property taxes and $4,000 in interest on funds borrowed to purchase the land. At the beginning of Year 2, construction began on a six-lane highway that will intersect the neighbouring property to Sarah's vacant land. Due to the close proximity of the new highway, Sarah decided to sell the land for proceeds of disposition of $20,000. Required: Calculate the Net 'Income (Loss) For Tax Purposes to be reported for each of Year 1 11 , 12 13 and Year 2 resulting from the transactions described above. 15 Solution: 16 17 In Year l, Sarah rented the land: 18 Gross rents 19 Less rental expenses 20 21 22 23 24 25 26 27 28 29 property tax and interest Excess costs $0 This excess property tax and interest will be added to thecost base of the land Sarah will report net rental income/loss ofnil. In year 2, Sarah sold the land: Calculation of Capital Gain: Proceeds of disposition Adjusted cost base Capital Gain (loss) Capital Gains reserve Capital Loss Inclusion rate Allowable capital loss Year 2 0.50 30 31 32 33 34 35