An asterisk (*) will appear to the right of an incorrect entry.
1.
a. b. c.
Straight- Units of Double-Declining-
Year Line Production Balance
2013
2014
2015
2016
Totals
Calculations:
Straight-line method:
(Cost
– Residual Value)
/ Years =Yearly Depreciation
Units-of-production method:
(Cost
– Residual Value)
/ Total Hours =Rate
Rate xHours =Yearly Depreciation
2013
2014
2015
2016
Double-declining-balance method:
xRate =Yearly Depreciation
2013
2014
2015
Since depreciation cannot cause book value to fall below residual value:
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Depreciable
Balance
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Depreciation Expense
Problem 10-2B
Name:
Section:
– =Yearly Depreciation
2016
2.
The method that yields the most depreciation expense in 2013 is the
3.
The method that yields the most total depreciation over the four years is the
Depreciable
Balance
Residual
Value
An asterisk (*) will appear to the right of an incorrect entry.
1.
a. b. c.
Straight- Units of Double-Declining-
Year Line Production Balance
2013 71,250$ 102,600$ 160,000$
2014 71,250 91,200 80,000
Instructions
Answers are entered in the cells with gray backgrounds.
ON
Depreciation Expense
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 10-2B
Name:
Solution
Section:
Score:
– =Yearly Depreciation
Depreciable
Balance
Residual
Value