I've been thinking a lot about this lately: when you're evaluating an investment project, why do sometimes the NPV and IRR give completely opposite signals? It's a question many investors ask themselves, and the truth is that understanding the difference between these two metrics is crucial to avoid making disastrous decisions.

Let's start with the basics. Net Present Value (NPV) is essentially how much real money you will earn or lose with an investment, expressed in today's dollars. Imagine investing $10,000 in a project that will generate cash flows over the next few years. NPV takes all those future flows, discounts them to their present value using a rate that reflects your opportunity cost, and then subtracts what you initially invested. If the result is positive, the project theoretically makes you money. If negative, you lose.

The IRR, on the other hand, is different. It is the rate of return that exactly equates what you invest with what you will receive in the future. In other words, it’s the percentage of annual return you expect to achieve. You compare it with a benchmark rate (such as the yield on Treasury bonds or your cost of capital), and if the IRR is higher, the project looks attractive.

Now, here’s where it gets interesting and where many get lost. It’s possible to get a negative NPV and a positive IRR simultaneously. How is that possible? It happens because these two metrics measure different things and respond differently to changes in the discount rate. If you use a very high discount rate to calculate NPV, the future cash flows are compressed so much that the present value is insufficient to recover your initial investment, resulting in a negative NPV. But the IRR, which is the project’s intrinsic rate, can still be positive because the project does generate a return, just at a rate that doesn’t justify your opportunity cost.

Let me give you a practical example. Suppose you invest $5,000 in a certificate of deposit that will pay you $6,000 in three years. If you use an 8% discount rate, the present value of those $6,000 is approximately $4,775. Subtract your initial investment of $5,000 and you get a negative NPV of about $225. However, the IRR of this certificate remains positive because technically you’re earning money, just that the return doesn’t compensate for your opportunity cost.

This contradiction is precisely why you shouldn’t use these metrics in isolation. NPV tells you if the project generates absolute value in monetary terms. IRR tells you the relative percentage return. When you see a negative NPV and a positive IRR, it’s a sign that the project generates a return, but insufficient compared to your alternative investments.

Another important limitation: NPV is very sensitive to the discount rate you choose, which is largely subjective. IRR, while avoiding this problem, has its own pitfalls. There isn’t always a single IRR (there can be multiple mathematical solutions), and it assumes you will reinvest the positive flows at the same rate, which rarely happens in reality.

So, what do you do when you encounter these contradictions? The smart move is to deepen your analysis. Review your assumptions about the discount rate. Does it truly reflect the project’s risk? Analyze the cash flow structure. Are your projections realistic? Consider other indicators like ROI, payback period, or profitability index.

The reality is that both NPV and IRR are valuable tools, but neither is perfect on its own. NPV is more intuitive because it gives you a number in real money. IRR is easier to compare across projects of different sizes. But both rely on future projections that inevitably contain uncertainty.

My recommendation: use them together. If both give you a green signal, go ahead. If there’s a conflict, especially when you see a negative NPV and a positive IRR, take time to understand why. Adjust your discount rates, review your projected flows, consider the specific context of your investment. And above all, don’t forget factors that these metrics don’t capture: your risk tolerance, your personal objectives, your portfolio diversification, and your overall financial situation. In the end, numbers are only part of the equation.