Internal Rate of Return

Also known as · IRR

The discount rate that makes a project's Net Present Value equal to zero, i.e. the project's own break-even return. Accept if IRR is above the Discount Rate rr (the hurdle rate).

When to use

Use the IRR test only for standard projects (one sign change in the cash flows); with several sign changes there can be multiple IRRs, so fall back to NPV. When ranking mutually exclusive projects, NPV beats IRR because IRR ignores scale and assumes reinvestment at the IRR itself. Excel: IRR(values, [guess]).

See Lesson 02.

Appears in