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 800,000$
1
2
3
4
5
Calculation:
(Cost
– Residual Value) / Years = Yearly Depreciation
b.
Accumulated
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
2.
3.
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.
Accumulated
Depreciation
Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1 142,000$ 142,000$ 658,000
b.
Accumulated
Depreciation
Book Value,
Year Expense End of Year End of Year
Original cost 800,000$
1 320,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.
Answers are entered in the cells with gray backgrounds.