I. Depreciation

Metro Co. purchased equipment for $212,000 on 9/1/x1. It is estimated that the equipment will have a useful life of 8 years and a salvage value of $12,000. Estimated production is 40,000 units and estimated working hours 20,000. During 20x1, Metro used the equipment for 525 hours and the equipment produced 1,000 units.

Compute depreciation expense under each of the following methods. Metro is on a calendar-year basis ending December 31. Show your computation. If not, no partial credit

a) Sum-of-the-years' method for 20x3 (1/1/x3 ~ 12/31/x3)

b) Double-declining balance method for 20x2 (1/1/x2 ~ 12/31/x2)

c) Activity method (units of output) for 20x1 (1/1/x1 ~ 12/31/x1)

Please excel to answer