NPV vs IRR: 4 checks investors use to validate deals

Net Present Value measures the absolute amount of wealth a project adds in today's currency, while Internal Rate of Return measures the percentage growth rate that makes that added wealth exactly zero. As a rule of thumb, NPV should govern the final decision, especially when choosing between competing projects, while IRR remains useful as a quick, intuitive rate for comparing opportunities or explaining a deal to stakeholders.

TL;DR:

• NPV provides the actual dollar value added by a project, making it more reliable for ranking mutually exclusive options than IRR.
• IRR assumes reinvestment at its own rate, which is often unrealistic; MIRR adjusts this assumption for more accurate project comparison.
• Projects with high IRRs can still destroy value if their scale or cash flow timing does not lead to a positive NPV.
• Using the NPV profile helps identify the crossover point where one project's attractiveness shifts relative to the discount rate.
• For independent projects, accept if NPV is positive; for mutually exclusive projects, prioritize NPV and verify IRR-based signals with MIRR and sensitivity analysis.

Definitions and formulas: how NPV and IRR are actually calculated

NPV discounts every future cash flow back to today's terms using a chosen discount rate, typically a firm's cost of capital, then subtracts the initial outlay. A positive NPV means the project is expected to add value above that cost of capital; a negative NPV means it destroys value. IRR is defined differently: it is the discount rate at which NPV equals zero, so it tells you the break-even rate of return rather than a currency amount.

A short example illustrates both. Suppose a property investment requires an initial outlay of £100,000 and is expected to return £30,000 a year for four years.

1. Discount each of the four £30,000 inflows back to today's value using a chosen discount rate, then sum them.
2. Subtract the £100,000 outlay from that total to get NPV.
3. Adjust the discount rate up or down until the NPV calculated in step two equals zero; that rate is the IRR.

When cash flows do not arrive at neat annual intervals, which is common in property transactions with staggered completion or rental payments, XNPV and XIRR handle the exact dates rather than assuming equal periods, giving a more accurate answer than the standard IRR function.

Why NPV and IRR sometimes disagree

The two metrics rest on different assumptions about what happens to the cash a project generates. IRR implicitly assumes that every pound returned is reinvested at the project's own rate of return, an assumption that ACCA's technical guidance flags as frequently unrealistic, particularly for high-IRR projects. NPV assumes reinvestment at the firm's cost of capital, a more conservative and usually more defensible assumption.

Beyond reinvestment, two further factors cause the rankings to diverge:

• Scale effects: a small project can show a spectacular IRR while adding relatively little absolute value, whereas a larger project with a modest IRR can add far more currency-denominated wealth.
• Time disparity: projects whose cash flows arrive early versus late respond differently as the discount rate changes, which can flip the preferred choice depending on the rate assumed.

The tool for resolving this is the NPV profile, a plot of NPV against a range of discount rates for each project. Where the two lines cross is the crossover or indifference point. Academic analysis of mutually exclusive projects shows that the preferred project depends on where the anticipated reinvestment rate sits relative to that crossover point, not simply on which project has the higher IRR.

Both metrics remain standard practice despite their conflicts. A survey of 392 CFOs found roughly 75% use IRR and roughly 75% use NPV, confirming that practitioners lean on both measures rather than treating one as obsolete.

Which measure to trust, and a short decision checklist

For independent projects, where accepting one does not preclude accepting another, the decision rule is simple: accept any project with a positive NPV, and treat a positive result plus an IRR above the cost of capital as confirming signals rather than competing verdicts. Conflicts only matter when projects are mutually exclusive, meaning you can choose only one.

In that situation, Corporate Finance Institute's comparison notes that NPV is the theoretically superior ranking metric because it measures the actual amount of wealth created, while IRR is a percentage that can mislead when projects differ in scale or timing.

1. Calculate NPV at the firm's true cost of capital and treat it as the primary decision figure.
2. Plot the NPV profile for each mutually exclusive option and identify the crossover point.
3. Calculate MIRR where IRR's reinvestment assumption looks unrealistic, particularly for projects with very high headline IRRs.
4. Run a sensitivity analysis across a plausible range of discount rates before committing capital.

