Chapter $10,$ Homework Problem No$.2$

The following assets were placed in service during the year:

Asset

Date Acquired Cost Basis

Commercial Building

$\frac{3}{23}\frac{?}{2022}$

$250,000$

Apartment Building

$\frac{9}{17}\frac{?}{2022}$

$477,000$

Assume $179$ expensing and bonus depreciation does not apply to either property.

Required:

Compute $2022$ tax depreciation for each building on a tab labeled "Part a$"$ in an Excel spreadsheet. You must use formulas in your calculations.

Compute $2023$ tax depreciation for each building on a tab labeled "Part b$"$ in the Excel spreadsheet. You must use formulas in your calculations.

The Excel spreadsheet $($Parts a and b should have separate columns for each of the followi