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

please show and explain work in excel thank you
please show and explain work in excel thank you Geller Machine Shop

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

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 Accounting Questions!