How To Calculate IRR

The internal rate of return is the annual rate at which an investment breaks even in present value terms. Formally it is the discount rate that sets the net present value of all the cash flows to zero, so it is the highest cost of capital the project can support and still be worthwhile.

Finding it means solving for the rate in a present value equation, which has no simple algebraic solution for more than a few years. In practice it is found by iteration, trying rates until the NPV crosses zero, or by using a financial calculator or spreadsheet function.

The decision rule is simple. If the IRR is higher than your required rate of return, the NPV at that required rate is positive and you should accept. If it is lower, the NPV is negative and you should reject. The margin between the two is the project's cushion.

IRR is attractive because it is a single percentage that needs no external assumption about the discount rate, unlike NPV. That makes it easy to compare a small project and a large one, and easy to communicate a threshold of, say, a 12% hurdle rate.

That convenience hides two real weaknesses. IRR ignores scale, so a tiny project with a huge percentage can look better than a large project with a smaller percentage but a much larger absolute gain. And when cash flows change sign more than once, there can be several IRRs, none of which is reliable.

The reinvestment assumption is the subtler flaw. IRR implicitly assumes every interim cash flow is reinvested at the IRR itself, which is optimistic for very high rates. NPV assumes reinvestment at the discount rate, which you actually chose and can defend.

For a level annuity, IRR can be read off the annuity factor. Divide the initial cost by the annual cash flow to get the factor, then find the rate whose annuity factor matches for that number of years. The calculator here does that iterative search numerically.

Modified IRR corrects the reinvestment problem by separating the financing rate from the reinvestment rate. It is more realistic but less widely understood, and for most ordinary projects the plain IRR and NPV tell the same story.

IRR is used far beyond capital budgeting. Investors compute it on private equity deals, real estate, and any stream of uneven cash flows, because it converts a messy schedule into one comparable number. Just remember it is a rate, not a value, and pair it with NPV before deciding.

The timing of cash flows matters as much as their size. Bring a large inflow forward a year and the IRR rises even though the total cash is unchanged, because money received sooner has more time to compound. That sensitivity is why assumptions about timing should be stress-tested.

A project with a positive IRR can still destroy value if the capital could earn more elsewhere. The IRR is a relative measure, so it must be judged against the return available on the next best use of the same money, adjusted for risk.

When comparing two mutually exclusive projects, always prefer the one with the higher NPV, not the higher IRR, when they conflict. The larger absolute gain is what actually increases wealth, which is the whole point of the decision.