exercise 15 - exercise 16. Thanks for the help!

Exercise 26-15 NPV and IRR for automation investment P3 P4 OptiLux is considering investing in an automated manufacturing system. The system requires an initial investment of $4 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $500,000 per year in direct labor costs. The company requires a 10% return from its investments. 1. Compute the proposed investment's net present value. 2. Using your answer from part 1, is the investments internal rate of return higher or lower than 10%? Exercise 26-16A IRR for automation investment P4 Refer to the information in Exercise 26-15. Create an Excel spreadsheet to compute the internal rate of return for the proposed investment. Round the percentage return to two decimals