NPV vs IRR compares two ways to evaluate an investment project. Net present value (NPV) estimates how much value a project adds in currency terms, while internal rate of return (IRR) expresses its implied percentage return. For mutually exclusive projects, NPV is generally the stronger decision rule because it measures value added at the required return and handles differences in project scale more reliably.
What NPV and IRR measure
Both methods use discounted cash flow analysis. This approach recognizes that receiving USD 1,000 today is generally more valuable than receiving the same amount later because today’s money can be invested, inflation may reduce purchasing power, and future cash flows involve uncertainty.
Net present value
NPV converts all expected cash flows to their present values using a discount rate. The discount rate represents the project’s required return or opportunity cost of capital. In simplified terms, it is the return needed to compensate for time and risk.
The formula is: NPV = initial cash flow + cash flow in year 1 ÷ (1 + discount rate) + cash flow in year 2 ÷ (1 + discount rate)2, continuing for every period.
- A positive NPV means the project is estimated to add value at the selected discount rate.
- A zero NPV means it earns exactly the required return under the assumptions.
- A negative NPV means it does not meet that required return.
Internal rate of return
IRR is the discount rate that makes NPV equal to zero. If a project has an IRR of 15%, its discounted inflows equal its initial investment when evaluated at 15%.
A company may compare IRR with a required return, sometimes called a hurdle rate. An IRR above that threshold can indicate an acceptable standalone project. However, IRR does not directly show how many dollars of value the project creates.
These methods are common in capital budgeting, business planning, and project finance analysis. Cash flow forecasts may also connect to an organization’s annual operating plan.
NPV vs IRR worked example
Consider two hypothetical, mutually exclusive projects, meaning the company can undertake only one. Assume both projects end after two years, all cash flows occur at year-end, the required return is 10% per year, and there are no taxes or additional terminal values. All amounts are in USD.
| Cash flow | Project A | Project B |
|---|---|---|
| Time 0 investment | −$1,000 | −$5,000 |
| Year 1 inflow | $800 | $1,000 |
| Year 2 inflow | $400 | $5,400 |
| NPV at 10% | $57.85 | $371.90 |
| IRR | Approximately 14.83% | Approximately 14.40% |
Project A calculation
The inputs are an initial outflow of $1,000, inflows of $800 and $400, and a 10% discount rate.
NPV = −$1,000 + $800 ÷ 1.10 + $400 ÷ 1.102
NPV = −$1,000 + $727.27 + $330.58 = $57.85.
Project A’s IRR is approximately 14.83%. At that rate, the present value of its two inflows equals the $1,000 investment, subject to rounding.
Project B calculation
The inputs are an initial outflow of $5,000, inflows of $1,000 and $5,400, and the same 10% discount rate.
NPV = −$5,000 + $1,000 ÷ 1.10 + $5,400 ÷ 1.102
NPV = −$5,000 + $909.09 + $4,462.81 = $371.90.
Project B’s IRR is approximately 14.40%. Both projects exceed the 10% required return and have positive NPVs, so either could be acceptable if considered independently. If the choice is mutually exclusive, however, the methods produce conflicting rankings: IRR favors Project A, while NPV favors Project B.
Why NPV and IRR rankings can conflict
Project scale
IRR is a percentage, so it can favor a smaller project with a slightly higher rate of return. NPV measures the estimated currency value added. Project B requires five times the initial investment but creates about $371.90 of value at the required return, compared with $57.85 for Project A.
If the company has enough capital and the projects have comparable risk, NPV indicates that Project B contributes more value. That does not mean scale is irrelevant: management still needs to consider financing capacity, concentration, execution demands, and what else could be done with the additional $4,000.
Cash flow timing
Project A returns more of its investment in year 1, while most of Project B’s proceeds arrive in year 2. Earlier cash flows are discounted less heavily and can be reinvested sooner. As a result, changing the discount rate can change the projects’ relative attractiveness.
IRR also embeds a reinvestment assumption that is often misunderstood. The conventional mathematical interpretation assumes interim cash flows can be reinvested at the IRR, whereas NPV discounts cash flows at the required return. Using the required return is generally more realistic when it reflects the company’s opportunity cost of capital.
Different underlying assumptions
A calculation is only as reliable as its cash flow forecast and discount rate. Forecasts may omit working capital needs, maintenance spending, shutdown costs, or delayed customer collections. For example, analysts estimating cash conversion may examine days sales outstanding and receivables timing rather than assuming every accounting sale immediately becomes cash.
Which method should you use?
For an independent project with conventional cash flows, NPV and IRR often point to the same accept-or-reject answer. A positive NPV usually accompanies an IRR above the discount rate.
For mutually exclusive projects, finance theory generally favors the project with the higher positive NPV, provided the cash flow forecasts, project lives, discount rates, and risk adjustments are comparable. NPV directly estimates value added and avoids IRR’s percentage-scale problem.
IRR remains useful because a percentage is intuitive and easy to compare with a hurdle rate. A sound analysis normally reports both, then investigates any disagreement rather than automatically selecting the higher IRR.
- Confirm that the comparison uses incremental cash flows, not accounting profit.
- Include the initial investment, working capital, operating cash flows, and terminal effects where relevant.
- Use discount rates consistent with the timing, currency, and risk of the cash flows.
- Review project scale, cash flow timing, and capital constraints.
- Test how the result changes when major assumptions change.
Sensitivity analysis can reveal whether a decision depends on a narrow forecast. For example, you could reduce Project B’s year 2 inflow, increase the discount rate, or delay the receipt and then recalculate both measures.
Multiple IRRs and other limitations
A conventional project has one initial outflow followed by inflows. When cash flows change signs more than once, a project can produce multiple IRRs or no economically useful IRR.
Consider the hypothetical cash flows −$100 at time 0, +$230 in year 1, and −$132 in year 2. The final outflow could represent a cleanup or closure obligation. These cash flows produce two mathematical IRRs: 10% and 20%. A rule that says to accept a project whenever IRR exceeds the hurdle rate becomes ambiguous.
NPV does not have the same multiple-rate problem because you select an external discount rate and calculate one value at that rate. Analysts may also use modified internal rate of return (MIRR), which applies explicit financing and reinvestment rates, but MIRR still depends on the assumptions selected.
Neither measure captures every strategic factor. A project with an attractive calculated return may still expose a company to liquidity pressure, regulatory risk, operational dependence, or forecasts that are too uncertain to support the investment.
How to calculate NPV and IRR correctly in Excel
Suppose cells A2, B2, and C2 contain the time 0, year 1, and year 2 cash flows. For Project A, those cells would contain −1000, 800, and 400.
Use =NPV(10%,B2:C2)+A2 to calculate NPV. Excel’s NPV function discounts every value inside its range as a future end-of-period cash flow. The time-zero investment must therefore be added separately rather than included inside the NPV range.
Use =IRR(A2:C2) for IRR. Unlike Excel’s NPV function, IRR requires the complete cash flow series, including time zero. Entering =NPV(10%,A2:C2) would incorrectly discount the initial investment by one period.
These formulas assume equally spaced periods. For cash flows occurring on irregular dates, Excel’s XNPV and XIRR functions use actual dates. Keep the cash flow signs consistent: investments and other payments are negative, while receipts are positive.
A useful practice exercise is to enter both projects, reproduce the table’s results, and then test discount rates of 8%, 10%, and 15%. This shows how later cash flows become less valuable as the discount rate rises and helps build spreadsheet skills relevant to financial analysis and some quantitative finance interview preparation.
Frequently asked questions about NPV vs IRR
Is NPV better than IRR?
NPV is generally preferred when mutually exclusive projects have conflicting rankings because it measures estimated value added at the required return. IRR remains a useful supporting measure for expressing return as a percentage.
Can a project have positive NPV but a low IRR?
Yes. A large project can have a relatively modest percentage return while adding substantial currency value. Whether its IRR is acceptable depends on the appropriate required return.
Why is the initial investment excluded from Excel’s NPV range?
Excel’s NPV function treats values in the range as occurring at the end of future periods. Because the initial investment occurs at time zero, add it separately without discounting it.
What discount rate should be used for NPV?
The rate should reflect the cash flows’ timing and risk and the organization’s opportunity cost of capital. Selecting it requires judgment, and projects with materially different risks may require different rates.
Can IRR be negative?
Yes. A negative IRR can occur when a project’s undiscounted inflows do not recover its initial investment under a conventional cash flow pattern. Some unusual cash flow patterns may instead produce multiple IRRs or no meaningful solution.