JSU has decided to improve the engineering Department. The Improvement base costs are attached to your JNumber with the salvage value 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 EXCELL spreadsheet to answer problems 2-4. 1. Base amount-333333, Savagevalue is 3% of Base, For7years 2. Based on the first 3 year of accumulated depression values (neglecting country) from your table, which method should be selected for tax purpose? Why? 3. What isthe book value for each method at the end of the recovery period? Which method has a salvage value that has not been met at the end of the recovery period? 4. JSU has decided to improve the engineering Department. The Improvement base costs are attached to your JNumber with the salvage value 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 EXCELL spreadsheet to answer problems 2-4. 1. Base amount-333333, Savagevalue is 3% of Base, For7years 2. Based on the first 3 year of accumulated depression values (neglecting country) from your table, which method should be selected for tax purpose? Why? 3. What isthe book value for each method at the end of the recovery period? Which method has a salvage value that has not been met at the end of the recovery period? 4