Paste BIU E 51 == X D E F G 128 fx A 1 Problem 5 Chapter 9: 2 Lawson Company purchased Equipment on January 1, 2020 for $10,000. The estimated useful le of the equpment is five years or 100,000 units. The salvage value is estimated to be $1,000. During 2020 the equipment was used to produce 25,000 units 3 4 9 5 First, in the spaces below put the necessary data to be used in the calculations. Second, in the boxes 6 below, calculate depreciation for 2020 using each of the methods indicated. Place your answers in the 7 boxes under the name for each method. Notice the effect of the varying depreciation methods on Net 8 Income in the Income Statements to the right 10 NOTE: You will be graded on the formulas you create to calculate the amount of depreciation. Do 11 not just calculate on paper and put the answers in this spreadsheet! 12 13 Cost 14 EUL in Years 15 EUL in Units 16 Salvage Value 12 18 Units Produced this Year 19 Beginning balance in 20 accumulated depreclaion 21 22 Straight-line 23 24 25 26 27 28 29 30 31 32 34 35 36 37 3B 39 40 41 42 43 Sheet1 + Problem 5 Excel Template Tell me 2. Wrap Text General Merge & Center $ % % % Share Comments 19 Insert Delete Format WE 28.0 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Ideas Sensitivity 0 Q T Straight-line Units-ofproduction Double-declining balance Sales COGS Gross Profit 100,000 75,000 25,000 100,000 75,000 25,000 100,000 75.000 25,000 Do 15,000 15,000 15,000 Expenses Depreciation Expense Total Expenses Net Income 15.000 10,000 15000 10,000 15,000 10,000