Question: please show and explain work in excel thank you Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $380,000 is estimated to result in $145,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 $64,000. The press also requires an initial investment in spare parts inventory of $11,000, along with an additional $1,600 in inventory for each succeeding year of the project. The shop's tax rate is 24 percent and the project's required return is 8 percent. Refer to Table 8.3. Calculate the NPV of this project. (Do not round Intermediate calculations and round your answer to 2 decimal places, o.g., 32.16.) NPV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
