Introduction

Even though NPV and IRR have been around for years, their confusion persists among finance professionals. The confusion usually arises when it comes to simple calculations — any analyst can work out an NPV or an IRR for a given cash flow and discount rate. The confusion lies in the interpretation: what does a positive NPV really mean for whether an investment should be made? Why is it that sometimes the IRR and NPV will give different recommendations for the same project? Under what circumstances is it appropriate to use IRR, and under what circumstances is it not? The problem with capital budgeting errors stemming from misunderstandings of these metrics is that they lead to investment decisions that, on the surface, seem analytical and well thought out, but in reality are systematically biased in predictable ways.

An answer to the question “Why IRR is misunderstood even by experienced analysts” is “because it was designed as a simplified decision rule for situations where the discount rate is uncertain, and it works well within these confines. It is, however, very often used where it is not applicable, such as for mutually exclusive projects, for projects with non-conventional cash flows, and as a comparison criterion for projects of very different magnitudes; in those cases, it leads to incorrect or false conclusions. The challenges around NPV calculation are of a different nature: For most investments, the NPV is the right one to use, but it is sensitive to the discount rate assumption, which analysts often do not appreciate.

It is for finance analysts and investment professionals who are seeking a deep conceptual grasp of NPV and IRR to apply these concepts correctly, and for those who create investment appraisal frameworks and need to develop the practical skills of capital budgeting, immune to the biggest and most common mistakes.

What NPV and IRR Actually Measure — and Why That Matters

The conceptual distinction in finance concepts is explained simply.

Finance concepts explained simply: NPV is an estimate of how much an investment will add in dollar terms at a particular discount rate at a specific time, reflecting the opportunity cost of the money invested. IRR is the discount rate at which the investment has a zero NPV – it is the break-even rate of return on the investment. The two above metrics are asking different questions: NPV asks “How much value does this investment create on my cost of capital?” and IRR asks “What is the highest cost of capital at which this investment creates value? This is because they’re using the same cash flows and still getting different numbers.

• NPV is an absolute measure: It shows you the $ value of value creation, over and above the cost of capital hurdle, and that is the most direct comparison possible across differently sized investments – only if they call for the same level of capital outlay.

• IRR is a relative measure, meaning it is not a dollar amount of value creation; therefore, it is easy to compare across different investment sizes, but it poses specific issues when investments have very different cash flow profiles or sizes.

When the two metrics give the same answer, and when they diverge

The most common mistake in investment appraisal is assuming that the NPV and IRR will always give the same advice. However, they make the same accept/reject decision when they consider one independent investment that has conventional cash flows (one withdrawal followed by a series of inflows): Accept if NPV > 0, or if IRR > cost of capital; reject if NPV < 0, or if IRR < cost of capital. The issues arise when this equivalence is wrongly assumed across all investment situations, such as mutually exclusive investments, investments of different magnitudes, and investments with even non-conventional cash flows.

Five Sources of NPV and IRR Confusion in Practice

There are five common valuation pitfalls that analysts face related to NPV and IRR, which can be grouped into three categories. Each is an analytical error that can have a definite and predictable effect.

Source of Confusion	What Happens	Investment Appraisal Errors Produced	Correct Approach
1. Using IRR to rank mutually exclusive investments	IRR ranks two mutually exclusive investments; the higher-IRR investment is selected; the lower-IRR investment would have produced a higher NPV because it was larger in scale	NPV vs IRR confusion in this situation: a $1 million investment with a 40 per cent IRR may produce less value than a $10 million investment with a 25 per cent IRR, depending on the cost of capital; IRR tells you nothing about which investment creates more value unless the capital outlay is identical	For mutually exclusive investments, rank by NPV at the relevant cost of capital, not by IRR; if IRR must be used, apply the incremental IRR analysis: calculate the IRR of the cash flow difference between the two investments and compare it to the cost of capital
2. Applying IRR to projects with non-conventional cash flows	A project with an initial outflow, followed by inflows, followed by a large outflow (for decommissioning, remediation, or contract termination costs) has multiple IRRs: there is more than one discount rate at which the NPV equals zero	Capital budgeting mistakes from this error: the analyst calculates a single IRR and treats it as the correct return rate; the project may be presented as having an attractive IRR when the correct interpretation is that the IRR metric is inapplicable	For projects with non-conventional cash flows, use NPV and abandon IRR; alternatively, use the Modified IRR (MIRR), which assumes explicit reinvestment and financing rates and produces a single, unambiguous return rate
3. Ignoring the reinvestment rate assumption embedded in IRR	IRR implicitly assumes that cash flows received during the life of the project are reinvested at the IRR rate; for high-IRR projects, this assumption is almost always unrealistic because the IRR rate exceeds any realistic reinvestment rate	Finance analysis confusion explained: an investment with an IRR of 35 per cent implicitly assumes that all interim cash flows are reinvested at 35 per cent; if the realistic reinvestment rate is 8 per cent, the actual return to the investor is substantially lower than the IRR suggests	Use MIRR with an explicit, realistic reinvestment rate rather than IRR for any investment where interim cash flows are material; the MIRR will consistently be below the IRR for high-return investments and provides a more accurate picture of actual investor returns
4. Treating NPV sensitivity as binary	NPV is presented as a single number that is either positive (invest) or negative (do not invest); the sensitivity of that number to the discount rate assumption is not analysed; the decision is treated as binary when it is fundamentally a probability-weighted range	NPV calculation challenges: a project with an NPV of $500,000 at an 8 per cent discount rate that becomes NPV negative at a 9 per cent rate is a fundamentally different investment decision from one that remains NPV positive at a 1 per cent rate; the single-number NPV presentation obscures this	Always present NPV as a sensitivity range across a realistic band of discount rates; present the IRR as the discount rate at which NPV equals zero; this naturally communicates the uncertainty in the analysis without requiring the reader to understand the technical detail of the sensitivity
5. Conflating the IRR of an investment with the return to a specific investor	The IRR of a project’s cash flow is not the same as the IRR of the equity return if the project is partially debt-financed; the equity IRR accounts for the leverage effect and will be higher than the project IRR when the project generates returns above the cost of debt	Understanding NPV and IRR clearly: private equity and infrastructure investors are typically interested in the equity IRR (the return on their specific investment), not the project IRR; reporting the project IRR to an equity investor as their expected return is materially misleading when the investment is leveraged	Calculate both the project IRR (unlevered return on the total capital invested) and the equity IRR (return on the equity tranche only); be explicit about which is being reported and to whom; ensure the return metric reported matches the question the investor is asking

