Capital Budgeting

NPV vs. IRR: The Complete Comparison

11 min read

Net Present Value (NPV) and Internal Rate of Return (IRR) stand as the two dominant metrics in capital budgeting analysis. Corporate finance teams use them to evaluate factory expansions, technology investments, and acquisition targets. Private equity firms rely on them to screen deals and measure performance. Investment committees scrutinize both metrics before approving major capital allocations.

For independent projects with conventional cash flows, NPV and IRR typically yield consistent recommendations. Both will indicate acceptance or rejection of the same projects. However, important situations arise where the two metrics conflict, and understanding these conflicts—along with knowing which metric to trust—separates competent analysis from superficial calculation. This guide provides a comprehensive treatment of both methods, examines their mathematical foundations, demonstrates their application through detailed examples, and establishes clear principles for resolving conflicts when they occur.

Net Present Value: The Theoretically Superior Metric

Net Present Value calculates the total value created by an investment in today's dollars. It discounts all expected future cash flows to the present using an appropriate discount rate, then subtracts the initial investment. A positive NPV indicates the investment creates value exceeding its cost; a negative NPV indicates value destruction.

NPV = -C₀ + Σ [Cₜ ÷ (1 + r)ᵗ]
Where C₀ = initial investment, Cₜ = cash flow at time t, r = discount rate

The Economic Interpretation

NPV measures the increase in shareholder wealth from undertaking an investment. If a project has NPV of $5 million, the company could theoretically pay shareholders an immediate $5 million dividend, fund the project entirely with debt at the discount rate, service that debt with project cash flows, and emerge with exactly zero remaining value. The NPV represents pure value creation above the required return.

This wealth interpretation makes NPV directly additive. If Project A has NPV of $10 million and Project B has NPV of $7 million, pursuing both creates $17 million in value. This additivity property proves crucial when evaluating portfolios of projects or comparing combinations of investments.

Decision Rules

For independent projects (where accepting one does not preclude accepting others):

For mutually exclusive projects (where accepting one precludes others), select the project with the highest positive NPV. This rule holds regardless of project size, duration, or cash flow pattern.

Internal Rate of Return: The Intuitive Metric

The Internal Rate of Return is the discount rate that makes NPV exactly equal to zero. Equivalently, IRR is the rate at which the present value of cash inflows equals the present value of cash outflows. It represents the project's effective rate of return, incorporating the timing and magnitude of all cash flows.

0 = -C₀ + Σ [Cₜ ÷ (1 + IRR)ᵗ]
Solve for the rate that makes NPV equal to zero

Unlike NPV, which requires a discount rate as input, IRR is an output—the return embedded in the project's cash flows. This self-contained nature makes IRR intuitive and appealing: a project with 18% IRR "earns" 18% on the investment, a figure easily compared to the cost of capital or alternative investments.

Decision Rules

For independent projects with conventional cash flows:

The gap between IRR and the required return provides a "margin of safety"—projects with IRR substantially exceeding the hurdle rate remain value-creating even if conditions deteriorate somewhat.

When NPV and IRR Agree

For independent projects with conventional cash flows (an initial outflow followed by a series of inflows), NPV and IRR always yield consistent accept/reject decisions. This consistency occurs because the NPV profile—a graph of NPV versus discount rate—crosses zero exactly once, at the IRR. For discount rates below the IRR, NPV is positive; for rates above the IRR, NPV is negative.

Conventional Cash Flow Pattern: Time 0: Outflow (negative); Times 1, 2, 3, ... : Inflows (positive). Most standard investments follow this pattern: invest today, receive returns over time.

This agreement breaks down in specific circumstances, each presenting different analytical challenges.

Conflict Scenario 1: Mutually Exclusive Projects of Different Scale

When evaluating mutually exclusive projects (selecting one precludes the other), IRR can mislead because it ignores project scale. A 50% return on $100 creates less wealth than a 30% return on $1,000.

Example: Equipment Selection Decision

A manufacturer must choose between two production systems. The company's cost of capital is 12%.

Year System Alpha System Beta
0 ($500,000) ($2,000,000)
1 $200,000 $700,000
2 $200,000 $700,000
3 $200,000 $700,000
4 $200,000 $700,000

System Alpha Analysis:

NPV = -$500,000 + $200,000 × PVIFA(12%, 4)
NPV = -$500,000 + $200,000 × 3.0373 = $107,460
IRR = 21.9% (rate where NPV = 0)

