Base=101

S=% of B= 2

life,yr=10

please need help ASAP

the base cost is $101

S= 2% of B

life year is 10

salvage value is 101-0.02= 100.98

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 functions, print out Based on the first 3 year accumulated depreciation values (neglecting country) from your table which method should be selected for tax purposes? Why? What is the book value for each method at the end of the recovery period? hich method has a salvage value that has not been met at the end of the recovery period