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
Cells with non-gray backgrounds are protected and cannot be edited.
0%
[Key code here]
Double-Declining-Balance Depreciation Schedule
Depreciable
Balance
Answers are entered in the cells with gray backgrounds.
Score:
Key Code:
Instructions
Straight-Line Depreciation Schedule
Problem 10-4B
Name:
Section:
Since depreciation cannot cause book value to fall below residual value:
Year –= Yearly Depreciation
4
2.
3.
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 110,000$
125,625$ 25,625$ 84,375
Straight-Line Depreciation Schedule
Cells with non-gray backgrounds are protected and cannot be edited.
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 10-4B
Name:
Solution
Section:
ON
327,500$ 0.500000 13,750
Since depreciation cannot cause book value to fall below residual value: