Write Up 1, Depreciation-1 BO.. Draw Page Layout Formulas Insert Data Review Vlow Tell me X Arial 12 33 Custom Wrap Test Marge A CAMA BIU A Sw%% Conditional Format Call Formatting as Table Style C WRITE-UP PROBLEM #2 (10 possible points): Machinery purchased for $200 000 is expected to have a tale of years or 100.000 operating hours, and a residus value of $15,000. The equipment was placed in service on March of the current local your, which ends on December 31 The acutal hours of operation are sold in the respective Units Of Production chart below Compute the depreciation expense by the methods requested for up to six years. Use formulas in Excel and the columns in the chart to arrive at depreciation in the blue cells Dept VW re Straight Line Method year! year 2 5.00 Depreciation En 56S 30.83330 Cost Sal Value S 200,000 15.000 $ 200.000 S 200.000 s 200.000 S 200.000 $ 200.000 years Total Depreciation Tekens 30,833 30 Units of Production Method Cosi deprival years 5 5 200.000 200 000 200.000 200 000 200.000 200,000 5 5 unit acual hours Depreciation Expense 5000 23 000 24 000 22 000 17 000 11.000 Total Depreciation Titans 102.000.00 DOB. Mon/Year Depreciation Expense years Double Dedining Balance Method NBV year 2 year 3 Year 4 Cost accum depr $ 200.000 $ 200.000 $ 200 000 5 200.000 $ 200,000 5 200 000 Total Depreciation Tokens FA Depreciation Cmolt 2 % 5 3 4. 6 8