Investment Decisions: How NPV and IRR Help You Choose Profitable Projects

2026-01-06 18:26:45

When it comes to investing money, every investor asks the same question: Will this opportunity truly generate profits for me? To answer accurately, there are two fundamental financial tools: the NPV (Net Present Value) and the IRR (Internal Rate of Return).

Both methods are widely used in investment analysis, but each measures profitability from different perspectives. The real challenge arises when these two indicators give contradictory results: a project may show an attractive NPV but a modest IRR, or vice versa. This poses an uncomfortable question for any decision-maker: Which indicator should I follow?

In this guide, we will delve into how both metrics work, their limitations, and how to use them together to make more solid investment decisions.

Understanding NPV: Measuring Value Created

The Net Present Value (NPV) answers a simple question: if I invest a certain amount of money today, how much extra money will I have at the end in terms of present value?

Essentially, NPV calculates the present value of all future cash flows generated by an investment, subtracting the initial outlay. These flows include sales revenue, operating expenses, taxes, and any other relevant cash movements.

How NPV is Calculated

The process involves three key steps:

Project cash flows: Estimate how much money will come in and go out in each period (generally years).
Select a discount rate: This is the interest rate you will use to bring all those future flows to the present. It reflects the opportunity cost, i.e., what you could earn if you invested that money elsewhere.
Apply the formula:

NPV = (Cash Flow Year 1 / (1 + Discount Rate) ^ 1) + (Cash Flow Year 2 / (1 + Discount Rate) ^ 2) + … + (Cash Flow Year N / (1 + Discount Rate) ^ N) - Initial Cost

Simple interpretation: If the NPV is positive, the investment adds value. If negative, it destroys value.

Practical Example 1: A Profitable Project

Imagine your company evaluates a project requiring an initial investment of $10,000. It is expected to generate $4,000 in cash flow at the end of each year for 5 years. The discount rate used is 10%.

Calculating the present value of each year:

Year 1: 4,000 / (1.10)^1 = 3,636.36
Year 2: 4,000 / (1.10)^2 = 3,305.79
Year 3: 4,000 / (1.10)^3 = 3,005.26
Year 4: 4,000 / (1.10)^4 = 2,732.06
Year 5: 4,000 / (1.10)^5 = 2,483.02

NPV = (3,636.36 + 3,305.79 + 3,005.26 + 2,732.06 + 2,483.02) - 10,000 = 2,162.49 dollars

A positive NPV of $2,162.49 indicates that this project is a good investment.

Practical Example 2: A Less Attractive Investment

Suppose you invest $5,000 in a certificate of deposit that will pay you $6,000 in three years, with an annual interest rate of 8%.

Present value of the future payment: 6,000 / (1.08)^3 = 4,774.84 dollars

NPV = 4,774.84 - 5,000 = -225.16 dollars

A negative NPV indicates you will not fully recover your initial investment in present value terms. It’s not advisable.

Choosing the Correct Discount Rate

The accuracy of NPV heavily depends on the discount rate you choose. Here are several approaches to determine it:

Opportunity Cost: What return would you get if you invested that money in an alternative with similar risk? If the project is riskier, increase the rate.

Risk-Free Rate: Start with what you would earn in Treasury bonds (practically risk-free). Then add a risk premium based on the specific investment.

Comparative Analysis: Research what discount rate your industry uses to evaluate similar projects.

Investor Experience: Your sector knowledge and intuition also matter.

Limitations of NPV You Should Know

Although NPV is a powerful tool, it has weaknesses:

Limitation	Description
Subjectivity of discount rate	Different investors may use different rates, resulting in different outcomes for the same project
Ignores uncertainty	Assumes your cash flow projections are accurate, which rarely happens in reality
Does not consider future changes	Assumes fixed decisions from the start; does not account for operational flexibility
Does not compare projects of different sizes	A large project with an NPV of $5,000 is not necessarily better than a small one with an NPV of $3,000
Ignores inflation	Does not automatically adjust for the impact of inflation on future flows

Despite these limitations, NPV remains widely used because it is relatively easy to understand and apply. It provides a clear monetary metric and allows for comparison of options.

IRR: Measuring Return Percentage

While NPV tells you how much extra money you will earn, the Internal Rate of Return (IRR) tells you at what rate your investment will grow, expressed as an annual percentage.

