fill in grey areas

im in accounting 240

Exprep grades this excel sheet so can you put in the format of the spreadsheet

Waylander Coatings Company purchased waterproofing equipment on January 6, 2021 for $412,000. The equipment was expected to have a useful life of four years, or 8.400 operating hours, and a residual value of $34,000. The equipment was used for 3,200 hours during Year 1, 2.600 hours in Year 2. 1.500 hours in Year 3, and 1.100 hours in Year 4. 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-output method, and (c) the double-declining-balance method. Also determine the total depreciation expense for the four years by each method. Straight-Line Annual Depr Exp Double Declining Annual Depr Exp = Units of Output Depr per unit produced cost - salvage value useful life in years 2 hours Year 1 years /year = /hr yrs Year 2 yrs Year 1 Year 2 Year 3 Year 4 Total Year 1 Year 2 Year 3 Year 4 Total Year 3 yrs Year 4 yrs Salvage Value: Book Value if normal depreciation calculation is used for year 4: Book Value cannot go below salvage value. so Year 4 depreciation will be: Book Value & Salvage Value are both: Total