Need to see all the formulas.

On January 1, 2019, Locke Company, a small machine tool manufacturer, acquired a piece 9 of new industrial equipment. Relevant data for this equipment follows. 10 11 36 7 years 12 LOCKE COMPANY 10 RELEVANT DATA FOR EQUIPMENT PURCHASED 14 Cost of equipment $ 1,260,000 15 Useful life Estimated salvage value 5 years $ 60,000 17 Estimated machine tools to be produced in first year 12,000 18 Estimated unit production decline per year over the 19 remaining life of the equipment 1,000 units 20 Class life for tax purposes 21 22 21 24 25 REQUIRED: Insert the appropriate formulas to complete the attached worksheets to provide 26 depreciation schedules for the asset purchased, for the entire life of the asset using the following depreciation methods. (1) Straight line method (2) 200% declining balance method. 30 (3) Sum-of-the-years-digits method. 31 (4) Productive units of output (activity) method. (5) MACRS depreciation (tax) method. Use the appropriate IRS table for the percentages required 34 35 35 20 33 33 III (2) 200% DB (3) SYD (4) Units of Output (5) MACRS + Problem Sheet (1) Straight Line Calculation Mode: Automatic Workbook Statistics MacBook Air D E 3 STRAIGHT LINE DEPRECIATION Beginning Depreciation Accumulated Book Value Expense Depreciation 4 Ending Book Value 5 Year 6 7 8 9 10 11 12 13 14 15 52 16 17 18 19 20 21 22 23 Geriend A1 D 1 2 fi LOCKE COMPANY LOCKE COMPANY DEPRECIATION SCHEDULE 200% DECLINING BALANCE DEPRECIATION Beginning Depreciation Accumulated Book Value Expense Depreciation 3 4 Ending Book Value 5 Year 6 7 8 9 10 11 12 13 14 15 16 General Al LOCKE COMPANY D F G 1 2 C LOCKE COMPANY DEPRECIATION SCHEDULE SUM-OF-THE-YEARS'-DIGITS DEPRECIATION Beginning Depreciation Accumulated Ending Book Value Expense Depreciation Book Value 3 4 5 Year 6 2 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A1 LOCKE COMPANY 15 G H 1 2 3 LOCKE COMPANY DEPRECIATION SCHEDULE PRODUCTIVE UNITS OF OUTPUT DEPRECIATION Beginning Units of Depreciation Accumulated Book Value Output Expense Depreciation 4 Ending Book Value 5 Year 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 General A1 LOCKE COMPANY 1 3 LOCKE COMPANY DEPRECIATION SCHEDULE MACRS (TAX) DEPRECIATION Table Depreciation Accumulated Percentage Expense Depreciation 4 Beginning Book Value Ending Book Value 5 Year 6 2 8 9 10 11 12 13 14 15 16 17 18 19 20