Technically, IRR is the discount rate that makes the NPV exactly zero. In other words, it’s the rate at which future cash flows exactly equal your initial investment.

Practical Interpretation of IRR

If IRR is higher than your reference rate (for example, the interest rate of Treasury bonds), the project is profitable.
Comparing IRRs of different projects allows you to identify which offers higher relative returns, regardless of the size of the investment.

For example, a small project with an IRR of 25% may be more attractive than a large one with an IRR of 12%, even if the large project generates more absolute money.

Weak Points of IRR

IRR also has significant limitations:

Limitation	Description
Multiple IRRs Possible	For investments with unconventional cash flows, there may be several IRRs, complicating interpretation
Non-conventional Cash Flows	If you have significant expenses after initial years, IRR can be misleading
Reinvestment Problem	Assumes positive flows are reinvested at the IRR rate, which rarely happens
Sensitivity to Discount Rate	Changes in market rates affect the comparability of projects evaluated at different times
Ignores the Time Value of Money	Although it incorporates discounting, it does not reflect how inflation erodes future purchasing power

Despite its limitations, IRR is valuable for projects with stable, predictable cash flows, especially when you need to compare opportunities of different sizes.

What Happens When NPV and IRR Give Contradictory Results?

This is a real situation many investors face. It may happen that a project has a high NPV but a moderate IRR, or vice versa.

Why This Contradiction Occurs

The divergence mainly arises from how each indicator weights cash flows over time. If flows are very volatile and you apply a high discount rate for NPV, it can turn negative. Meanwhile, IRR might still be positive because it measures the project’s inherent performance, not its monetary value under a specific discount.

How to Resolve It

When facing this situation:

Review your assumptions: Verify that cash flow projections are realistic and that the discount rate truly reflects the project’s risk.
Adjust the discount rate: If you think it was too conservative, recalculate NPV with a more appropriate rate.
Analyze the risk profile: How confident are you in the projected flows? A low NPV with high IRR could indicate a risky project.
Consider other indicators: Use ROI (Return on Investment), payback period (time to recover), or profitability index to get a more complete view.

NPV vs IRR: Key Differences

Aspect	NPV	IRR
What it Measures	Absolute monetary value generated	Relative profitability percentage
Expression	Dollars (or other currency)	Percentage per year
Ease of Comparison	Difficult to compare projects of different sizes	Easy to compare by relative profitability
Dependence on Assumptions	Depends on the chosen discount rate	Less sensitive to external assumptions
Better For	Evaluating individual projects in absolute terms	Comparing profitability among options

How to Choose Among Multiple Projects Using Both Indicators

When you have several investment options:

Calculate NPV and IRR for each project.
Set minimum criteria: Require both indicators to exceed acceptable thresholds (for example, NPV > 0 and IRR > 10%).
Prioritize according to your goals: If you want to maximize absolute value, focus on NPV. If you seek capital efficiency, choose the one with the higher IRR.
Complement with qualitative analysis: Consider risk, strategic alignment, operational flexibility, and personal objectives (available budget, investment horizon, risk tolerance).
Diversify: Do not put all in one project, even if it shows the best numbers.

Additional Indicators for a More Robust Analysis

Besides NPV and IRR, consider:

ROI (Return on Investment): Simple profitability as a percentage of initial investment.
Payback Period: How long it takes to recover your initial investment.
Profitability Index (PI): Ratio of present value of future flows to initial investment.
Weighted Average Cost of Capital (WACC): Useful for determining a more precise discount rate.

Conclusions: Use NPV and IRR Together, Not Separately

The NPV shows whether a project will add real value to your wealth. The IRR shows how efficient that project is at generating returns. Neither alone tells the whole story.

The most solid investment decision emerges when you use both indicators together, recognize their limitations, and complement them with qualitative analysis. Remember that both metrics are based on future projections, which inherently involve some uncertainty.

As an investor, your responsibility is to carefully evaluate each opportunity considering your personal financial situation, long-term goals, risk tolerance, and your capacity to diversify properly. Mathematics is important, but so is judgment.

EL-7,79%

View Original

This page may contain third-party content, which is provided for information purposes only (not representations/warranties) and should not be considered as an endorsement of its views by Gate, nor as financial or professional advice. See Disclaimer for details.