In cell b7, enter a formula using the function for the accelerated, or sum-of-the-years' digits (soyd), depreciation method.

a. use the cell names cost and salvage for the cost and salvage function arguments.

b. use the appropriate cell reference for the life argument.

c. use the appropriate cell reference for the per argument.

d. be sure to use the appropriate cell reference types to allow you to copy the formula to the rest of the column.