ave BO.. Write Up 1, Depreciation-1 Insert Draw Page Layout Formulas Data Review View Tell me X Arial 12 + E Wrap Test Custom BIU Merge Centar $ % ) Conditional Format Formatting as Table . WRITE-UP PROBLEM 82(10 possible points): Machinery purchased to $200,000 is expected to have a useful life of 5 years or 100.000 opening hours, and a residual value of $15,000. The equipment was placed in service on March 1 of the current local year, which ends on December 31 The authors of operation are noted 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. Straight Line Method Year 1 year 2 Sal Value 15.000 Depr. Val mosyo 500 Depreciation Expense SAS 30 833.30 Cost $ 200.000 5 200.000 $ 200.000 $ 200,000 $ 200,000 $ 200.000 years year Total Depreciation Takes 30.833.30 Units of Production Method: deprcbi val Yout2 year 3 year 4 Years Cost sal val $ 200.000 $ 200 000 $ 200 000 $ 200.000 $ 200.000 $ 200 000 units actual hour Depreciation Expanse 6.000 23 000 24.000 22.000 17 000 11.000 Total Depreciation Takes 102.00000 DDB rate Moser Depreciation Expense Double Declining Balance Method: accum depr NAV year 2 ya Cost $ 5 5 5 $ 5 200 000 200 000 200.000 200.000 200 000 200 000 Year Total Depreciation Taken FA Depreciation Cont 2 3