Using Excell and explanations please

On January 1, 2016. Locke Company, a small machine-tool manufacturer, acquired a piece of new industrial equipment. Pertinent data follow: Cost of equipment Useful life Estimated salvage value Estimated machine tools to be produced in first year Estimated production decline per year over the remaining life of the equipment Class life for tax purposes $ 1,260,000 5 years $ 60,000 12,000 1,000 7 years The following depreciation methods may be used: (1) Straight-line (2) Double declining balance (3) Sum-of-years-digits (4) Units-of-output Use the MACRS tables for computing depreciation (AICTA adapted Instructions: (6) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2018? Prepare a schedule showing the amount of accumulated depreciation at December 31, 2018, under the method selected. Ignore present value, income tax, and deferred income tax considerations (1) Straight-line using the SLN function Depreciation Accumulated Year Expense Depreciation 2016 2017 . . 2018 (2) Double-declining balance using the DDB function Depreciation Accumulated Year Expense Depreciation 2016 2017 2018 (3) Sum-of-years-digits using the SYD function Depreciation Accumulated Year Expense Depreciation 2016 2017 2018 (4) Units-of-output Note: There is no Excel function for units-of-output Depreciation Expense Accumulated Depreciation Year 2016 2017 2018 b) Which depreciation method (MACRS or optional straight-line) would minimize net income for income tax reporting for the 3-year period ending December 31, 2018? Determine the amount of accumulated depreciation at December 31, 2018. Ignore present value considerations. General MACRS method (Values taken from the MACRS rates schedule.) Depreciation Accumulated Year MACRS Rate Expense Depreciation 2016 2017 2018 Optional straight-line method: Depreciation Expense Accumulated Depreciation MACRS Rate Year 2016 2017 2018