BIUH-2A Paste Copy Format Painter fx 2000 C13 E D A 1 Given Data: 2 AUBURN CAR WASH 3 4 800,000 50,000 Cost of new car wash machines Estimated residual value Machine life in years 7 10,000 Machine life in hours Actual use per year: 10 11 12 13 Hours Year Used 1 2,000 1,800 2,200 14 15 16 2,100 17 18 19 20 21 22 23 24 25 26 27 1,900 Lab Sven Data 234t 5 A' A BIUBS A Cut Arial 10 Ar Copy Format Painter ste Merge and Wrap Center Text X fx C17 A B D Auburn Car Wash Straight Line Calculation Depreciabh Depreciation Rate End of Year Amounts Depreciation Accumulated Expense Depreciation Book Year Cost Value 1 2 3 4 5 Total Auburn Car Wash Double-Declining-Balance Calculation End of Year Amounts Book Depreciation Rate Beginning Depreciation Accumulated Expense Depreciation Year Book Value X Value 1 If 2 3 4 + Lab 1 Given Data Edit e L enovo Menu v Home Insert Page Layout Formulas Data A' A Cut Arial 10 Accoun BIUB te Copy Format Painter Merge and Wrap- Text Center X fx C17 A D E Calculation End of Year Amounts Book Value Depreciation Rate Depreciation Accumulated Beginning Book Value X Expense Year Depreciation If you 1 2 3 4 5 Note Ther Total Auburn Car Wash When Activity-Based Wha End of Year Amounts Depreciation Accumulated Depreciation Calculation Depreciation Hours Book X Year Rate Expense Used Value 1 2 3 4 5 Total Lab 1 Given Data Edit e L enovo Formatting Table Columns K N P The refore you will need to take the beginning book value less the Residual Value 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? Type answer here- E e & 1813 3/10/2019 A