Tools Data Window 100% 22 A Sun Jan 19 22 45 06 Q E Excel File Edit ... AutoSave Home Insert Draw X Arial Pato BI 651 xv fx View Insert Format ABES Page Layout Formulas 10 A A O A Comments Data Review = = = Help 6.29 GB X ACCT& 202 Lab 1 Student Template Winter 2020-2 Tell me what you want to do ? Wraa Text General Merge & Center Merge & Center % : - Conditional Format Cell Formatting us Teble Styles View D Share % Ideas E 28- 0 - 2x Delete Format X S Find & Sensitivity 1 Given Data: LONDON CAR WASH Cost of now car wash machines Estimated residual value Machine life in years Machine life in hours $200,000 $ 20,000 10,000 Actual use per year: Hours Year Used 2,000 2,000 1,500 1,800 1,300 1,400 Lab 1 Given Data + !! 1 - 1 + 100% 110 ISO RODOL LATOJO AO 99x Tools Data Window 100% 22 A Sun Jan 19 22:44:51 Q E Excel File Edit ... AutoSave Home Insert Draw X Arial Poste B I U View Insert Format ABES Page Layout Formulas 12 A A O View Help 6.24 GB X ACCT& 202 Lab 1 Student Template Winter 2020-2 Tell me what you want to do Was Text General Merge & Center % -93 Conditional Farmat call Formatting y Teble Styles Share Data Review = = = Comments 2X Delete 22Y-. - Sort & Fille Ideas Farmat Find & Saler Sensitivity X XVfx 6 Points Possible 10 Use cell references ilinkingi in all cells and Excel formulas when possible 7 Prire your waigment wich: urce with mount diaplayed, and nice with formules displayed. A Sumit both 1. Use the information on the divers Duta worksheet to prepare the depreciation schedules 11 using the following methods: straight-line, double-declining balance, and activity based Lorcan Car Wash creatable Calculation Depreciation Depreciation Acounulated Book anun Lomm Car Wash Dubi-Declining-Line Calculation Depreciation Druciation End-of-Yer Amount: X XXXXXYYNYNENO Londinn Car Wash Activity-Based Calculation XXS Lab 1 Given Data + !! 31 - O + 83% OL9100 SHUTTOJO AO 99x