Pro Tip: Treat a headline IRR well above typical cost of capital levels with scepticism until you have checked it against MIRR, since such figures often reflect an optimistic reinvestment assumption rather than a genuinely superior project.

How to calculate NPV and IRR in a spreadsheet

Most spreadsheet packages, including Excel, provide dedicated functions for each metric, but the syntax hides a few traps worth knowing before you trust the output.

• =NPV(rate, cashflow_range) discounts the cash flows supplied, but the initial outlay is usually excluded from the range and subtracted separately, since the function assumes the first value arrives one period ahead.
• =IRR(cashflow_range, [guess]) finds the discount rate that zeroes NPV; an optional starting guess helps the function converge when cash flows are unconventional.
• =XNPV(rate, values, dates) and =XIRR(values, dates, [guess]) use actual calendar dates, which Microsoft's documentation confirms gives more accurate results than the periodic functions whenever payments are irregular.
• =MIRR(cashflow_range, finance_rate, reinvestment_rate) replaces IRR's reinvestment assumption with rates you specify, avoiding the multiple-answer problem that plain IRR can produce.

Before relying on any result, recompute NPV using the reported IRR as the discount rate; it should land at or near zero. Test sensitivity by nudging the discount rate up and down a percentage point or two, and check the sign pattern of the cash flows for more than one change of direction, which signals a possible multiple-IRR situation.

Common pitfalls that lead to the wrong decision

Non-conventional cash flows, where the sign changes more than once (for example an outlay, followed by inflows, followed by a further cash outlay), can produce more than one mathematically valid IRR. ICAEW's guidance on this recommends MIRR precisely because it avoids that ambiguity and models a single, realistic reinvestment rate.

• Check for more than one sign change in the cash-flow sequence before trusting a single IRR figure.
• Never assume a high IRR project is automatically better without checking the NPV and the project's scale.
• Run MIRR or a sensitivity table rather than assuming cash is reinvested at the IRR itself.
• Keep the initial outlay and later cash flows in consistent sign convention throughout the model.

Pro Tip: A model that produces two believable IRR values is not a computational quirk to explain away; it is a signal to switch to MIRR or NPV as the primary decision metric.

Reading NPV and IRR through a buyer-side diligence lens

When assessing a cross-border property purchase, NITARYA treats a headline IRR the way any careful analyst should: as a starting point, not a verdict — using tools like a Rental Property Cash Flow Calculator to model rental cash flows accurately. Discounting projected rental income and resale value at a realistic cost of capital, rather than the developer's assumed growth rate, often narrows or reverses an apparently attractive return. Across more than 380 property decisions reviewed, roughly one in three uncovered issues, such as unclear ownership rights or undisclosed obligations, material enough to change the deal itself. Where a projection depends heavily on optimistic reinvestment or resale assumptions, independent property due diligence is worth commissioning before capital moves, particularly for markets like India where cash-flow timing is rarely as tidy as a spreadsheet suggests.

— Neerraj

This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.

Sources

• Modified internal rate of return | P4 Advanced Financial Management | ACCA Qualification | Students | ACCA Global
• NPV vs IRR - Overview, Similarities and Differences | Corporate Finance Institute
• Resolving Conflicts in Capital Budgeting for Mutually Exclusive Projects with Time Disparity Differences
• XIRR function - Microsoft Support
• Modified internal rate of return | ICAEW

FAQ

Which is better, IRR or NPV?

NPV is generally the more reliable measure because it shows the actual amount of value a project adds, while IRR only shows a percentage rate that can mislead when projects differ in size or timing. Corporate Finance Institute notes NPV is the theoretically superior metric for ranking mutually exclusive projects, though both are widely used together.

What happens to NPV if IRR increases?

A higher IRR on its own does not guarantee a higher NPV, since NPV also depends on the scale of the cash flows and the discount rate actually used. The two only align reliably when comparing a single project against its own cost of capital, not when ranking different-sized projects against each other.

Can you calculate IRR from NPV?

Yes: IRR is found by adjusting the discount rate used in the NPV formula until NPV equals zero, which is exactly what spreadsheet IRR functions automate. You can check any reported IRR by plugging it back into the NPV formula and confirming the result lands at zero.

What does NPV at 10% mean?

A positive result means the project is expected to generate more value than the firm's cost of capital would otherwise require.