Question: please explain in excel 14 Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $445,000

 please explain in excel 14 Tanaka Machine Shop is considering a

four-year project to improve its production efficiency. Buying a new machine press

please explain in excel

14 Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $445,000 is estimated to result in $160,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $40,000. The press also requires an initial investment in spare parts inventory of $20,000, along with an additional $2,800 in inventory for each succeeding year of the project. The shop's tax rate is 22 percent and its discount rate is 9 percent. Refer to Table 10.7 Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) 10 points Skipped Print NPV Should the company buy and install the machine press? O Yes O No Year Seven-Year 1 2 Property Class Three-Year Five-Year 33.33% 20.00% 44.45 32.00 14.81 19.20 7.41 11.52 11.52 5.76 3 4. 14.29% 24.49 17.49 12.49 8.93 8.92 8.98 5 6 7 7 8 4.46

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!