Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Accumulated
Depreciation
Book Value,
Year Expense End of Year End of Year
Original cost 110,000$
1
2
3
4
(Cost – Residual Value) / Years = Yearly Depreciation
b.
Accumulated
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
Cells with non-gray backgrounds are protected and cannot be edited.
Double-Declining-Balance Depreciation Schedule
Answers are entered in the cells with gray backgrounds.
Straight-Line Depreciation Schedule
An asterisk (*) will appear to the right of an incorrect entry.
1. a.
Year Expense End of Year End of Year
Original cost 110,000$
1 25,625$ 25,625$ 84,375
b.
Accumulated
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.
Answers are entered in the cells with gray backgrounds.