pls help

A piece of construction equipment was purchased by the Jones Construction Company. The cost basis was $300,000 with a salvage value of 40,000$ : a.Determine the depreciation for years one through 8 years using: (i) the straight-line method; (ii) the 200% declining balance method; and (iii) the MACRS (GDS) (Go to tables to get the GDS class and depreciation percentages) b. Compute the present worth of depreciation for each of the three depreciation methods. The MARR is 10% per year. c. If a large present worth in Part (b) is desirable, what do you conclude regarding which method is most desirable? d. Draw the BV-Yrs relationship Comparisons for the mentioned Methods of Depreciation (Use the uploaded excel spreadsheet)