Hwan also wants to determine the depreciation balance for the first year and the last year of the usefulfife of the product hardware.

Determine these amounts as follows:

a$.$ In cell E$23,$ enter a formula using the SYD function to calculate the depreciation balance for the first year.

b$.$ Use Year $1($cell C$18)$ as the current period.

c$.$ In cell E$24,$ enter a formula using the SYD function to calculate the depreciation balance for the last year.

d$.$ Use Year $6($cell H$18)$ as the current period.

Create a formula using a function.

In the Depreciation worksheet, the formula in cell E$23$ should use a relative reference to cell D$6$ as the cost argument.

Create a formula using a function.

In the Depreciation worksheet, the formula in cell E$24$ should use a relative reference to cell D$6$ as the cost argument.