Exercise 24-20A (Algo) IRR for investment using Excel LO P4 OptiLux is considering investing in an automated manufacturing system. The system requires an initial investment of $6.0 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $820,000 per year in direct labor costs. The company requires a 11% return from its investments. Using Excel, compute the internal rate of return for the proposed investment. (Round your answer to 2 decimal places.) Internal rate of return %

Fundamentals of Financial Management (MindTap Course List)
14th Edition
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter12: Cash Flow Estimation And Risk Analysis
Section: Chapter Questions
Problem 16P: REPLACEMENT CHAIN The Fernandez Company has an opportunity to invest in one of two mutually...
icon
Related questions
Question
Exercise 24-20A (Algo) IRR for investment using Excel LO P4
OptiLux is considering investing in an automated manufacturing system. The system requires an initial investment of $6.0 million, has a
20-year life, and will have zero salvage value. If the system is implemented, the company will save $820,000 per year in direct labor
costs. The company requires a 11% return from its investments.
Using Excel, compute the internal rate of return for the proposed investment. (Round your answer to 2 decimal places.)
Internal rate of return
%
Transcribed Image Text:Exercise 24-20A (Algo) IRR for investment using Excel LO P4 OptiLux is considering investing in an automated manufacturing system. The system requires an initial investment of $6.0 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $820,000 per year in direct labor costs. The company requires a 11% return from its investments. Using Excel, compute the internal rate of return for the proposed investment. (Round your answer to 2 decimal places.) Internal rate of return %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer