$8.$ Pranjali also wants to determine the depreciation balance for the first year and the last year of the useful life of the medical van.

Determine these amounts as follows:

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

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

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

d$.$ Use Year $7($cell I$17)$ as the current period.