2 Complete the following Excel-Based Assign 50 points possible: Perform all tasks as required below, l.e. cell referencing from data provided, use of Excel SLN function, use of Excel SYD function, etc. This exercise deals with partial periods so be cognizant of dates of purchase (5/1/2020) along with reporting date (12/31/2021) where applicable EBA2-Depreciation Computations-Five Methods Jon Bonjovi Guitar Corp. purchased machinery on May 1, 2020. The following are provided concerning the machinery. Machinery cost $ 315,000 15,000 10 years 240,000 units 3 4. 5 6 7 8. 9 Instructions: Estimated salvage value Estimated useful life Estimated production Estimated working hours: Actual hours used in 2021 Actual units produced in 2021 25,000 hours 2,650 hours 25,500 units 20 From the information given, compute the depreciation charge for 2021 under each of the following 1 methods. (Round to the nearest dollar.) 22 23 (a) Straight-line Note: Use Excel's depreciation functions 24 (b) Units-of-output 25 (c) Working hours to solve for (a) & (d). 26 (d) Sum-of-years' digits 27(e) Declining-balance(use 20% as the annual rate). 28