One appeal of IRR is that it converts a multi-period cash-flow forecast into a single annualized rate. The simplicity can also hide important differences in project size, timing, reinvestment needs, and unusual cash-flow patterns.
Key Takeaways
- NPV provides the mathematical link: IRR is the discount rate at which NPV equals zero.
- A higher IRR is not automatically better: Project scale and timing can cause IRR and NPV to rank alternatives differently.
- Cash-flow patterns matter: Projects with more than one sign change can produce multiple IRRs or no useful single solution.
- Regular and irregular timing use different spreadsheet tools: IRR assumes equal periods, while XIRR uses actual dates.
How Internal Rate of Return Works
IRR asks which discount rate makes the present value of expected inflows equal the present value of expected outflows. Instead of choosing the discount rate first, as an NPV calculation does, IRR solves for the rate.
The result can then be compared with a required return or hurdle rate. If the IRR exceeds that benchmark, the project may pass the rate-based test; falling below it suggests the projected return does not meet the benchmark.
The IRR Formula
Unlike a simple-interest formula, the equation usually cannot be rearranged into a convenient one-step calculation when there are several cash flows. Financial calculators and spreadsheet software typically solve for IRR iteratively.
IRR Example
Assume an investment costs $10,000 today and is expected to produce $3,500 after year one, $4,000 after year two, and $4,500 after year three.
The discount rate that makes those cash flows have an NPV of zero is approximately 9.28%. With an 8% required return, the IRR clears that hurdle under the forecast.
How to Interpret IRR
An investment with a 12% IRR is not expected to earn exactly 12% every calendar year. IRR is the single discount rate that equates the present value of the modeled inflows and outflows.
Comparison also requires consistent periods. Monthly IRR is a periodic rate, not automatically an annual rate. Spreadsheet conventions and annualization need to match the timing of the cash-flow series.
IRR vs. NPV
| Measure | Output | Strength | Main caution |
|---|---|---|---|
| IRR | Percentage rate | Easy to compare with a hurdle rate | Can mis-rank projects or produce multiple solutions |
| NPV | Dollar value | Shows estimated value created at a chosen discount rate | Depends heavily on the chosen rate and forecasts |
When projects are mutually exclusive, NPV is often more informative about total value created because it preserves project scale. A small project can have a higher IRR while adding fewer dollars of value.
IRR vs. ROI and CAGR
ROI compares gain with investment cost but often ignores when cash flows occur. IRR incorporates timing by discounting each modeled period.
CAGR connects a beginning value with an ending value through one smoothed annual growth rate. It works well for endpoint growth but does not directly model a sequence of contributions, withdrawals, or project cash flows.
When IRR Can Be Misleading
Nonconventional cash flows create the most famous problem. Multiple sign changes in the cash flows can produce more than one valid mathematical solution to the IRR equation.
Some cash-flow patterns produce no real IRR at all. Even with one valid solution, IRR can favor a smaller project with a high percentage return over a larger project that creates more total value.
Another weakness appears when comparing investments with very different timing. Early cash inflows can boost IRR even when another project produces more total discounted value over its full life.
IRR in Excel: IRR vs. XIRR
Excel’s IRR function assumes cash flows occur at regular intervals, such as every month or every year. Because the period is not labeled inside the function, interpretation depends on how the cash-flow series is constructed.
XIRR uses actual dates and is better suited to irregularly timed cash flows. For the same irregular schedule, XNPV can provide the matching present-value calculation.
Frequently Asked Questions (FAQs)
Is a higher IRR always better?
No. A higher IRR can belong to a smaller project that creates less total value, and unusual cash-flow patterns can make the rate misleading.
What does it mean when IRR equals the hurdle rate?
NPV is approximately zero when the hurdle rate and IRR are the same, assuming the same cash flows and timing conventions.
Can an investment have more than one IRR?
Yes. Multiple sign changes in the cash-flow series can create multiple mathematical IRR solutions.