I just reviewed something that many investors still don't fully understand: the difference between NPV and IRR. These two indicators are fundamental for evaluating whether an investment is truly worthwhile, but here’s the problem: sometimes they give completely opposite signals.

Let's start with the basics. Net Present Value, or NPV, is quite straightforward. You take all the cash flows you expect to receive in the future, adjust them to today's value using a discount rate, and then subtract what you initially invested. If the result is positive, the investment generates profit. If it's negative, well, you have a problem: it means the money you'll receive in the future isn't enough to recover your initial investment.

The formula isn't complicated: NPV = (Discounted cash flows) - Initial investment. What is complicated is choosing the correct discount rate, because that's quite subjective. Different investors may use different rates and arrive at different conclusions about the same project.

Let's look at a practical example. Imagine you invest $10,000 in a project that will give you $4,000 each year for 5 years. With a discount rate of 10%, when you calculate the present value of each of those cash flows and sum them up, you get an NPV of approximately $2,162. That's positive, so the project is viable.

Now, the opposite scenario. You invest $5,000 in a certificate of deposit that will pay you $6,000 in three years. With a discount rate of 8%, the present value of those $6,000 is only $4,775. Subtract your initial investment and you get a negative NPV of about $225. That tells you the investment isn't profitable.

Now, IRR (Internal Rate of Return) is different. It’s the discount rate that makes the NPV exactly zero. In other words, it’s the percentage return you expect to get from your investment. If the IRR is higher than your reference rate, the project is profitable. It sounds simple, but here’s where it gets interesting: a project can have a positive NPV but a low IRR, or vice versa.

The reality is that both tools have significant limitations. NPV depends heavily on the discount rate you choose, which is subjective. Plus, it assumes your cash flow projections are accurate, which is rarely the case. IRR, on the other hand, can give multiple results if cash flows are irregular, and it also doesn't account for how you'll reinvest the money you receive.

What I’ve seen in practice is that the best investors don’t rely on just one metric. They calculate NPV, review IRR, but also consider other indicators like ROI, payback period, and profitability index. Additionally, they always review their assumptions: Is the discount rate realistic? Do the cash flow projections make sense? Have I sufficiently considered the risk?

When NPV and IRR give contradictory signals, it’s time to dig deeper. Review your calculations, adjust the discount rate if necessary, and think about whether you’re truly capturing all the project’s risk. Sometimes a small negative NPV can be acceptable if you believe your projections were too conservative. Other times, a positive NPV may not be enough if the IRR is very low compared to other investment options.

The conclusion is that these tools are useful, but they’re not the complete answer. Use them as a starting point, but always complement them with a deeper analysis of your personal goals, risk tolerance, and overall financial situation.