E P B formules Deta Rere Quick X Cut D Copy format Home Insert Page Layout 10 - A ARTE 2.2.A. Q. 3 Arial 1 Vi Accounting - % Paste- B 8 Painter Merge and Wrap Center Test ca @fx 5 E7 4. 1 Given Data: F G AUBURN CAR WASH Cost of new car wash machines Estimated residual value Machine life in years Machine life in hours * 800,000 50,000 50.000 10,000 5! 8 Actual use per year: Hours Year Used 2,000 1,800 2,200 2.100 1,900 WN - Given Data + Day Pe H ome Layout For Dute R Vi ficando Center Test Formatting To - (1/ Given Data 2 F G H Auburn Car Wash Straight Line Rate Calculation Depreciable y Depreciation Cost 800 000 205 650 000 500 000 209 350.000 200.000 20% If you hover your mouse over a cell with a red flag you will see the comment 20N End of Year Amounts Depreciation Accumulated Book Expense Depreciation 150 000 150 000 650.000 150.000 300 000 500.000 150 000 450.000 350.000 150.000 600.000 200.000 150.000 750.000 50.000 750,000 20% Auburn Car Wash Double-Declining-Balance Calculation End of Year Amounts Beginning Depreciation Depreciation Accumulated Book Book Value X Expense Depreciation Value 800 000 220.000 320.000 480000 480.000 192000 192.000 288 000 258.000 115 200 115200 172 800 409 69 120 19 120" 103.680 Rate If you hover your mouse over a cell with a red flag you will see the comment 404 et e L A A A V vo (1/ven Daten 2 D E NOP C 500 000 350,000 200 000 150 000 150 000 150 DOO 750,000 450.000 000 000 750.000 350 000 200.000 50 000 20 Auburn Car Wash Double-Declining-Balance Year Rate Calculation Beginning Depreciation Book Value 800,000 480 000 280 000 40% 172 800 40% | | you hover your mouse over a cell with a red flag you will see the comment End of Year Amounts Depreciation Accumulated Book Expense Depreciation 320,000 320,000 480,000 192000 192.000 288,000 115 200 115 200 172 800 69. 120 69 120" 41.472 41 472 6 120 Tran 103.680 40 62 208 Total Note: for years 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 the 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 End of Year Amounts Bremen 1105. - - A 40 vo Center et Formatting Table (1/ Given Data'll 712 E F c o J K Rate L - M N O P If you hover your mouse over a cell with a red flag you will see the comment 800.000 480.000 288 000 172,800 103 680 G H Expense Depreciation 320,000 320.000 192.000" 190 000 115 200 115. 200 19 120 60 120 41.472" 696 320 480,000 288.000 172 800 100 680 62 208 Note: for year 5 you must make the year and 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 y Depreciation Depreciation = Used Rate End of Year Amounts Depreciation Accumulated Book Expense Depreciation Value Type answer here Total Lab Given Dute + 110%--- e L- A 4 10/2019 O ovo