Hwan wants to compare straight$-$line depreciation amounts with declining balance depreciation amounts to determine which method is more favorable for his company's balance sheet. In the range D$6$:D$8,$ he estimates that the hardware for the new product will have $$478,000$ in tangible assets at startup, and that the useful life of these assets is six years with a salvage value of $$75,650.$

Start by calculating the straight$-$line depreciation amounts as follows:

a$.$ In cell $C12,$ enter a formula using the SLN function to calculate the straight$-$line depreciation for the product hardware during the first year.

b$.$ Use absolute references for the cost, salvage, and life arguments in the SLN formula.

c$.$ Fill the range D$12$:H$12$ with the formula in cell $C12$ to calculate the annual and cumulative straight$-$line depreciation in Years $2-6.$

Create a formula using a function.

In the Depreciation worksheet, the formula in cell C$12$ has not been entered correctly.

Copy a formula into a range.

In the Depreciation worksheet, cell C $12$ contains an incorrect formula.

a$.$ In cell C$19,$ enter a formula using the DB function to calculate the declining balance depreciation for the hardware during the first year of operation.

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

c$.$ Use absolute references only for the cost, salvage, and life arguments in the DB formula.

d$.$ Fill the range D$19$:H$19$ with the formula in cell $C19$ to calculate the annual and cumulative declining balance depreciation in Years $2-6.$

Create a formula using a function.

In the Depreciation worksheet, the formula in cell C$19$ should use a relative reference to cell C $18$ as the period argument.

Copy a formula into a range.

In the Depreciation worksheet, cell C$19$ contains an incorrect formula.