Asset depreciation method comparison: An excel-based classroom exercise

Donald Conant,Suzanne Chaille
DOI: https://doi.org/10.1080/08832323.2021.1967841
2021-08-23
Journal of Education for Business
Abstract:In response to research indicating a need for an increased emphasis on aspects of corporate accounting, including corporate taxation, in the accounting curriculum as well as employer expectations that entry-level accounting position applicants possess Excel skills, this classroom exercise uses Excel to compare the financial impacts of three methods of asset depreciation. In this paper, we use Excel to model the effects of the straight line, declining balance, and MACRS depreciation methods on the annual and accumulated depreciation amounts of a company's assets. This exercise also builds student competency with data entry, important Excel functions, and worksheet error handling.
What problem does this paper attempt to address?