Internal Rate of Return (IRR)
The discount rate at which a project's net present value equals zero.
What is IRR?
The internal rate of return (IRR) is the discount rate that makes the net present value of all cash flows from a project equal to zero. In practical terms, it is the annualised return you would earn if the project performs exactly as projected. A project is worthwhile if its IRR exceeds the company's hurdle rate (cost of capital). IRR is popular because it is expressed as a percentage that can be compared directly to the cost of borrowing or other investment benchmarks. However, IRR can give misleading results when cash flow signs change more than once, and it implicitly assumes reinvestment at the IRR itself — a problem that MIRR corrects.
Formula
Worked Example
Same 5-year project as the NPV example
Source: CFA Institute — Corporate Finance, 4th ed., Capital Budgeting (2024-01-01)
Calculate IRR
Enter comma-separated cash flows starting at t=0. Must include at least one negative and one positive value. E.g.: -1000, 300, 400, 500, 200
IRR
—