Please show work in excel :)

INTERMEDIATE ACCOUNTING II Chapter 11 Test Please complete the problems using Excel and upload to the dropbox in D2L. Problem 1: Group Depreciation (10 points) The following is a schedule of machinery owned by Sturdy Construction Company. Estimated Estimated Total Salvage Life in Cost Value Years Machine A 260, 500 30,000 Machine B 315,000 35,000 Machine C 56,000 Machine D 110,000 000 741, 500 Sturdy computes depreciation on the straight-line basis. Based on the information presented. compute the (1) Composite life of these assets in years. (Round to l decimal place.) (2) Composite depreciation rate