Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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.46Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started