Internal Rate of Return (IRR)
Internal rate of return (IRR) is the discount rate at which the net present value of an investment becomes zero. In other words, IRR is the discount rate which equates the present value of the future cash flows of an investment with the initial investment. It is one of the several measures used for investment appraisal.
A project should only be accepted if its IRR is NOT less than the target internal rate of return. When comparing two or more mutually exclusive projects, the project having highest value of IRR should be accepted.
The calculation of IRR is a bit complex than other capital budgeting techniques. We know that at IRR, Net Present Value (NPV) is zero, thus:
NPV = 0; or
PV of future cash flows − Initial Investment = 0; or
|CF1||+||CF2||+||CF3||+ ...||− Initial Investment = 0|
|( 1 + r )1||( 1 + r )2||( 1 + r )3|
r is the internal rate of return;
CF1 is the period one net cash inflow;
CF2 is the period two net cash inflow,
CF3 is the period three net cash inflow, and so on ...
But the problem is, we cannot isolate the variable r (=internal rate of return) on one side of the above equation. However, there are alternative procedures which can be followed to find IRR. The simplest of them is described below:
- Guess the value of r and calculate the NPV of the project at that value.
- If NPV is close to zero then IRR is equal to r.
- If NPV is greater than 0 then increase r and jump to step 5.
- If NPV is smaller than 0 then decrease r and jump to step 5.
- Recalculate NPV using the new value of r and go back to step 2.
Find the IRR of an investment having initial cash outflow of $213,000. The cash inflows during the first, second, third and fourth years are expected to be $65,200, $96,000, $73,100 and $55,400 respectively.
Assume that r is 10%.
NPV at 10% discount rate = $18,372
Since NPV is greater than zero we have to increase discount rate, thus
NPV at 13% discount rate = $4,521
But it is still greater than zero we have to further increase the discount rate, thus
NPV at 14% discount rate = $204
NPV at 15% discount rate = ($3,975)
Since NPV is fairly close to zero at 14% value of r, therefore
IRR ≈ 14%
Written by Irfanullah Jan