please help!

Base = 25698

s(% of "B") = 5

life(yrs) = 5

1. JSU has decided to improve the Engineering Department. The improvement base costs are attached to your J-Number with the life and salvage values indicated. The president asked you, as the design engineer, to analyze and compare the difference between STRAIGHTLINE, MACRS and DDB in a tabular form using Excel spreadsheet. You are to complete the analysis using excel spreadsheet functions and upload a pdf copy of your results with Exam part "B". You will need to complete part "A" to complete problems 2-4 of Part "B" of the exam. (50pts) 1. Based on the first 3 year accumulated depreciation values (neglecting country) from your table in Part "A", which method should be selected for tax purposes (show calculations)? Why? (5pts) 2. What is the book value for each method at the end of their recovery period? (3pts) 3. Which method has a salvage value that has not been met at the end of their recovery period? (2pts)