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
2.
3.
Depreciable
Balance
Residual
Value
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.
Instructions
Straight-Line Depreciation Schedule
Problem 9-4B
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 25,625$ 25,625$ 84,375
b.
Accumulated
Depreciation
Depreciation,
Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
1 55,000$ 55,000$ 55,000
Double-Declining-Balance Depreciation Schedule
Straight-Line Depreciation Schedule
Cells with non-gray backgrounds are protected and cannot be edited.
Instructions
Answers are entered in the cells with gray backgrounds.
Problem 9-4B
Solution
ON