Calculate the cumulative principal payments as follows:

a$.$ In cell G$10,$ enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year $1($payment $1$ in cell $G7$ through payment $12$ in cell $($G$).$ Use $0$ as the type argument in your formula because payments are made at the end of the period.

b$.$ Use absolute references for the rate, nper, and pv arguments, which are listed in the range D$6$:D$12.$

c$.$ Use relative references for the start and end arguments.

d$.$ Fill the range H$10$:K$10$ with the formula in cell G$10$ to calculate the principal paid in Years $2-5$ and the total principal.

Go to the Depreciation worksheet. Hwan needs to correct the errors on this worksheet before he can perform any depreciation calculations.

Correct the errors as follows:

a$.$ Use Trace Dependents arrows to determine whether the #VALUE! error in cell D$20$ is causing the other errors in the worksheet.

b$.$ Use Trace Precedents arrows to find the source of the error in cell D$20.$

c$.$ Correct the error so that the formula in cell D$20$ calculates the cumulative declining balance depreciation of the hardware by adding the cumulative depreciation value in Year $1$ to the annual depreciation value in Year $2.$

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 C$12,$ 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 C$12$ to calculate the annual and cumulative straight$-$line depreciation in Years $2-6.$