Machinery purchased for $200,000 is expected to have a useful life of 5 years, or 100,000 operating hours, and a residual value of $15,000. The equipment was placed in service on March 1 of the current fiscal year, which ends on December 31 The acutal hours of operation are noted in the respective Units Of Production chart below Compute the depreciation expense by the3 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. Cost Sal Value Depr. Val life mos/yr Depreciation Expense Straight Line Method year 1 year 2 year 3 year 4 year 5 year 6 Total Depreciation Taken $ Cost sal val deprcbl val Units of Production Method: year 1 year 2 year 3 year 4 year 5 Year unit cost actual hours Depreciation Expense 5,000 23,000 24.000 22 000 17.000 11,000 Total Depreciation Taken S 102,000.00 DDB rate Mos/Year Depreciation Expense accum depr NBV Double Declining Balance Method: Cost year 1 year 2 year 3 year 4 years Year 6 Total Depreciation Taken $ Ana