The Depreciation Schedule for a Copier/printer Is Created in Excel

Essay

The depreciation schedule for a copier/printer is created in Excel. The cost of the asset is in Cell C4, the salvage value is in Cell C5, the length of service is in Cell C6, the depreciable amount is in Cell C7, and the sum of the years digits is in Cell C8. Column A contains the year, Column B contains the depreciable amount, Column C contains the fraction for the years remaining, Column D contains the annual depreciation, Column E contains the accumulated depreciation, and Column F contains the end-of-year book value. Using the sum of the year's digits method of depreciation, what formula should be keyed into Cell D11 to calculate the first-year annual depreciation?