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 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.

X 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.

X 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.