The most sophisticated, and most routinely ignored, source of confusion is source of confusion 3 — the reinvestment rate assumption that is assumed as part of IRR. The reason for IRR’s lack of respect as a tool among long-time users is partially due to this assumption, which is not written anywhere in the model or presentation; it is built into the mathematical model used to calculate IRR. For most investors and most investments, this assumption is a whole lot of fantasy—an investment with a 30 per cent IRR tacitly assumes that all cash flow will be reinvested at 30 per cent. Using this assumption in practical capital budgeting skills yields more realistic return expectations and more appropriate investment decisions than would treating IRR as a measure of the investor’s return.

How to Use NPV and IRR Correctly and Confidently

A practical framework for practical capital budgeting skills.

Properly using capital budgeting techniques to arrive at appropriate and defensible investment decisions requires a systematic methodology for selecting metrics, testing assumptions, and interpreting results, beyond the mechanical calculation of the metrics. The four-step process below shows how analysts who apply the principles of NPV and IRR correctly handle each investment appraisal situation.

Phase 1	Phase 2	Phase 3	Phase 4
Cash Flow Classification	Metric Selection and Calculation	Sensitivity Analysis	Decision Recommendation
Before calculating either metric, classify the investment as independent or mutually exclusive. Are the cash flows conventional or non-conventional? Is the investment significantly leveraged? The answers determine which metrics are appropriate and which adjustments are required	Calculate NPV as the primary metric; calculate IRR as a secondary metric where the cash flow structure makes it appropriate; calculate MIRR with an explicit reinvestment rate where interim cash flows are material; calculate equity IRR separately from project IRR for leveraged investments	Present NPV as a range across at least five discount rate levels; identify the discount rate at which NPV equals zero (i.e., the IRR) and compare it to the realistic range of cost of capital estimates; present the investment recommendation as a function of the discount rate range, not as a single-rate binary decision	Frame the investment recommendation around NPV at the central cost of capital estimate; use the IRR as context for communicating the margin of safety between the estimated cost of capital and the investment’s breakeven rate; explicitly address any situations where NPV and IRR diverge

Real cases: NPV and IRR confusion in practice

In the same week, a diversified industrial business’s capital allocation committee was presented with two mutually exclusive capital investment choices. Project A required an investment of $2 million and was projected to deliver an IRR of 34 per cent. The IRR for project B was 22 per cent with $15 million in investment. The project selection was made per the IRR, with project A chosen because it had the highest IRR. The company’s cost of capital was 10 per cent. The NPV of Project A was about $1.4 million, and the NPV of Project B was about $7.8 million at that capital rate. The company opted for the smaller project, which would generate a higher percentage return. It declined the larger project, which would generate more than 5 times the absolute value at the same cost of capital. Errors in capital budgeting decisions when ranking and selecting mutually exclusive projects using IRR: IRR is the wrong metric for the wrong decision (mutually exclusive projects).

In another project, a project finance analyst was requested to provide the return expected by equity shareholders on an infrastructure project, where 45 per cent of the total project cost is being financed by debt. She quoted the project’s IRR at 12.4 per cent, which is the expected return for equity investors. Using the same set of cash flow assumptions, the equity IRR (the return to the equity tranche, taking into account leverage) was 16.8 per cent. The equity investors had been told they were getting a 12.4 per cent return, but it was actually 16.8 per cent. The difference was not a mistake in the cash flow estimates – it was a result of common valuation missteps that analysts make when attempting to merge the concepts of project-level and equity-level returns in leveraged investments. The right answer involved both figuring out both measurements and stating which was which and to whom they were relevant.

Conclusion

The confusion between NPV and IRR does not arise because either is really obscure, but rather because the circumstances under which they differ or become misleading aren’t taught with the same sophistication as the case itself. The errors made in capital budgeting due to this confusion are each foreseeable, frequent and completely avoidable if a conceptual understanding is developed instead of further practice in computation.

For investment appraisal practitioners: Always show NPV over a range of discount rates that covers a realistic range; this is the only change in standard capital budgeting practice that yields more honest and more useful investment analysis than all others.

Its limitations are almost always not explicitly taught, which is why experienced practitioners misunderstand IRR: the growth of the specific conceptual understanding of its inapplicability to certain situations is the greatest investment in the education of IRR/NPV.

NPV and IRR share a common focus, but they ask different questions: NPV answers the dollar-value question at a given cost of capital; IRR answers at what cost of capital does the investment break even? The question being asked is the right metric to use – if you ask the dollar value question, you should use NPV; if you ask the at what cost of capital question, you should use IRR.