(Preferred: Please provide Excel formulas when calculating this problem; not the tables)
Consider two projects, A and B. The present value (PV) of after-tax cash inflows for project A is $55,000, while the original investment outlay for this project is $50,000. Project B, on the other hand, has the following characteristics: PV of after-tax cash inflows = $24,000; original investment outlay = $20,000. Assume that these two projects are mutually exclusive and that the company has adequate capital to fund either investment option. All the following statements are true except:
Multiple Choice:
(A) The NPV of Project A is $5,000.
(B) The IRR of Project A is greater than the cost of capital (discount rate).
(C) The profitability index (PI) for Project A is 1:1.
(D) Project A is preferable to Project B (all else held constant).
(E) The economic rate of return on Project A exceeds the discount rate.
(A) NPV of Project A= $55000-$50000= $5000 hence this statement is true.
(B) If NPV is positive then IRR is tend to higher than the cost of capital of the project. Hence, this option is also true.
(D) Project A is preferable over project B as NPV of Project A is $1000 higher than NPV of Project B.
(E) If NPV is positive then economic rate of return is tend to higher than the cost of capital of the project. Hence, this option is also true.
(C) The answer of this multiple choice question is option "C" as Profitability index for project A is 1.1 instead of 1:1 which is as under:
=55000/50000
=1.1
(Preferred: Please provide Excel formulas when calculating this problem; not the tables) Consider two projects, A and B....
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$244,500 –$14,607 1 29,800 4,237 2 59,000 8,285 3 55,000 13,203 4 410,000 8,788 Whichever project you choose, if any, you require a 6 percent return on your investment. What is the IRR for Project A? What is the IRR for Project B? What is the profitability index for Project A? What is the profitability index for Project B?
(NPV, PI, and IRR calculations) You are considering two independent projects, project A and project B. The initial cash outlay associated with project A is $55,000, and the initial cash outlay associated with project B is $75,000. The required rate of return on both projects is 10 percent. The expected annual free cash inflows from each project are in the popup window: PROJECT A PROJECT B Initial Outlay -55,000 -75,000 Inflow year 1 16,000 17,000 Inflow year 2 16,000 ...
NPV and Uher nvestment CrNErTa For Problems 1-4, use a 5% discount rate and the following cash flows for projects A and B.: A: (-$2000, $500, $600, $700, $800) B: -$2000, $950, $850, $400, $300) 3. If A and B are mutually exclusive and the required rate of return is 5%, which should be ассеpted? 4. If the discount rate is 12%, and A and B are mutually exclusive, which project should be ассеpted? You can borrow $8,000, to be...
Consider the following two mutually exclusive projects: Year CF of Project A CF of Project B 0 -$350,000 -$50,000 1 45,000 24,000 2 65,000 22,000 3 65,000 19,500 4 440,000 14,600 Whichever project you choose, if any, you require a 15 percent return on your investment. a)If you apply the payback (PB) criterion, which investment will you choose? Why? b)If you apply the NPV criterion, which investment will you choose? Why? c)If you apply the IRR criterion, which investment will...
Newfoundland Vintners Co-operative is considering two mutually exclusive projects: Absinth and Brandy. Project Absinth requires a $20,000 cash outlay today and is expected to generate after-tax cash flows of $11,000 in year 1, $8,500 in year 2, and $7,500 in year 3. Project Brandy requires a $30,000 cash outlay today and is expected to generate after-tax cash flows of $7,000 in year 1, $9,000 in year 2, $11,000 in year 3, and $16,000 in year 4. Neither project can be...
CH. 9 WORKSHEET NPV and Other Investment Criteria For Problems 1-4, use a 5% discount rate and the following cash flows for projects A and B.: A: (-$2000, $500, $600, $700, $800) B: (-$2000, $950, $850, $400, $300) 1. Calculate the payback period for projects A and B. 2. Calculate the internal rate of return for projects A and B. 3. If A and B are mutually exclusive and the required rate of return is 5%, which should be accepted?...
Please use Excel to solve.
NPV and IRR for Mutually Exclusive Projects 10. A company is considering two mutually exclusive projects, A and B. Project A requires an initial investment of $200, followed by cash flows of $185, $40, and $15. Project B requires an initial investment of $200, followed by cash flows of S0, $50, and $230. What is the NPV and IRR for each of the projects? Which project should the company choose? The firm's cost of capital...
Farrah Corporation is considering two projects (see below). For your analysis, assume these projects are mutually exclusive with a required rate of return of 12%. Project 1 Initial investment $185,000 Cash inflow Year 1 $230,000 Project 2 Initial investment $1,100,000 Cash inflow Year 1 $1,450,000 Compute the following for each project: • NPV (net present value) • PI (profitability index) • IRR (internal rate of return) Which project should be selected? Why?
There are three projects listed below. The firm’s required rate of return is 13%. Please show work. Year Project AB Project LM Project UV 0 $ (90,000) $ (100,000) $ (96,500) 1 39,000 0 (55,000) 2 39,000 0 100,000 3 39,000 147,500 100,000 a) Compute net present value and internal rate of return of each project Project AB LM UV NPV IRR b) If three projects are mutually exclusive, which one should be chosen? c) What is the discount...
IRR—Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table: . The firm's cost of capital is 12%. a. Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRs. b. Which project is preferred? 0 Data Table a. The internal rate of return (IRR) of...