Use spreadsheet functions for the depreciation methods
Microeconomics
The initial cost of the office equipment is $100,000 has an estimated actual life of 6 years, with an estimated salvage value of $10000. Prepare tables listing the annual costs of depreciation and the book value at the end of each 6 years, based on straight-line, sum-of-years’-digits, and MACRS depreciation. Use spreadsheet functions for the depreciation methods.