System Beta Analysis:

NPV = -$2,000,000 + $700,000 × PVIFA(12%, 4)
NPV = -$2,000,000 + $700,000 × 3.0373 = $126,110
IRR = 15.0% (rate where NPV = 0)

The Conflict: IRR favors Alpha (21.9% > 15.0%). NPV favors Beta ($126,110 > $107,460).

The Correct Decision: Choose Beta. It creates $18,650 more value despite its lower percentage return. The higher IRR on Alpha applies to a smaller investment base; percentage returns without scale context mislead.

Resolving Scale Conflicts: The Incremental Approach

An alternative approach examines the incremental investment—what does the additional capital in the larger project earn? If Beta requires $1,500,000 more than Alpha but generates $500,000 more in annual cash flows, analyze this increment:

Incremental Cash Flow Analysis

Year Beta - Alpha (Incremental)
0 ($1,500,000)
1-4 $500,000 per year
Incremental IRR = 12.6%

Since the incremental investment earns 12.6%—exceeding the 12% cost of capital—the additional investment in Beta creates value. Choose Beta.

Conflict Scenario 2: Different Cash Flow Timing Patterns

Projects with different cash flow timing can show conflicting rankings even at similar scales. This occurs because NPV and IRR make different assumptions about reinvestment of intermediate cash flows.

Example: Timing Difference

Two projects require identical $1 million investments. Cost of capital is 10%.

Year Project Early Project Late
0 ($1,000,000) ($1,000,000)
1 $800,000 $100,000
2 $400,000 $200,000
3 $200,000 $300,000
4 $100,000 $1,000,000

Results:

Project Early: NPV = $227,914 | IRR = 27.3%
Project Late: NPV = $243,426 | IRR = 21.5%

The Conflict: IRR favors Early (27.3% > 21.5%). NPV favors Late ($243,426 > $227,914).

The Reinvestment Rate Assumption

This conflict exposes a critical difference in what the two metrics assume about reinvesting intermediate cash flows:

NPV assumes reinvestment at the discount rate (cost of capital). The Year 1 cash flow from Project Early, when reinvested at 10%, contributes its discounted value to total NPV. This assumption is generally realistic—the discount rate reflects the company's opportunity cost for capital.

IRR implicitly assumes reinvestment at the IRR itself. For Project Early's 27.3% IRR to be truly realized, all intermediate cash flows must be reinvested at 27.3%. If the company can only reinvest at 10%, the actual return falls short of the calculated IRR.

This reinvestment assumption explains why IRR favors early-cash-flow projects. It credits them for reinvesting at inflated rates, overstating their true value relative to later-cash-flow projects.

Analytical Principle: NPV's reinvestment assumption (at the cost of capital) is more economically realistic than IRR's assumption (at the IRR). This gives NPV theoretical superiority when timing patterns differ.

Conflict Scenario 3: Non-Conventional Cash Flows

When cash flows change signs more than once (outflow, inflow, outflow, or similar patterns), multiple IRRs may exist—or no real IRR at all. This occurs in projects requiring intermediate investments, environmental remediation, or decommissioning costs.

Example: Mining Project with Reclamation Costs

A mining operation requires initial investment, generates profits, then incurs cleanup costs:

Year Cash Flow
0 ($100,000)
1 $320,000
2 ($230,000)

This project has two IRRs: 15.0% and 100.0%. Which should be used? Neither answer is clearly correct. The NPV profile crosses zero twice, rising from negative at low discount rates, becoming positive, then declining back to negative at high rates.

At 10% cost of capital: NPV = -$100,000 + $320,000/1.10 - $230,000/1.21 = $1,735 (positive)

NPV provides a clear, single answer; IRR does not.

