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

question 50

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?

---

Definitions:

Canadian Jurisdictions

The areas of authority within Canada, including federal, provincial, and territorial levels, each with its own set of laws and regulations.

Authorization Cards

Documents signed by employees to indicate their wish to be represented by a union, often used in the process of forming a union within a workplace.

Collective Agreement

A written contract negotiated between an employer and a union representing the employees, outlining terms of employment.

Union Shop

Provision of the collective agreement that requires employees to join the union as a condition of their employment.