An asterisk (*) will appear to the right of an incorrect entry.
a. b. c.
Straight- Units of Double-Declining-
Year Line Production Balance
2012
2013
2014
2015
Totals
Calculations:
Straight-line method:
For full year:
(Cost
– Residual Value)
/ Years =Yearly Depreciation
For part years:
2012 Depreciation x Portion of Year = Depreciation
2015 Depreciation x Portion of Year = Depreciation
Units-of-production method:
(Cost
– Residual Value)
/ Total Hours =Rate
Rate xHours =Yearly Depreciation
2012
2013
2014
2015
Double-declining-balance method:
Key Code:
Instructions
Depreciation Expense
Cells with non-gray backgrounds are protected and cannot be edited.
Yearly
Depreciation
Answers are entered in the cells with gray backgrounds.
0%
[Key code here]
Depreciable
Balance
Problem 10-3A
Name:
Section:
Score:
xRate xPortion of Year =
2012
2013
2014
Since depreciation cannot cause book value to fall below residual value:
– =Yearly Depreciation
2015
Yearly
Depreciation
Depreciable
Balance
Residual
Value
Depreciable
Balance
An asterisk (*) will appear to the right of an incorrect entry.
a. b. c.
Straight- Units of Double-Declining-
Year Line Production Balance
2012 65,250$ 108,750$ 135,000$
2013 87,000 79,750 90,000
Calculations:
Straight-line method:
For full year:
(Cost
– Residual Value)
– Residual Value)
/ Years =Yearly Depreciation
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 10-3A
Name:
Solution
Section:
ON
Depreciation Expense
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
