Net Present Value vs. IRR: Which Should You Use to Evaluate an Investment?

What Is Net Present Value?

Net present value calculates the value of future cash flows in today's dollars, subtracting the initial investment. It accounts for the time value of money — the principle that a dollar today is worth more than a dollar in the future because money can earn returns over time. NPV discounts future cash flows back to the present using a discount rate that represents the cost of capital or the required rate of return.

The formula for NPV is:

Where r is the discount rate and t is the time period. A positive NPV indicates the investment creates value after covering the cost of capital. A negative NPV indicates the investment destroys value. NPV is expressed in absolute dollar terms, making it easy to understand the actual value created or destroyed.

What Is Internal Rate of Return?

Internal rate of return is the discount rate that makes the NPV of an investment equal to zero. It represents the annualized return the investment generates, expressed as a percentage. IRR is the rate at which the present value of future cash flows exactly equals the initial investment. It is a relative measure of return that allows comparison across investments of different sizes.

IRR is calculated iteratively — there is no direct formula. Financial calculators and software solve for the rate that drives NPV to zero. An investment is generally considered acceptable if its IRR exceeds the required rate of return or cost of capital. The higher the IRR, the more attractive the investment, all else equal.

Side-by-Side Example

Consider a project requiring a $100,000 investment with the following expected cash flows: Year 1: $25,000, Year 2: $30,000, Year 3: $35,000, Year 4: $30,000, Year 5: $25,000. The company's required rate of return (discount rate) is 10%.

Calculating NPV: Year 1 present value is $25,000 divided by 1.10, or $22,727. Year 2 is $30,000 divided by 1.10 squared, or $24,793. Year 3 is $35,000 divided by 1.10 cubed, or $26,296. Year 4 is $30,000 divided by 1.10 to the fourth, or $20,490. Year 5 is $25,000 divided by 1.10 to the fifth, or $15,523. Total present value of cash flows is $109,830. NPV is $109,830 minus $100,000, or $9,830. The project creates $9,830 in value.

Calculating IRR: The rate that makes NPV equal to zero for this cash flow stream is approximately 13.4%. Since 13.4% exceeds the 10% required rate of return, the project is acceptable on an IRR basis as well. Both metrics agree in this case, but they do not always agree.

When NPV and IRR Disagree

NPV and IRR can give conflicting recommendations in certain situations. The most common scenario is when comparing mutually exclusive projects of different sizes. A smaller project might have a higher IRR but lower NPV, while a larger project has a lower IRR but higher NPV. IRR favors smaller projects with high percentage returns, while NPV favors projects that create the most absolute value.

Another conflict occurs with non-conventional cash flows — projects where cash flows change sign more than once (for example, an investment that requires additional capital in later years). IRR can produce multiple values or be meaningless in these cases, while NPV provides a single, unambiguous answer. The reinvestment rate assumption also differs: IRR assumes cash flows are reinvested at the IRR itself, which may be unrealistic, while NPV assumes reinvestment at the discount rate, which is typically more conservative.

Which Metric Should You Use?

NPV is generally considered the superior metric for investment decisions because it directly measures value creation in dollar terms. It aligns with the goal of maximizing shareholder value. When NPV and IRR conflict, NPV should typically guide the decision. However, IRR remains popular because percentage returns are intuitive and easy to communicate to non-financial stakeholders.

Use NPV when you need to know the absolute value an investment will create, when comparing projects of different sizes, or when cash flows are non-conventional. Use IRR when you need a percentage return for communication purposes, when comparing projects of similar scale, or when the discount rate is uncertain and you want to understand the break-even return rate.

Limitations of Both Metrics

Both NPV and IRR have limitations. NPV requires choosing a discount rate, which can be subjective. The wrong discount rate leads to the wrong decision. NPV also assumes cash flows are reinvested at the discount rate, which may not reflect actual reinvestment opportunities. IRR assumes reinvestment at the IRR itself, which is often unrealistic, especially for very high IRRs.

