Use the information on the Given Data worksheet to prepare three depreciation schedules using the following methods: straight-line, double-declining balance, and activity-based. Given Data: AUBURN CAR WASH $ $ $ Cost of new car wash machines Estimated residual value Machine life in years Machine life in hours 800,000 50,000 5 10,000 Actual use per year: Hours Year Used 1 2,000 2 1,800 3 3 2,200 4 2,100 5 1,900 Auburn Car Wash Straight Line Rectangular Snip Calculation Depreciable Depreciation Cost Rate End of Year Amounts Depreciation Accumulated Book Expense Depreciation Value If you hover your mouse over a cell with a red flag you will see the comment Year 1 2 3 4 5 Total Auburn Car Wash Double-Declining-Balance Calculation Beginning Depreciation Book Value x Rate End of Year Amounts Depreciation Accumulated Book Expense Depreciation Value Year If you hover your mouse over a cell with a red flag you will see the comment 1 2 3 4 5 Total Note: for year 5 you must make the year end book value equal to the Residual Value Therefore you will need to take the beginning book value less the Residual Value Auburn Car Wash Activity-Based When you have completed all three schedules answer the following question. What do you observe about the Book Value at the end of the 5th year for all three methods? Calculation Hours X Depreciation Used Rate End of Year Amounts Depreciation Accumulated Book Expense Depreciation Value Type answer here-------> = Year 1 2 3 4 5 Total