NPV vs IRR: Resolving Conflicting Investment Signals
NPV and IRR can rank two investments differently. The conflict is not a spreadsheet malfunction. It usually reflects differences in project scale, cash-flow timing or cash-flow pattern.
For mutually exclusive projects, net present value should normally lead the value-creation decision when cash flows and the discount rate are consistently defined and capital is not subject to a binding constraint. Internal rate of return remains useful, but it is a return measure rather than a direct measure of absolute value created.
This guide explains the conflict with a worked example and a decision hierarchy managers can apply before approving capital.
NPV and IRR answer different questions
Net present value (NPV) asks: after discounting future incremental cash flows at the required return, how much value does this project add today?
NPV = C_0 + Σ C_t / (1+r)^t
where C_0 is usually the initial investment, C_t is the incremental cash flow in period t, and r is the discount rate.
Internal rate of return (IRR) asks: at what discount rate does the project's NPV equal zero?
0 = C_0 + Σ C_t / (1+IRR)^t
NPV produces a currency amount. IRR produces a percentage. The two measures often point in the same direction for a conventional stand-alone project, but their rankings can diverge when projects are mutually exclusive.
Worked example: a scale conflict
A company can choose only one of two one-year projects. Cash flows are in EUR thousands.
| Cash flow | Project A | Project B |
|---|---|---|
| Initial investment, Year 0 | -100 | -1,000 |
| Cash inflow, Year 1 | 150 | 1,300 |
Assume both projects have comparable risk and the appropriate hurdle rate for the cash flows is 10%.
Project A
NPV_A = -100 + 150/1.10 = EUR 36.36k
IRR_A = 150/100 - 1 = 50%
Project B
NPV_B = -1,000 + 1,300/1.10 = EUR 181.82k
IRR_B = 1,300/1,000 - 1 = 30%
The signals conflict:
| Metric | Higher-ranked project | Reason |
|---|---|---|
| IRR | A | 50% is higher than 30% |
| NPV at 10% | B | EUR 181.82k is greater than EUR 36.36k |
Project A generates the higher percentage return. Project B creates EUR 145.45k more present value, but requires EUR 900k more initial capital.
If the projects are mutually exclusive, the company can fund either one, and the objective is to maximize value at the stated 10% opportunity cost, Project B is the stronger choice.
Use incremental cash flow to resolve the ranking
Compare the larger project with the smaller one by subtracting A from B:
| Incremental cash flow: B − A | Amount (EUR k) |
|---|---|
| Year 0 | -900 |
| Year 1 | 1,150 |
The incremental NPV at 10% is:
Incremental NPV = -900 + 1,150/1.10 = EUR 145.45k
Because the incremental NPV is positive, committing the additional EUR 900k to B creates value at a 10% required return.
The incremental IRR is:
Incremental IRR = 1,150/900 - 1 = 27.78%
This is also the crossover rate: the discount rate at which Projects A and B have the same NPV. Below 27.78%, B has the higher NPV. Above 27.78%, A has the higher NPV. At the stated 10% hurdle rate, B wins decisively.
The incremental test explains the economic question hidden by the percentages: is the extra investment required for B worthwhile relative to the smaller alternative?
A hierarchy for resolving NPV–IRR conflicts
| Step | Decision question | Rule |
|---|---|---|
| 1 | Are the cash flows incremental? | Exclude sunk costs; include opportunity costs and side effects |
| 2 | Are the projects independent or mutually exclusive? | Do not use a ranking conflict to reject positive-NPV independent projects when capital is available |
| 3 | Are risk and timing reflected consistently? | Use a discount rate appropriate to the cash flows; do not mix nominal and real values |
| 4 | Is the objective absolute value creation? | Rank mutually exclusive projects by NPV at the relevant opportunity cost |
| 5 | Why do rankings differ? | Test scale, timing and non-conventional cash-flow patterns |
| 6 | What does the incremental project show? | Calculate B − A; accept the larger project when incremental NPV is positive |
| 7 | Is capital genuinely constrained? | Use portfolio optimization and the scarce resource explicitly; do not substitute raw IRR |
| 8 | Does the recommendation survive uncertainty? | Test discount rate, cash-flow scenarios and implementation delay |
This hierarchy develops the capital-budgeting layer mentioned in the broader Strategic Finance Decision Stack without repeating its full management framework.
Three common causes of conflicting rankings
1. Scale
The worked example is a scale conflict. A small project can earn a high percentage return while creating less total value than a larger project.
IRR does not say how many euros are invested or created. A 100% return on EUR 10 is not automatically preferable to a 20% return on EUR 1 million.
2. Timing
One project may return cash early while another produces more cash later. As the discount rate changes, the relative value of those timing patterns changes. Plotting each project's NPV across a range of discount rates reveals the crossover.
Timing conflicts require management to verify that the discount rate represents the opportunity cost and risk of the cash flows. Selecting the rate that makes a preferred project win reverses the logic of appraisal.
3. Non-conventional cash flows
A conventional project normally has one initial outflow followed by inflows. A project with later decommissioning costs, remediation obligations or repeated investment may change sign more than once.
Such a pattern can produce multiple IRRs or no economically useful IRR. NPV at an explicitly chosen discount rate remains interpretable, while management should inspect the entire cash-flow profile and the obligations creating later outflows.
When NPV should lead
NPV is the stronger primary rule when:
- alternatives are mutually exclusive;
- the organization seeks to maximize value rather than percentage return;
- incremental cash flows are consistently modelled;
- the discount rate reflects the relevant opportunity cost and risk;
- capital can support the selected project;
- the project does not create an unmodelled liquidity or strategic constraint.
“Highest NPV” is not permission to ignore execution. A large positive NPV built on unachievable capacity, an unfinanceable cash trough or a missing regulatory dependency is not decision-ready. Finance should keep evidence, assumptions and constraints visible.
When IRR remains useful
IRR can help managers:
- compare a project's implied return with a hurdle rate;
- communicate return in percentage terms;
- identify the crossover rate on incremental cash flows;
- see how much discount-rate headroom a conventional project appears to have.
But IRR should be treated cautiously when:
- mutually exclusive projects differ materially in scale;
- cash flows differ in timing;
- cash flows change sign more than once;
- the computed rate is implausibly high;
- a spreadsheet depends on an initial guess or fails to converge;
- irregular dates require XIRR rather than equal-period IRR.
Microsoft's official NPV function documentation notes an important timing convention: Excel's NPV function treats listed cash flows as occurring at the end of periods, so an immediate Year 0 investment is normally added separately. Its IRR documentation defines IRR as the rate corresponding to zero NPV and explains that the function solves iteratively. Spreadsheet syntax should follow the actual timing of the investment rather than a copied template.
What changes under capital rationing
If capital is genuinely constrained, “choose every positive-NPV project” may not be feasible. The decision becomes a portfolio problem: which combination of divisible or indivisible projects creates the most NPV within the funding, talent, capacity and risk constraints?
A profitability index can be informative for divisible investments under a single capital constraint, but it can mis-rank indivisible projects or portfolios with multiple constraints. Raw IRR is not a complete optimization rule. Model the constrained portfolio explicitly and show the value sacrificed because of the constraint.
For the worked example, the question is not simply whether EUR 1 million exists. Management should ask whether deploying the additional EUR 900k to B displaces another project with more than EUR 145.45k of NPV, creates unacceptable liquidity risk or violates a strategic constraint.
A decision memo that prevents metric shopping
Before approval, record:
- the mutually exclusive choice or independent-project set;
- the Year 0 investment and incremental cash flows;
- NPV at the approved discount rate;
- IRR and any multiple/no-IRR issue;
- the source of ranking conflict: scale, timing or cash-flow pattern;
- incremental cash flows and incremental NPV;
- capital, liquidity and execution constraints;
- sensitivity and scenario results;
- the recommended option and the evidence that would change it.
This prevents a team from choosing NPV when NPV supports its preference and switching to IRR when IRR looks better.
Final rule
NPV measures expected value added at a specified opportunity cost. IRR measures the break-even discount rate implicit in a project's cash flows. When mutually exclusive projects conflict, analyse incremental cash flows and let NPV at the relevant discount rate lead—unless a real constraint changes the decision problem.
To develop this logic alongside financial analysis, WACC, capital structure, budgeting, valuation and M&A, explore the Executive Certificate in Strategic Finance, M&A & Corporate Valuation.