Neither metric accounts for project risk beyond the discount rate. Two projects with the same NPV might have very different risk profiles. Neither metric considers strategic value, option value, or qualitative factors that might affect the investment decision. Both metrics are only as good as the cash flow estimates, which are inherently uncertain.

Modified IRR (MIRR) addresses the reinvestment rate assumption by assuming reinvestment at a specified rate rather than the IRR. Profitability index (PI), calculated as NPV divided by initial investment, addresses the scale issue by showing value created per dollar invested. These modified metrics can provide additional insight but are less widely used than NPV and IRR.

Common Mistakes to Avoid

One mistake is using IRR exclusively and ignoring NPV. IRR can be misleading for projects of different sizes or with unusual cash flow patterns. Always calculate both metrics and understand when they agree and when they conflict. If they conflict, investigate why and consider which metric better reflects your decision criteria.

Another error is using an arbitrary discount rate for NPV. The discount rate should reflect the cost of capital or the opportunity cost of the funds. Using a rate that is too low overstates NPV and may lead to accepting poor investments. Using a rate that is too high understates NPV and may lead to rejecting good investments. Base your discount rate on your actual cost of capital or required return.

Finally, do not forget sensitivity analysis. Both NPV and IRR are based on estimated cash flows that are uncertain. Test how your results change with different cash flow assumptions, different timing, and different discount rates. A project that looks good under base assumptions may look marginal under more conservative assumptions. Sensitivity analysis reveals the robustness of your conclusion.

Related Tools on ProfessionCalculators.com

In addition to the NPV Calculator and IRR Calculator, these tools can help with investment analysis:

• ROI Calculator — Calculate return on investment as a percentage

Frequently Asked Questions

What is a good NPV?

Any positive NPV is theoretically good because it indicates value creation. However, the magnitude matters. A $100 NPV on a $100,000 investment is negligible and may not justify the effort and risk. A $50,000 NPV on a $100,000 investment is substantial. The practical threshold depends on your organization's capital constraints and the availability of alternative investments. Compare NPV to the initial investment to assess whether the value created is meaningful relative to the capital required.

What is a good IRR?

A good IRR is one that exceeds your required rate of return or cost of capital. If your cost of capital is 10%, an IRR of 15% is good. If your cost of capital is 20%, an IRR of 15% is unacceptable. IRR should always be compared to a hurdle rate rather than judged in isolation. Industry benchmarks exist but are less useful than your own cost of capital, which reflects your actual opportunity cost.

Why do NPV and IRR sometimes give different answers?

NPV and IRR can disagree when comparing mutually exclusive projects of different sizes. IRR is a percentage that favors smaller projects with high percentage returns, while NPV is an absolute dollar amount that favors larger projects that create more total value even if the percentage return is lower. They can also disagree with non-conventional cash flows where IRR may have multiple solutions or be mathematically invalid. In these cases, NPV is the more reliable metric.

How do I choose the discount rate for NPV?

The discount rate should reflect your cost of capital or the required rate of return for the investment. For businesses, this is often the weighted average cost of capital (WACC), which combines the cost of debt and equity. For personal investments, use an appropriate benchmark return such as the return on alternative investments of similar risk. The discount rate should account for the risk of the cash flows — riskier projects should use higher discount rates to reflect the higher required return.

Can IRR be negative?

Yes, IRR can be negative. A negative IRR means the investment loses money — the cash flows do not even recover the initial investment when discounted at any positive rate. A negative IRR clearly indicates a bad investment. However, IRR cannot be calculated if all cash flows are negative or if the cash flow pattern never crosses zero. In these cases, NPV provides a clear answer while IRR is undefined or meaningless.

Conclusion

NPV and IRR measure different things. NPV measures absolute value creation in dollar terms. IRR measures percentage return. NPV is generally the more reliable decision metric because it aligns directly with value maximization. IRR remains useful for communicating return potential and comparing projects of similar scale. Calculate both, understand when they agree and when they diverge, and let NPV guide the final call.

Our NPV Calculator and IRR Calculator give you a complete picture of investment returns. For solar, real estate, or any long-horizon capital project, see how these metrics apply in our guide on how to calculate solar panel ROI.