Hello, I need help answering this question below. 9 value: 0.50 points Problem 7

Question

Hello,

I need help answering this question below.

9 value: 0.50 points Problem 7-22 Comparing Investment Criteria Consider two mutually exclusive R&D projects that ADM is considering. Assume the discount rate for ADM is 8 percent Project A: Server CPU.13 micron processing project By shrinking the die size to.13 micron, ADM will be able to offer server CPU chips with lower power consumption and heat generation, meaning faster CPUs Project B: New telecom chip project Entry into this industry will require introduction of a new chip for cell phones. The know-how will require a large amount of up-front capital, but success of the project will lead to large cash flows later on. Year Project A Project B 0 655,000 855,000 245,000 345,000 350,000 395,000 480,000 330,000 340,000 250,000 175,000 110,000 Complete the following table: (Do not round intermediate calculations. Enter the IRR as a percent. Round your profitability index (PI) answers to 3 decimal places (e.g., 32.161) and other answers to 2 decimal places (e.g., 32.16).) Project A Project B NPV IRR PI What is the incremental IRR of investing in the larger project? (Do not round intermediate calculations. Enter your answer as a percent and round your answer to 2 decimal places (e.g., 32.16).) Incremental IRR

Explanation / Answer

Project A

NPV = 344,003.19

IRR = 30.44%

PI = 1.53

Project B:

NPV = 562,491.76

IRR = 28.04%

PI = 1.66

Use IRR function in Excel

incremental IRR = 24.74%

Discount rate 8.0000% Cash flows Year Discounted CF= cash flows/(1+rate)^year Cumulative cash flow         (655,000.000) 0                        (655,000.00)                     (655,000.00)            330,000.000 1                           305,555.56                     (349,444.44)            340,000.000 2                           291,495.20                     (57,949.246)            250,000.000 3                           198,458.06                       140,508.81            175,000.000 4                           128,630.22                       269,139.04            110,000.000 5                             74,864.15                       344,003.19

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.