Chapman Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $620,000 is estimated to result in $211,000 in annual pretax cost savings The press falls in the MACRS 5-year class, and it will have a salvage value at the end of the project of $98,000. The MACRS rates are .2, .32, .192, .1152, .1152, and .0576 for Years 1 to 6, respectively The press also requires an initial investment in spare parts inventory of $24,000, along with an additional $3,600 in inventory for each succeeding year of the project. The inventory will return to its original level when the project ends The shop's tax rate is 35 percent and its discount rate is 11 percent

1.Should the firm buy and install the machine press? Why or why not?

2.What is the NPV sensitivity to cost savings?

Please show in excel.