please fill out

PR 9-2B Comparing three depreciation methods Obj. 2 Waylander Coatings Company purchased waterproofing equipment on January 6 for $320,000. The equipment was expected to have a useful life 3 years or of four years, or 20,000 operating hours, and a residual value of $35,000. The equipment was used for 7,200 hours during Year 1, 6,400 hours in Year 2, 4,400 hours in Year 3, and 2,000 hours in Year 4. Instructions SHOW ME HOW 1. Determine the amount of depreciation expense for the years ended December 31, Year 1, Year 2, Year 3, and Year 4, by (A) the straight-line method, (B) the units-of- activity method, and (C) the double-declining balance method. Also determine the total depreciation expense for the four years by each method. The following columnar headings are suggested for recording the depreciation expense amounts: EXCEL TEMPLATE Year Straight-Line Method Depreciation Expense Units-of-Activity Double-Declining- Method Balance Method Answer 2. What method yields the highest depreciation expense for Year 1? 3. What method yields the most depreciation over the four-year life of the equipment? 02b wutk Exodus Aution F Page Layout Formulas Data Review View Tell me what you want to do. Bradley Bury Share Ayo File Home Insert X Te Copy aste B Fuimal Paint - Coboard re insed Delete Format -A- = = = Mega 5.0+ Contornos = E - Firmany Tale align Number Sort og ind Filter Select- Tahing Tont re 6 u BE D E F H JK N N 0 B w Y YZ 25 AH AX AL AV AN 1. Deprecwton Cape A. H Straight Units of Activity C. Coute -Deaining Halang Year 4 To Dan Straight-line method: Cat - , Roald v. ! Yu.my Denim Units-of-activity method: - . Raud, Toll T Rite Rate His Yr Hension Yout Year 2 Years Your 4 Ioable-declining balance method Duel ... . x R. You on Y Year 2 Yes Srcedes classernal cuse Look value to beowicado de pranlahi Hadid Halane Value Yeniylepreciation Yer 4 The che hat yes nedprekin excreen Year 1. he 1. The ich helyes the care lur years Pr. 9 28 dy INC +