You are considering two mutually exclusive projects. Project A has cash flows of −$125,000, $51,400, $52,900, and $63,300 for Ye
ars 0 to 3, respectively. Project B has cash flows of −$85,000, $23,100, $28,200, and $69,800 for Years 0 to 3, respectively. Project A has a required return of 9 percent while Project B's required return is 11 percent. Should you accept or reject these mutually exclusive projects based on IRR analysis?
1 answer:
Answer:
The Internal Rate of Return (IRR) assesses how profitable the capital that remains invested across the duration of a project is. It is also recognized as the discount rate that brings the Net Present Value (NPV) to zero. Therefore, if employing the IRR leads us to zero for the NPV, it implies the project neither creates nor destroys value.
The required rate of return signifies the minimum expected return an investor anticipates when committing to a project.
If investment in both projects remains throughout their lifespan, both could work well for the investor. However, as they are mutually exclusive, a choice must be made. If project B’s investment is held throughout its duration, it will possess a greater internal rate of return, thus suggesting its selection. Nevertheless, it is wise to evaluate additional financial indicators, as the IRR assumes reinvestment of all earnings into the same project, which may not reflect reality where returns might not be reinvested at the same rate.
The attached figure illustrates the IRR formula. However, I computed it through Excel: initially, I documented the cash flows for each year (the first being negative due to initial investment). I then applied the formula: "=IRR(D5:C8)" for project A and "=IRR(E5:E8)" for project B.
You might be interested in