An asterisk (*) will appear to the right of an incorrect entry.
Straight- Units of Double-Declining-
Year Line Production Balance
2014 65,250$ 108,750$ 135,000$
2015 87,000 79,750 90,000
2016 87,000 58,000 30,000
2017 21,750 14,500 6,000
Totals 261,000$ 261,000$ 261,000$
For part years:
2014 Depreciation x Portion of Year = Depreciation
87,000$ 0.7500 65,250$
Units-of-production method:
(Cost
/ Total Hours =Rate
270,000$ 9,000$ 18,000 $14.50
Rate xHours =Yearly Depreciation
2014 $14.50 7,500 108,750$
2015 $14.50 5,500 79,750
Double-declining-balance method:
xRate xPortion of Year =
Since depreciation cannot cause book value to fall below residual value:
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
− Residual Value)