Paste Copy Format BIU .AA O Painter C13 @ fx 2000 D C E F 1 Given Data: olm AUBURN CAR WASH 800,000 50,000 Cost of new car wash machines Estimated residual value Machine life in years Machine life in hours 10,000 SE Actual use per year: Hours Year Used 2,000 1,800 2,200 2.100 1,900 AWN 290& ST Conditional Format A S If you hover your mouse over a cell with a red flag you will see the comment 80 000 650 000 500 000 350 000 200 000 150.000 150 000 150 000 150.000 150 000 750,000 150.000 300 000 450.000 600 000 750.000 650 000 500.000 350.000 200 000 50.000 20%. 20 Auburn Car Wash Double-Declining-Balance Calculation Beginning Depreciation Book Value X 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 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 later all three charg e r the filmin action Lab Given Data + -O A A *4 + 310