Net Present Value & IRR: Formulas, Examples, and When They Disagree
Net present value (NPV) calculates how much value an investment creates in today’s dollars. The internal rate of return (IRR) is the percentage return a project is expected to earn. Together, they are the two most widely used tools for capital budgeting decisions — from factory expansions and equipment purchases to corporate acquisitions. This guide covers both concepts in depth: what they measure, how to calculate them, and critically, when they agree and when they give conflicting signals.
What is Net Present Value (NPV)?
Net present value is a capital budgeting method that measures the total value an investment creates by comparing the present value of all expected future cash flows to the initial cost. The core principle is the time value of money: a dollar received today is worth more than a dollar received in the future because today’s dollar can be invested immediately.
NPV = Present Value of Future Cash Flows − Initial Investment. A positive NPV means the project creates value for shareholders. A negative NPV means the project destroys value and should be rejected.
The NPV decision rule is straightforward:
| NPV Result | Decision | Interpretation |
|---|---|---|
| NPV > 0 | Accept | Project creates value above the required return |
| NPV = 0 | Indifferent | Project earns exactly the required return |
| NPV < 0 | Reject | Project earns less than the required return |
The discount rate used in NPV analysis represents the project’s opportunity cost of capital — typically the weighted average cost of capital (WACC). The cost of equity component is often derived using the Capital Asset Pricing Model (CAPM).
The Net Present Value Formula (NPV)
Where:
- C0 — initial investment (cash outflow at time zero)
- CFt — expected cash flow at time period t
- r — discount rate (typically the project’s WACC)
- n — total number of periods
Discounting converts future cash flows into today’s dollars using the opportunity cost of capital, allowing an apples-to-apples comparison. A $300,000 cash flow received in 3 years is worth less than $300,000 today because the company could invest that money elsewhere and earn a return equal to its cost of capital.
NPV analysis must use incremental cash flows — only the cash flows that change as a direct result of the investment decision. Exclude sunk costs (money already spent regardless of the decision). Include opportunity costs (e.g., foregone rental income on a company-owned building used for the project). Account for changes in net working capital and any terminal or salvage value at the project’s end.
NPV Example: Evaluating a Capital Investment
Caterpillar (CAT), the world’s largest construction and mining equipment manufacturer, is evaluating a $1,000,000 automated production line for hydraulic components. The investment is expected to generate the following incremental after-tax cash flows over five years. Caterpillar’s WACC is approximately 10%.
| Year | Cash Flow | Discount Factor | Present Value |
|---|---|---|---|
| 0 | -$1,000,000 | 1.0000 | -$1,000,000 |
| 1 | $250,000 | 0.9091 | $227,273 |
| 2 | $300,000 | 0.8264 | $247,934 |
| 3 | $350,000 | 0.7513 | $262,960 |
| 4 | $300,000 | 0.6830 | $204,904 |
| 5 | $280,000 | 0.6209 | $173,858 |
Total PV of Future Cash Flows = $1,116,929
NPV = $1,116,929 − $1,000,000 = $116,929
The NPV is positive, meaning this production line is expected to create approximately $117,000 in shareholder value above what Caterpillar could earn by investing that capital at its 10% cost of capital. Decision: Accept the project.
NPV is additive. If Caterpillar has three independent projects with NPVs of $116,929, $85,000, and $42,000, the total value created by accepting all three is $243,929. This property makes NPV the gold standard for capital budgeting — no other metric combines so cleanly across a portfolio of projects.
What is the Internal Rate of Return (IRR)?
The internal rate of return is the discount rate that makes a project’s NPV exactly equal to zero. In other words, IRR is the annualized rate of return the project is expected to earn on the capital invested.
Think of IRR as the “breakeven” discount rate. If the company’s cost of capital is below the IRR, the project creates value (positive NPV). If the cost of capital exceeds the IRR, the project destroys value (negative NPV). The IRR is the point where the project exactly breaks even.
The IRR decision rule for independent projects with conventional cash flows (a single initial outflow followed by inflows):
- IRR > WACC — Accept the project (it earns more than the cost of capital)
- IRR < WACC — Reject the project (it earns less than the cost of capital)
- IRR = WACC — Indifferent (NPV is zero)
Returning to the Caterpillar (CAT) example: the IRR of the production line investment is approximately 14.4%, which exceeds the 10% WACC. Both NPV and IRR arrive at the same conclusion — accept the project.
The IRR Formula (Internal Rate of Return)
Unlike NPV, the IRR generally cannot be solved with a closed-form equation for projects with more than two cash flow periods. It must be found through iteration — systematically trying different discount rates until the one that produces NPV = 0 is identified. Financial calculators, spreadsheets, and our IRR Calculator handle this iterative process automatically.
Conceptually, IRR represents the highest cost of capital at which the project still breaks even. For Caterpillar (CAT), if their cost of capital were exactly 14.4%, the NPV of the production line would be zero — any cost of capital below that creates value, any above it destroys value.
NPV vs IRR: Which Is Better for Capital Budgeting?
NPV and IRR are the two dominant capital budgeting tools, and for independent projects with conventional cash flows, they always agree on the accept/reject decision. However, they can give conflicting rankings in several important scenarios. Understanding when and why they diverge is critical for making sound investment decisions.
Net Present Value (NPV)
- Measures absolute dollar value created
- Additive across projects
- Uses cost of capital as opportunity-cost benchmark
- Always gives a single, unique answer
- Theoretically superior for ranking projects
Internal Rate of Return (IRR)
- Measures percentage return on invested capital
- Intuitive for management communication
- Can imply unrealistic reinvestment at IRR
- Can produce multiple answers or none
- Can mislead with mutually exclusive projects
When NPV and IRR Agree
For independent projects (accepting one doesn’t prevent accepting others) with conventional cash flows (a single initial outflow followed by a series of inflows), NPV and IRR always produce the same accept/reject decision. If NPV is positive at the firm’s WACC, then the IRR exceeds that WACC — and vice versa. In these straightforward cases, either method works.
Mutually Exclusive Projects and the Crossover Rate
When a company must choose between two or more competing projects (mutually exclusive), NPV and IRR can rank them differently — especially when projects differ in scale or cash flow timing.
Amazon (AMZN) is evaluating two mutually exclusive warehouse automation options for a new fulfillment center at a 10% WACC:
| Metric | Option A: Partial Automation | Option B: Full Automation |
|---|---|---|
| Initial Investment | $500,000 | $5,000,000 |
| IRR | 25% | 18% |
| NPV (at 10% WACC) | $200,000 | $1,200,000 |
IRR favors Option A (25% vs 18%). NPV favors Option B ($1.2M vs $200K). NPV is correct — Option B creates $1 million more in shareholder value. A higher percentage return on a small investment does not compensate for the much greater absolute value created by the larger project.
The crossover rate is the discount rate at which two projects have equal NPV. Below the crossover rate, the larger project (Option B) has higher NPV; above it, the smaller project (Option A) dominates. This explains why the rankings can differ — it depends on whether the firm’s WACC is above or below the crossover rate.
Non-Conventional Cash Flows and Multiple IRRs
When a project’s cash flows change sign more than once (e.g., an initial outflow, followed by inflows, followed by another large outflow), the IRR equation can have multiple solutions — or no real solution at all. This is known as the multiple IRR problem.
Consider a copper mining project similar to those evaluated by Freeport-McMoRan (FCX): a $2 million initial investment generates $3.5 million in revenues over several years, but requires an $800,000 environmental remediation cost at mine closure. The two sign changes (negative, then positive, then negative) can produce two different IRR values, neither of which is economically meaningful.
When cash flows change sign more than once, do not rely on IRR. Use NPV for the investment decision, or use Modified IRR (MIRR) which always produces a single, unique rate by assuming interim cash flows are reinvested at the cost of capital.
The Reinvestment Rate Assumption
NPV uses the WACC as the opportunity-cost discount rate — it benchmarks value creation against what the firm could earn by investing capital elsewhere at its cost of capital. This is a reasonable and theoretically sound assumption.
IRR, by contrast, can imply that all interim cash flows compound at the IRR itself. For a project with a 40% IRR, this means assuming the firm can reinvest every intermediate cash flow at 40% — which is rarely realistic. The higher the IRR, the more this assumption distorts the true return. This is the primary theoretical criticism of IRR and the motivation for the Modified Internal Rate of Return (MIRR).
| Scenario | NPV | IRR |
|---|---|---|
| Independent projects, conventional cash flows | Both work | Both work |
| Mutually exclusive projects | Correct ranking | Can mislead |
| Non-conventional cash flows | Always works | Multiple IRRs possible |
| Capital rationing | Maximize total NPV; PI aids ranking | Not recommended |
| Communicating to management | Less intuitive ($ amount) | Intuitive (% return) |
How to Calculate Net Present Value and IRR
While financial calculators and software handle the computation, understanding the process is essential for verifying results and building intuition:
- Identify the initial investment (C0) — include all upfront costs such as equipment, installation, and initial working capital
- Estimate incremental cash flows — project the after-tax cash flows for each period. Exclude sunk costs. Include opportunity costs, changes in working capital, and any salvage value at the end
- Determine the discount rate — use the project’s WACC. If the project’s risk differs significantly from the firm’s average, adjust the discount rate accordingly
- Discount each cash flow and sum — divide each future cash flow by (1 + r)t and add them up. Subtract the initial investment to get NPV
- For IRR — find the discount rate that sets NPV to zero. This requires iteration and is best done with a calculator or software
Always test how NPV changes when you vary the discount rate by ±1-2% and cash flow estimates by ±10-20%. If a small change flips the accept/reject decision, the project is marginal and warrants additional scrutiny before committing capital.
For a deeper understanding of where the discount rate comes from, see our articles on WACC and the Capital Asset Pricing Model (CAPM).
Common Mistakes
Even experienced analysts can fall into these traps when applying NPV and IRR:
1. Using the wrong discount rate. The discount rate should reflect the project-specific cost of capital, typically the WACC. Using a rate that’s too low overstates NPV and may lead to accepting value-destroying projects. Using a rate that’s too high rejects projects that would have created value.
2. Trusting IRR with non-conventional cash flows. When cash flows change sign more than once, IRR can produce multiple values or none. Neither result is economically meaningful. Use NPV or MIRR instead.
3. Using IRR to override a higher-NPV project. When choosing between mutually exclusive projects, always select the one with the higher NPV. A higher IRR does not mean more value creation — it reflects a higher percentage return, which can mislead when projects differ in scale or timing. Use the Profitability Index only when capital is explicitly rationed across independent projects.
4. Including sunk costs. Money already spent — such as a $200,000 feasibility study conducted last year — is irrelevant to the NPV decision. Only incremental cash flows that change as a result of accepting or rejecting the project should be included.
5. Mixing nominal and real cash flows. If cash flow projections are in nominal (current-year) dollars, the discount rate must also be nominal. If cash flows are in real (inflation-adjusted) dollars, use a real discount rate. Mixing the two systematically biases the NPV calculation.
6. Ignoring working capital and salvage value. Many projects require upfront working capital (inventory, receivables) that is recovered when the project ends. Omitting the initial outflow understates the true investment cost, and omitting the recovery understates the terminal cash flow.
Limitations of NPV and IRR
Both NPV and IRR are only as reliable as their inputs. Small changes in the discount rate or cash flow assumptions can flip an investment decision from accept to reject. Always accompany NPV analysis with sensitivity testing.
1. Discount rate sensitivity. NPV is highly sensitive to the discount rate. A 1-2% change in WACC can turn a positive NPV negative — especially for long-duration projects where distant cash flows are heavily discounted. Accurately estimating the cost of capital is therefore critical.
2. Cash flow forecast uncertainty. Both methods require projecting cash flows years into the future. In practice, these estimates are uncertain and subject to optimism bias. Scenario analysis and Monte Carlo simulation can help, but uncertainty never disappears entirely.
3. IRR’s reinvestment assumption. IRR can overstate the attractiveness of high-return projects by implying that interim cash flows compound at the IRR. MIRR addresses this by assuming reinvestment at the cost of capital.
4. No account for managerial flexibility. Neither NPV nor IRR captures the value of real options — the ability to expand, delay, or abandon a project based on new information. A negative-NPV project may still be worth pursuing if it creates valuable future options (e.g., entering a new market).
5. Single discount rate assumption. Standard NPV analysis uses one discount rate for all periods. This may not be appropriate if the project’s risk profile changes over time. In such cases, different discount rates for different periods or risk-adjusted cash flows may be more accurate.
For related valuation concepts, see how IRR applies to bond valuation as yield to maturity (YTM), and how cap rates serve as a simplified yield metric in commercial real estate compared to full DCF/NPV analysis. For other capital budgeting metrics that complement NPV and IRR, see payback period and profitability index.
Frequently Asked Questions
Disclaimer
This article is for educational and informational purposes only and does not constitute investment or financial advice. The examples and calculations presented use hypothetical scenarios for illustration. NPV and IRR results depend heavily on the accuracy of cash flow estimates and discount rate assumptions. Always conduct thorough due diligence and consult a qualified financial professional before making investment decisions.