OptiLux is considering investing in an automated manufacturing system. The system requires an initial investment of $6.5 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $880,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.)

Fundamentals of Financial Management (MindTap Course List)
15th Edition
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter13: Real Options And Other Topics In Capital Budgeting
Section: Chapter Questions
Problem 5P: OPTIMAL CAPITAL BUDGET Hampton Manufacturing estimates that its VVACC is 125%. The company is...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Subject: 

Budgeting
Internal rate of rotum
Seved
%
Help
Save & Exit Submit
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.5
million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $880,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.)
Check my work
Transcribed Image Text:Budgeting Internal rate of rotum Seved % Help Save & Exit Submit 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.5 million, has a 20-year life, and will have zero salvage value. If the system is implemented, the company will save $880,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.) Check my work
Exercise 24-22A (Algo) Using Excel to compute IRR LO P4
Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa, The
company requires a 10% return from its investments.
Initial investment
Net cash flows in:
Year 1
Year 2
Year 3
Year 4
Year 5
Pool
Spa
IRR
Pool
Spa
$ (169,000) $ (114,000)
%
40,900
56,900
81,195
91,300
65,900
Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal
places.)
32,900
50,900
66,900
72,900
24,900
12 of 13
Next
Transcribed Image Text:Exercise 24-22A (Algo) Using Excel to compute IRR LO P4 Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa, The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Pool Spa IRR Pool Spa $ (169,000) $ (114,000) % 40,900 56,900 81,195 91,300 65,900 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) 32,900 50,900 66,900 72,900 24,900 12 of 13 Next
Expert Solution
steps

Step by step

Solved in 4 steps with 2 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
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781285867977
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College