Hwan also wants to determine the depreciation balance for the first year and the last year of the useful life of the product hardware.
Determine these amounts as follows:
a. In cell E23, enter a formula using the SYD function to calculate the depreciation balance for the first year.
b. Use Year 1 (cell C18) as the current period.
c. In cell E24, enter a formula using the SYD function to calculate the depreciation balance for the last year.
