I just read a pretty comprehensive analysis about NPV and IRR, and honestly, it's something that many investors still don't fully understand. The thing is, these two indicators can give you completely opposite results when evaluating a project, and that's what causes confusion.

Let's start with the basics. NPV is the present value of all the cash flows you expect to receive in the future, minus what you invest today. If the NPV is positive, it means the project generates more money than it costs. If it's negative, well, you're losing. It seems simple, but everything depends on the discount rate you choose, and that's where things get subjective.

IRR, on the other hand, is the rate of return that equates your initial investment with the future cash flows. It’s expressed as a percentage and is useful for comparing projects. But here’s the interesting part: there can be cases where you get a negative IRR, especially if the cash flows are unconventional or if there are significant changes in the pattern of returns. When that happens, you already know the project probably isn’t worth it.

What I find key is that these two indicators don’t always match. A project can have a high NPV but a low IRR, or vice versa. That’s because they measure different things: NPV gives you an absolute value in money, while IRR gives you a relative return. It’s not that one is wrong and the other is right; they’re just measuring from different perspectives.

The limitations are real. NPV depends heavily on the discount rate you assume, which is quite subjective. Also, it assumes your cash flow projections are accurate, which is rarely the case in reality. IRR has its own problems: it may not have a unique solution, especially with irregular cash flows, and it tends to overestimate returns because it assumes you will reinvest the positive flows at the same rate of return.

When the numbers give you contradictory results, what’s recommended is to review your assumptions. Check the discount rate, analyze whether the projected cash flows make sense, and consider the overall context of the project. Sometimes adjusting the discount rate to better reflect the actual risk helps reconcile the differences.

The practical conclusion is that you shouldn’t rely on just one of these indicators. Combine NPV with IRR, and if you have time, add others like ROI or payback period. Each metric gives you a piece of the puzzle. Serious investors consider multiple factors: their personal objectives, the risk they’re willing to take, and how the project fits into their overall portfolio. The final decision isn’t just mathematical; it also requires judgment and experience.