Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
a. b. c.
Straight- Units of Double-Declining-
Year Line Output Balance
2012
2013
2014
2015
Totals
Calculations:
Straight-line method:
For full year:
(Cost – Residual Value) / Years =Yearly Depreciation
For part year 2012:
Yearly Depreciation x Portion of Year = Depreciation
For part year 2015:
Yearly Depreciation x Portion of Year = Depreciation
Units-of-output method:
(Cost – Residual Value) / Total Hours = Rate
Rate xHours = Yearly Depreciation
2012
2013
2014
2015
Double-declining-balance method:
xRate xPortion of Year =
2012
2013
2014
Since depreciation cannot cause book value to fall below residual value:
– =Yearly Depreciation
2015
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Straight- Units of Double-Declining-
2012 8,400$ 11,340$ 18,000$
2013 33,600 35,280 60,000
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
xRate xPortion of Year =
2012 108,000$ 0.666667 0.2500 18,000$
Depreciable
Balance