In the Depreciation worksheet, enter the initial investment value of the condo that Gary wants to purchase by inserting a reference to cell B5 in the Real Estate Data worksheet. Set the savage value of the condo to 160000 after 10 years.
In rental income worksheet, project the income and expense associated with owning the condo. In cell b6, enter the year 1 rental income as equal to 1/12 of the assessed value of the condo from the real estate data worksheet.
In the range B7:K7 enter the formula that the reference each each corresponding value in the range b6:K6
Please explain all the steps very clearly.