NPV vs. IRR
Executive Summary
Key Takeaways
- ✓ NPV and IRR are calculated from the same cash flow series and usually agree on whether a single, standalone project should be accepted.
- ✓ NPV measures absolute value creation in currency terms; IRR expresses the same cash flows as a percentage return.
- ✓ NPV always ranks mutually exclusive projects correctly at a given discount rate; IRR can rank them differently when projects differ materially in scale, timing, or cash flow pattern.
- ✓ Non-conventional cash flow series (more than one sign change) can produce multiple or no real IRR solutions, a problem NPV does not have.
- ✓ Institutional practice generally defers to NPV when the two metrics conflict, since it directly measures value creation at the entity's actual cost of capital.
Definitions¶
Net present value (NPV), as defined on the NPV glossary page, is the sum of a project's cash flows, each discounted back to the present at a chosen discount rate, minus the initial investment — an absolute currency figure representing expected value creation.
Internal rate of return (IRR), as defined on the IRR glossary page, is the discount rate at which a project's NPV equals exactly zero — a percentage return calculated from the same underlying cash flow series.
Side-by-Side Comparison¶
| Dimension | NPV | IRR |
|---|---|---|
| Output form | Absolute currency value | Percentage return |
| What it measures | Value created in excess of the discount rate applied | The discount rate at which the project exactly breaks even on a present-value basis |
| Reinvestment assumption | None — future cash flows are simply discounted at the chosen external rate | Implicitly assumes interim cash flows reinvest at the IRR itself |
| Ranking mutually exclusive projects of different scale | Always ranks correctly at a given discount rate | Can rank differently, favoring a smaller, higher-percentage-return project over a larger, higher-absolute-value one |
| Non-conventional cash flows (multiple sign changes) | Always produces a single, unambiguous value | Can produce multiple real solutions, or none |
| Ease of communication | Requires stating a currency figure alongside the discount rate used | A single percentage figure is intuitive to compare against a hurdle rate |
| Dependence on an externally chosen discount rate | Direct — the result changes with the rate chosen | Indirect — IRR itself does not require a discount rate to calculate, only to interpret against a hurdle |
Decision Framework¶
Use NPV as the primary criterion whenever comparing or ranking mutually exclusive projects, particularly where they differ materially in scale, timing, or cash flow pattern, since NPV alone guarantees a value-maximizing ranking at the entity's actual cost of capital.
Use IRR as a complementary, intuitive percentage-return figure, useful for quick comparison against a hurdle rate and for communicating a return figure to audiences accustomed to thinking in percentage terms — but not as the sole basis for ranking mutually exclusive projects of different scale.
Use both together for any material capital budgeting decision, cross-checking that they do not conflict, and specifically investigating the reason for any conflict when NPV and IRR do rank a set of projects differently.
Why the Ranking Conflict Happens¶
The ranking conflict between NPV and IRR arises specifically because IRR is scale-indifferent while NPV is not. Consider two mutually exclusive projects:
| Project | Initial Investment | IRR | NPV (at 10% discount rate) |
|---|---|---|---|
| Small | 100 | 40% | 45 |
| Large | 1,000 | 18% | 220 |
Project Small shows a far higher IRR, but Project Large creates almost five times as much absolute value. Selecting Project Small purely because of its higher IRR would forgo the larger amount of value creation that Project Large offers — a direct consequence of IRR being a percentage measure that does not, on its own, account for the amount of capital deployed.
A similar conflict can arise from differences in the timing of cash flows even at similar scale — a project with cash flows concentrated early can show a higher IRR than one with the same total value but cash flows concentrated later, because IRR's implicit reinvestment assumption rewards earlier cash recovery more heavily than NPV does.
The Multiple-IRR Problem¶
For a conventional cash flow series — a single initial outflow followed only by inflows — IRR is well-behaved and produces exactly one real solution. For a non-conventional series, with more than one change of sign (for example, a project with a significant mid-life reinvestment or decommissioning outflow), the equation defining IRR can mathematically yield more than one discount rate at which NPV equals zero, or none at all. NPV does not have this problem: it produces a single, unambiguous value at any chosen discount rate, regardless of how many times the cash flow series changes sign. MIRR is the standard remedy when a percentage-return metric is still preferred for a non-conventional cash flow series — see MIRR vs. IRR.
Advantages¶
NPV advantages: always ranks mutually exclusive projects correctly at the chosen discount rate; no embedded reinvestment assumption; always produces a single, unambiguous result regardless of cash flow pattern.
IRR advantages: intuitive percentage form, easy to compare directly against a hurdle rate; does not require choosing a discount rate to calculate the metric itself (only to interpret it against a benchmark); widely understood across finance audiences.
Limitations¶
NPV limitations: the result is stated in absolute currency terms, which does not directly communicate the rate of return, and is not directly comparable across projects of very different scale without also considering the capital committed.
IRR limitations: can rank mutually exclusive projects differently than NPV; embeds an often-unrealistic reinvestment-at-IRR assumption; can produce multiple or no real solutions for non-conventional cash flows.
Common Misconceptions¶
"A higher IRR always means a better project." Only true when comparing projects of similar scale and cash flow pattern. For mutually exclusive projects that differ materially in either dimension, IRR can favor the wrong project relative to absolute value creation.
"NPV and IRR will always agree." They agree on the accept/reject decision for a single, standalone, conventional project at a given discount rate, but can disagree on ranking between multiple mutually exclusive projects — this is the specific, well-documented exception, not a sign that one of the two calculations is wrong.
"IRR is outdated because of these limitations." IRR remains a legitimate and widely used metric — its limitations are specific to ranking mutually exclusive projects and non-conventional cash flows, not to its validity as a return measure for a single project evaluated on its own terms.
References & Further Reading¶
- Brealey, R., Myers, S., and Allen, F., Principles of Corporate Finance, McGraw-Hill
- CFA Institute, CFA Program Curriculum — Corporate Finance and Capital Budgeting
Continue Reading¶
Prerequisites¶
Related Pillars¶
Related Glossary¶
Related Comparisons¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the fundamental difference between NPV and IRR?
NPV expresses a project's value creation as an absolute currency amount, discounted at a chosen rate. IRR expresses the same underlying cash flow series as a percentage return — specifically, the discount rate at which NPV equals exactly zero.
Do NPV and IRR always agree on whether to accept a project?
For a single, standalone, conventional project (one initial outflow followed only by inflows), yes — a positive NPV at the discount rate corresponds to an IRR above that same discount rate, and vice versa. They can disagree specifically on ranking between multiple mutually exclusive projects.
Why can NPV and IRR rank mutually exclusive projects differently?
Because IRR is a percentage return, indifferent to project scale, while NPV is an absolute value. A smaller project can show a higher IRR while creating less absolute value than a larger project with a lower IRR, particularly when the projects differ materially in scale, cash flow timing, or pattern.
Which metric should be used when NPV and IRR disagree?
Institutional practice generally defers to NPV, since it directly measures the absolute value created at the entity's actual cost of capital, without IRR's embedded reinvestment-rate assumption distorting the comparison.
What is the multiple-IRR problem?
A non-conventional cash flow series — one with more than one change of sign, such as an initial outflow, followed by inflows, followed by a later outflow — can mathematically produce more than one discount rate at which NPV equals zero, or none at all, making IRR ambiguous or undefined. NPV does not have this problem; it produces a single, unambiguous value at any given discount rate.
Is IRR still useful given these limitations?
Yes. IRR remains intuitive and widely used because a percentage return is easy to communicate and compare against a hurdle rate. Its limitations are specifically around ranking mutually exclusive projects and non-conventional cash flows — for a single standalone project with conventional cash flows, it remains a reliable and informative metric, best read alongside NPV rather than in isolation.
How does MIRR relate to this comparison?
MIRR addresses IRR's reinvestment-rate assumption and the multiple-IRR problem directly, while still expressing the result as a percentage return like IRR does. See the dedicated MIRR vs. IRR comparison for how MIRR specifically differs from IRR.
Related Articles
Investment Analysis and Capital Budgeting
Investment analysis and capital budgeting is the discipline of deciding whether a project or investment is expected to create value, using a toolkit of quantitative techniques — net present value, internal rate of return, modified internal rate of return, payback period, and the profitability index — each applied to the same underlying forecast cash flow series but answering a subtly different question. This page is the hub for the Knowledge Centre's investment analysis content: what each technique measures, how the techniques relate to and sometimes conflict with one another, how discount rates and hurdle rates are set, how risk is layered onto the analysis through sensitivity, scenario, and Monte Carlo methods, and — distinctively — how capital-budgeting failure modes map onto FMAE's existing structural audit rule taxonomy.
NPV (Net Present Value)
Net Present Value (NPV) is the sum of a series of future cash flows, each discounted back to the present at a chosen discount rate, minus any initial investment. It is one of the two most commonly used discounted cash flow metrics in financial modelling, alongside IRR, and one of the more frequently misapplied Excel functions, due to a timing convention that is easy to get wrong.
IRR (Internal Rate of Return)
Internal Rate of Return (IRR) is the discount rate at which the net present value of a series of cash flows equals zero. It is the generic form of a metric that appears in financial models in several more specific variants, most commonly Project IRR and Equity IRR, each defined on its own cash flow basis. This page defines the generic IRR concept and the Excel functions used to calculate it; for the project finance-specific variants, see Project IRR and Equity IRR.
MIRR vs. IRR
Internal rate of return (IRR) and modified internal rate of return (MIRR) both express a project's return as a single percentage figure calculated from the same underlying cash flow series, but they differ in a specific and consequential way: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself for the remainder of the project's life, an assumption that is often unrealistic, particularly for projects with a high IRR. MIRR replaces this implicit assumption with two explicit, separately specified rates — a finance rate for outflows and a reinvestment rate for inflows — producing a single, more defensible rate of return and eliminating the possibility of multiple or no real solutions for a non-conventional cash flow series.