Answer:
See the attached excel file for the depreciation schedule for the three alternative methods.
Explanation:
a. Double-declining-balance.
Note: See part a of the attached excel file for the depreciation schedule for Double-declining-balance method.
In the attached excel file, the depreciation rate used for the Double-declining-balance method is calculated as follows:
Straight line depreciation rate = 1 / Estimated useful life = 1 / 4 = 0.25, or 25%
Double-declining depreciation rate = Straight line depreciation rate * 2 = 25% * 2 = 50%
b. Units-of-production.
Note: See part b of the attached excel file for the depreciation schedule for Units-of-production method.
c. Straight-line.
Note: See part b of the attached excel file for the depreciation schedule for Straight-line method.
In the attached excel file, the depreciation rate used for the Straight-line method is calculated as follows:
Straight line depreciation rate = 1 / Estimated useful life = 1 / 4 = 0.25, or 25%