The number of potential IRRs equals the number of sign changes in the cash flow stream (Descartes' rule). While some cash flow patterns may produce only one economically meaningful IRR, the mathematical possibility of multiple solutions undermines IRR's reliability for non-conventional investments.

Modified Internal Rate of Return (MIRR)

The Modified Internal Rate of Return addresses IRR's reinvestment rate problem. MIRR assumes positive cash flows are reinvested at the cost of capital (like NPV) while negative cash flows are financed at the financing rate (often also the cost of capital).

MIRR = (Terminal Value of Inflows ÷ PV of Outflows)^(1/n) - 1
Where terminal value compounds inflows at reinvestment rate to end of project

MIRR Calculation Process

  1. Compound all cash inflows to the terminal date at the reinvestment rate (typically cost of capital)
  2. Discount all cash outflows to present value at the financing rate
  3. Calculate the rate that equates these two values over the project's life

Example: MIRR Calculation

Project: Initial investment $100,000; cash inflows of $40,000 per year for 4 years; cost of capital 10%.

Step 1: Terminal Value of Inflows (compounded at 10%)

Year 1: $40,000 × (1.10)³ = $53,240
Year 2: $40,000 × (1.10)² = $48,400
Year 3: $40,000 × (1.10)¹ = $44,000
Year 4: $40,000 × (1.10)⁰ = $40,000
Terminal Value = $185,640

Step 2: PV of Outflows

PV = $100,000 (already at time 0)

Step 3: Calculate MIRR

MIRR = ($185,640 / $100,000)^(1/4) - 1 = 16.7%

Compare to traditional IRR of 21.9%. The lower MIRR reflects realistic reinvestment at 10% rather than the inflated implicit assumption of 21.9%.

MIRR produces a single solution even for non-conventional cash flows and uses realistic reinvestment assumptions. However, it still expresses returns as percentages, which can mislead when comparing projects of different scale. For mutually exclusive decisions, NPV remains preferred.

Practical Framework for Professional Analysis

When to Use Each Metric

Use NPV When:

  • Comparing mutually exclusive projects
  • Projects have different scales
  • Cash flow timing differs significantly
  • Non-conventional cash flows exist
  • Determining actual value creation
  • Making final investment decisions

Use IRR When:

  • Quick screening of independent projects
  • Communicating returns to non-finance audiences
  • Comparing returns to external benchmarks
  • Assessing margin of safety over cost of capital
  • Private equity performance measurement
  • Cash flows are conventional

Industry Conventions

Different industries emphasize different metrics based on historical practice and stakeholder expectations:

Industry/Context Primary Metric Rationale
Corporate Finance NPV Focus on shareholder value creation
Private Equity IRR Fund performance measured by return rates
Real Estate Development IRR and Equity Multiple Industry convention; return-focused investors
Oil & Gas Exploration NPV at standardized rates Enables comparison across projects with different risk
Project Finance IRR (with NPV verification) Lenders focus on debt service coverage

Best Practices for Investment Analysis

  1. Calculate both metrics. NPV for the decision, IRR for context and communication.
  2. For conflicts, trust NPV. It directly measures value creation without distortion.
  3. Check cash flow patterns. If non-conventional, rely exclusively on NPV or use MIRR.
  4. Consider incremental analysis. For mutually exclusive projects, analyze the incremental investment separately.
  5. Sensitivity analysis. Test how NPV and IRR change under different assumptions for key variables.
  6. Recognize IRR's limitations. High IRR on small investments may create less value than moderate IRR on large investments.

Common Analytical Errors

Error 1: Choosing Highest IRR Among Mutually Exclusive Projects

This ignores scale effects. Always compare NPV for mutually exclusive decisions.

Error 2: Ignoring Multiple IRR Possibility

When cash flows change signs multiple times, check for multiple IRRs or use NPV directly.

Error 3: Comparing IRR to Wrong Benchmark

IRR should be compared to the project's appropriate risk-adjusted cost of capital, not arbitrary hurdle rates or different-risk alternatives.

Error 4: Assuming IRR Equals Actual Return

IRR's implicit reinvestment assumption means actual returns typically differ from calculated IRR, especially for projects with large intermediate cash flows.

Error 5: Ignoring Capital Rationing Implications

When capital is constrained, the profitability index (NPV per dollar invested) may outperform both simple NPV and IRR rankings.

Key Takeaways:

1. NPV measures absolute value creation; IRR measures percentage return. For wealth maximization, NPV is theoretically superior.

2. For independent projects with conventional cash flows, NPV and IRR yield consistent recommendations.

3. Conflicts arise with mutually exclusive projects, different timing patterns, and non-conventional cash flows. In all cases, trust NPV.

4. IRR's reinvestment assumption (at the IRR) is unrealistic; NPV's assumption (at cost of capital) reflects economic reality.

5. Use both metrics professionally: NPV for decisions, IRR for communication and margin-of-safety assessment.

Calculate NPV and IRR

Use our interactive calculator to evaluate projects with uneven cash flows.

Open NPV & IRR Calculator