An asterisk (*) will appear to the right of an incorrect entry.
a. b. c.
Straight- Units of Double-Declining-
Year Line Output Balance
2014
2015
2016
2017
Totals
Calculations:
Straight-line method:
For full year:
(Cost
− Residual Value)
/ Years =Yearly Depreciation
For part year 2014:
Yearly Depreciation x Portion of Year = Depreciation
For part year 2017:
Yearly Depreciation x Portion of Year = Depreciation
Units-of-output method:
(Cost
− Residual Value)
/ Total Hours = Rate
Rate xHours = Yearly Depreciation
2014
2015
2016
2017
Double-declining-balance method:
xRate xPortion of Year =
2014
2015
2016
Since depreciation cannot cause book value to fall below residual value:
[Key code here]
Depreciable
Balance
Problem 10-3B
Name:
Section:
Yearly
Depreciation
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
0%
−=Yearly Depreciation
2017
Depreciable
Balance
Residual
Value
An asterisk (*) will appear to the right of an incorrect entry.
a. b. c.
Straight- Units of Double-Declining-
Year Line Output Balance
2014 8,400$ 11,340$ 18,000$
2015 33,600 35,280 60,000
Calculations:
Straight-line method:
For full year:
(Cost
− Residual Value)
/ Years =Yearly Depreciation
108,000$ 7,200$ 3 33,600$
For part year 2014:
Yearly Depreciation x Portion of Year = Depreciation
Units-of-output method:
(Cost
− Residual Value)
/ Total Hours = Rate
108,000$ 7,200$ 12,000 $8.40
Rate xHours = Yearly Depreciation
2014 $8.40 1,350 11,340$
Double-declining-balance method:
xRate xPortion of Year =
2014 108,000$ 0.666667 0.2500 18,000$
Since depreciation cannot cause book value to fall below residual value:
Yearly
Depreciation
ON
Depreciable
Balance
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 10-3B
Name:
Solution
Section:
−=Yearly Depreciation
Depreciable
Balance
Residual
Value
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1
2
3
4
5
Calculation:
(Cost
– Residual Value) / Years = Yearly Depreciation
b.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1
2
3
4
5
Calculations:
Year xRate = Yearly Depreciation
1
2
3
4
Since depreciation cannot cause book value to fall below residual value:
Year –= Yearly Depreciation
5
Straight-Line Depreciation Schedule
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 10-4A
Name:
Section:
0%
[Key code here]
Double-Declining-Balance Depreciation Schedule
Residual
Value
Depreciable
Balance
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Depreciable
Balance
2.
3.
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1142,000$ 142,000$ 658,000
2142,000 284,000 516,000
Calculation:
(Cost
− Residual Value)
/ Years = Yearly Depreciation
b.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1320,000$ 320,000$ 480,000
2192,000 512,000 288,000
Calculations:
Year xRate = Yearly Depreciation
1800,000$ 0.400000 320,000$
Since depreciation cannot cause book value to fall below residual value:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 10-4A
Name:
Solution
Section:
ON
Straight-Line Depreciation Schedule
Depreciable
Balance
Cells with non-gray backgrounds are protected and cannot be edited.
Depreciable
Residual
Double-Declining-Balance Depreciation Schedule
2.
696,320
3.
Loss on Sale of Equipment
696,320
Accumulated Depreciation
Accumulated Depreciation
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
1
2
3
4
Calculation:
(Cost – Residual Value) / Years = Yearly Depreciation
b.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
1
2
3
4
Calculations:
Year xRate = Yearly Depreciation
1
2
3
Since depreciation cannot cause book value to fall below residual value:
Year –= Yearly Depreciation
4
Depreciable
Balance
Residual
Value
Straight-Line Depreciation Schedule
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Double-Declining-Balance Depreciation Schedule
Problem 10-4B
Name:
Section:
Depreciable
Balance
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
2.
3.
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
125,625$ 25,625$ 84,375
225,625 51,250 58,750
Calculation:
(Cost
− Residual Value)
/ Years = Yearly Depreciation
b.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
155,000$ 55,000$ 55,000
227,500 82,500 27,500
Calculations:
Year xRate = Yearly Depreciation
1110,000$ 0.500000 55,000$
Since depreciation cannot cause book value to fall below residual value:
Year − = Yearly Depreciation
Straight-Line Depreciation Schedule
Depreciable
Balance
Cells with non-gray backgrounds are protected and cannot be edited.
Depreciable
Balance
Residual
Value
Double-Declining-Balance Depreciation Schedule
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 10-4B
Name:
Solution
Section:
ON
2.
96,250
3.
Loss on Sale of Equipment
96,250
Accumulated Depreciation
Accumulated Depreciation