Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Straight- Units of Double-Declining-
2012
2013
2014
2015
Totals
/ 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
/ 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$
Calculations:
Straight-line method:
For full year:
(Cost – Residual Value) / Years =Yearly Depreciation
108,000$ 7,200$ 3 33,600$
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.