Diamond Autobody purchased new equipment for $90,000. Residual value at the end of an estimated four-year service life is expected to be $10,000. During the four-year period, the company expects to use the equipment a total of 5,000 hours. Actual use per year was as follows:

Year	Hours Used
1	1,200
2	1,400
3	1,500
4	1,100

2. Prepare a depreciation schedule for four years using the double-declining-balance method. (Do not round your intermediate calculations.) DIAMOND AUTOBODY Depreciation Schedule-Double-Declining-Balance End of Year Amounts Year Depreciation Accumulated Expense Depreciation Book Value 1 $ 45,000 $ 45,000 $ 45,000 22,500 67,500 -22,500 X x Total $ 67,500 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 3. Prepare a depreciation schedule for four years using the activity-based method. (Round your "Depreciation Rate" to 3 decimal places and use this amount in all subsequent calculations.) DIAMOND AUTOBODY Depreciation Schedule-Activity-Based End of Year Amounts Depreciation Year Book Accumulated Expense Depreciation Value 16,200 $ 16,200 $ 73,800 18,900 X 35,100 $ 38,700 X 5,250 40,350 % -1,650 X 4 3,850 x 44,200 % -45,850 X Total $ 44,200 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. AWN