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
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-4A
Name:
Section:
1
2
3
4
Since depreciation cannot cause book value to fall below residual value:
Year –= Yearly Depreciation
5
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 800,000$
1142,000$ 142,000$ 658,000
2142,000 284,000 516,000
b.
Accumulated
Depreciation Depreciation, Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1320,000$ 320,000$ 480,000
Double-Declining-Balance Depreciation Schedule
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-4A
Name:
Solution
Section:
ON
2480,000$ 0.400000 192,000$