What is the internal rate of return?
The internal rate of return (IRR) is the annual rate of growth an investment is expected to generate, taking into account exactly when each dollar goes out and comes back. Formally, it is the discount rate that makes the net present value (NPV) of every cash flow equal to zero. If you could earn the IRR in a savings account, putting the initial investment there would leave you exactly as well off as doing the project.
Because IRR is expressed as a percentage, it lets you compare projects of very different sizes and lengths on the same scale and check them against a hurdle rate, such as your cost of capital or the return you could earn elsewhere.
How IRR is calculated
CF0 is the initial investment, entered as a negative number, and CF1 through CFn are the cash flows at the end of each year. There is no algebraic shortcut for solving this equation once there are more than a couple of periods, so the rate is found numerically: the calculator tries rates, measures how far the NPV is from zero and narrows in until the error is negligible.
Example 1: a single project
A workshop buys a machine for $40,000. It is expected to bring in $10,000 in the first year, $20,000 in the second and $30,000 in the third. Testing a 20% discount rate gives an NPV slightly below zero, and 19% gives slightly above zero. Narrowing further, the IRR is 19.438%. If the business can borrow at 8%, the machine clears the hurdle comfortably.
Example 2: comparing two projects
| Year | Property A | Property B |
|---|---|---|
| 0 | −$100,000 | −$100,000 |
| 1 | $5,000 | $0 |
| 2 | $20,000 | $10,000 |
| 3 | $25,000 | $30,000 |
| 4 | $40,000 | $30,000 |
| 5 | $60,000 | $80,000 |
| IRR | 11.290% | 10.259% |
Both properties return $150,000 in total, but A delivers more of its money sooner. Earlier cash is worth more, so A has the higher IRR. This is the main insight IRR captures that a simple total does not.
Fixed cash flow mode
Some investments have a regular, level cash flow instead of an irregular one: a savings plan with monthly deposits, or an annuity that pays out a fixed amount. In that case you only need the initial investment, the holding length, the ending balance and the size and timing of the recurring amount. The calculator solves for the rate per period that grows the initial amount and the stream of deposits or withdrawals to exactly the ending balance, then converts it to an effective annual rate.
What IRR is used for
- Capital budgeting. Companies rank projects by IRR and accept those above their weighted average cost of capital.
- Private equity and real estate. Funds report IRR to investors because capital is called and returned at irregular times.
- Personal finance. IRR answers what return you really earned on an account you added to and withdrew from over time.
Limitations of IRR
- Reinvestment assumption. IRR implicitly assumes interim cash flows can be reinvested at the IRR itself, which is often unrealistic for high-return projects. The modified IRR (MIRR) uses a separate reinvestment rate to address this.
- Scale blindness. A 50% return on $1,000 adds less value than a 15% return on $1 million. Look at NPV alongside IRR when projects differ in size.
- Multiple or no solutions. If cash flows switch between negative and positive more than once, the NPV equation can have several roots, or none.
- Timing only within the model. The result is only as good as the cash flow forecasts that go into it.