Question

In: Finance

You are considering the following two projects and can take only one. Your cost of capital...

  1. You are considering the following two projects and can take only one. Your cost of capital is 11.9%. The cash flows for the two projects are as follows​ ($ million):

Project  

Year 0  

Year 1  

Year 2  

Year 3  

Year 4  

A

-$103

28

34

44

53

B

-$103

53

44

34

24


What is the IRR of each project? Which project should you choose?

Select one:

a. IRR of Project A = 17.7%, IRR of Project B = 21.7%. Choose project A.

b. IRR of Project A = 17.7%, IRR of Project B = 21.7%. Choose project B.

c. IRR cannot be used to compare these projects. Choose project A because it has a higher NPV.

d. IRR of Project A = 11.9%, IRR of Project B = 17.7%. Choose project B.

*Please calculate manually and show step by step, I need a major refresher on IRR and NPV

Solutions

Expert Solution

Answer : (b) IRR of Project A = 17.7%, IRR of Project B = 21.7%. Choose project B.

Excel sheet used to solve the question :

Formula sheet :


Related Solutions

You are considering the following two projects and can take only one. Your cost of capital...
You are considering the following two projects and can take only one. Your cost of capital is 11.1%. The cash flows for the two projects are as follows​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$100 $27 $32 $39 $52 B −$100 $52 $39 $32 $22 a. What is the IRR of each​ project? b. What is the NPV of each project at your cost of​ capital? c. At what cost of capital...
You are considering the following two projects and can only take one. Your cost of capital...
You are considering the following two projects and can only take one. Your cost of capital is 11.4 %. The cash flows for the two projects are as follows​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$102 $27 $31 $39 $49 B −$102 $49 $39 $31 $20 a. What is the IRR of each​ project? b. What is the NPV of each project at your cost of​ capital? c. At what cost of...
You are considering the following two projects and can only take one. Your cost of capital...
You are considering the following two projects and can only take one. Your cost of capital is 11.2 %11.2%. The cash flows for the two projects are as follows​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$100 $27 $30 $42 $52 B $100 $ 52 $ 42 $ 30 $21 a. What is the IRR of each​ project? b. What is the NPV of each project at your cost of​ capital? c. At...
As CFO of Gaga Inc., you are considering two projects, each with a cost of capital...
As CFO of Gaga Inc., you are considering two projects, each with a cost of capital of 11%, with the following cash flows: t =               0   1     2     3      4     Project S -6000 4000 3000 2000 1000 Project L -3500 2000 1000 2000 2000 What is the NPV and IRR of Project S? (2 pts)   What is the NPV and IRR of Project L? (2 pts) Which project(s) should you choose if they are mutually exclusive and there is...
Your division is considering two projects. Its WACC is 10% (weighted average cost of capital, that...
Your division is considering two projects. Its WACC is 10% (weighted average cost of capital, that represent a firm’s cost of capital in which each category of capital is proportionately weighted), the projects’ after-tax cash flows (in millions of dollars) would be as follows: Project A 0 = - $30 1 = - $ 5 2 = $ 10 3 = $ 15 4 = 20 Project B 0 = - $ 30 1 = $ 20 2 = $10...
Diamond City is considering two mutually exclusive investment projects. The cost of capital for these projects...
Diamond City is considering two mutually exclusive investment projects. The cost of capital for these projects is r. The projects’ expected net cash flows are as follows: Year Project A Project B 0 -42,000 -42,000 1 24,000 16,000 2 20,000 18,000 3 16,000 22,000 4 12,000 26,000 a. If r = 10%, which project should be selected under the NPV method? b. If r = 20%, which project should be selected under the NPV method? c. Calculate each project’s PI...
Diamond City is considering two mutually exclusive investment projects. The cost of capital for these projects...
Diamond City is considering two mutually exclusive investment projects. The cost of capital for these projects is r. The projects’ expected net cash flows are as follows: Year Project A Project B 0 -42,000 -42,000 1 24,000 16,000 2 20,000 18,000 3 16,000 22,000 4 12,000 26,000 a. Calculate each project’s payback (PB) period if r = 10% (up to 2 decimal places). Which project should be accepted? b. Calculate each project’s discounted payback (DPB) period if r = 10%...
You have two potential investment projects, Project A and Project B. You can take one, but...
You have two potential investment projects, Project A and Project B. You can take one, but not both. The annual cash flows for the two projects are: Year 0 1 2 3 Project A Cash Flow -$50,000 $45,000 $5,000 $5,000 Project B Cash Flow -$50,000 $5,000 $5,000 $50,000 a. Compute the IRR for each project. b) Compute the NPV for each project if the appropriate discount rate is 5%.   Which project would you take, and why? c)  Compute the NPV for each...
Assume the following 2 projects and MARR, and that you can select only one of them....
Assume the following 2 projects and MARR, and that you can select only one of them. NCF per year 0 1 2 3 4 5 Project X -120,000 40,000 48,000 56,000 64,000 72,000 Project Z -145,000 40,000 48,000 57,600 80,000 96,000 MARR 10% Fully describe the concept of Net Cash Flow per year, and why there is a “year zero” in the timeline. Describe the concept of Minimum Acceptable Rate of Return. Describe the concept of Net Present Value. Describe...
You are considering an investment in two projects, A and B. Both projects will cost $115,000,...
You are considering an investment in two projects, A and B. Both projects will cost $115,000, and the projected cash flows are as follows: YEAR PROJECT A PROJECT B 1 $7,188    $51,750 2 $21,562    $38,812 3 $40,250    $28,750 4 $50,315    $21,563 5    $57,500 $14,375 Using Excel and show formulas a. Assuming that the WACC is 9.4%, calculate the payback period, discounted payback period, NPV, PI, IRR, and MIRR. If the projects are mutually exclusive, which...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT