OptiLux is considering Investing in an automated manufacturing system. The system requires an initial Investment of $7.0 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $860,000 per year in direct labor costs. The company requires a 10% 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 %

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter12: Capital Investment Analysis
Section: Chapter Questions
Problem 3E: Average rate of returnnew product Hana Inc. is considering an investment in new equipment that will...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Alpesh

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
$7.0 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save
$860,000 per year in direct labor costs. The company requires a 10% 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 $7.0 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $860,000 per year in direct labor costs. The company requires a 10% 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
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage