Few business decisions are as important — and as poorly grounded — as the decision to invest. Buying a new machine, opening a store, developing a product, migrating to the cloud: all of them involve spending money today in the hope of receiving more tomorrow. The hard question is always the same: is it worth it?
The most common answer is to look at the simple return — how much comes in divided by what went out. It is quick, but it has a serious flaw: it ignores when the money comes in. And timing makes all the difference. This is where two tools that any manager should know how to read, even without being an economist, come in: NPV (Net Present Value) and IRR (Internal Rate of Return).
This article explains what they are, how to interpret them and where each one misleads, with a simple numerical example that shows why relying on gut feeling alone — or on just one of them — can lead to the wrong decision.
Why 100 euros today is worth more than 100 euros a year from now
Let us start with the idea that underpins everything else: the time value of money. One hundred euros in hand today is worth more than the promise of one hundred euros a year from now — and it is not because of inflation, although that counts too. It is because one hundred euros today can be invested and earn a return, can pay off a debt that is accruing interest, or are simply guaranteed, whereas the future promise carries risk and waiting.
Therefore, comparing money that comes in at different moments requires bringing it all to the same point in time — usually, to today. That process is called discounting the cash flows. A euro received three years from now is discounted to find out what it is worth today. Ignoring this step means comparing quantities that are not comparable.
The discount rate: the price of waiting and of risk
To discount future cash flows you need a discount rate. It represents the minimum return you demand for postponing consumption and taking on the risk of the investment. It can be the company's cost of capital, the return on a safe alternative, or a rate that incorporates the specific risk of the project — the more uncertain the return, the higher it should be.
Choosing the rate is not a technical detail: it is the variable that most influences the result. A low rate favours projects with distant returns; a high rate penalises them. So, more than hitting a magic number, what matters is understanding how much the decision changes when the rate changes — we will come back to that in the sensitivity analysis.
NPV: the value an investment creates (or destroys)
The Net Present Value answers a direct question: adding up all the future cash flows already discounted to today and subtracting the initial investment, how much value is left? As a simple formula:
NPV = sum of discounted future cash flows − initial investment
The decision rule is equally direct:
- Positive NPV: the project creates value — it earns more than the required rate. In principle, go ahead.
- Negative NPV: the project destroys value — it does not even cover the cost of capital. In principle, decline.
- NPV equal to zero: it earns exactly the required rate, no more, no less.
The great advantage of NPV is that it is expressed in euros. It tells you, in today's money, how much the project adds to the company's value. It is the measure that finance textbooks recommend when you have to choose between projects.
IRR: the return the project offers
The Internal Rate of Return approaches the same problem from another angle. Instead of fixing a rate and calculating the value, it asks the inverse question: what discount rate makes the NPV exactly zero? That rate is the IRR — a kind of implicit annual return of the project.
The decision rule compares the IRR with the required rate: if the IRR is higher than the discount rate, the project earns above the minimum and is worth it; if it is lower, it is not. The IRR is popular because it is expressed as a percentage, a language everyone understands and that allows quick comparison with other investments. "This project earns 16% a year" is a sentence that is immediately understood.
The problem is that this simplicity hides traps — and the next section shows the most important one.
When NPV and IRR disagree
In most cases, NPV and IRR point in the same direction: a project with positive NPV has an IRR above the required rate. But when you have to choose between projects, the two measures can rank them differently — and that is where many people decide badly.
This happens because the IRR is a percentage and ignores the scale and the timing of the cash flows. A small project that pays quickly can have a very high IRR and still create less total value than a project that pays later but in greater amount. A high percentage is not the same as a lot of money.
The practical rule when the two disagree and the projects are mutually exclusive: follow the NPV. It is the NPV that measures the value created in euros, which is, in the end, what matters to shareholders. The IRR is a good complement, not the final arbiter.
Payback: useful, but treacherous
There is a third indicator that always shows up in these conversations: the payback period, that is, how long the project takes to return the initial investment. It is intuitive and useful as a measure of risk and liquidity — the faster you recover, the less exposed you are.
But it has two serious flaws. First, in its simple version, it ignores the time value of money (there is a discounted version that corrects this). Second, and more serious, it ignores everything that happens after recovering the investment. A project that recovers slowly but keeps generating money for many years can be much better than one that recovers quickly and then dries up. Use payback to assess risk, never as the sole decision criterion.
Sensitivity analysis: what if the rate changes?
Because the result depends so much on the discount rate and on the cash-flow forecasts, a robust decision does not stop at a single scenario. It is worth recalculating the NPV with different rates and with more pessimistic cash flows, and asking: does the decision hold?
If the project still has a positive NPV even with a more demanding rate and lower revenues, the decision is solid. If a small rise in the rate is enough to turn the NPV negative, the project is fragile — and that fragility has to be known before signing, not after. Sensitivity analysis does not provide certainties, but it shows where the limits are.
Common mistakes to avoid
- Comparing returns without discounting: adding up cash flows from different years as if they were worth the same is the most frequent mistake and the most misleading.
- Choosing by the highest IRR: between mutually exclusive projects, the higher percentage does not always create more value.
- Forgetting the opportunity cost: money put into one project is no longer available for another; the discount rate should reflect that.
- Optimism in the forecasts: inflated future cash flows make any project look good on paper. Test conservative scenarios.
- Ignoring residual values and end-of-life costs: a piece of equipment may have resale value — or dismantling costs — that weigh on the calculation.
Mini-case: two projects, one budget
An industrial company has 50,000 € to invest and two projects on the table, both with the same initial cost. The discount rate it uses is 10%. The forecast cash flows over three years differ in shape:
- Project A (pays early): 35,000 €, 20,000 € and 8,000 €.
- Project B (pays late): 6,000 €, 14,000 € and 52,000 €.
Discounting the cash flows at 10%, Project A has an NPV of about 4,360 € and an IRR of approximately 16.2%. Project B has an NPV of about 6,090 € and an IRR of approximately 15.0%. Both create value (positive NPV, IRR above 10%), but they rank differently depending on the criterion.
By the IRR, we would choose A — it earns more in percentage terms. By the NPV, we would choose B — it creates more value in euros. Since there is only budget for one and they are mutually exclusive, the correct decision follows the NPV: Project B adds about 1,700 € more value to the company, despite "earning less per cent". This is exactly where intuition, anchored in the percentage, would have pointed to the worse project.
In practice
NPV and IRR do not replace judgement, but they give it a solid foundation. NPV tells you how much value an investment creates in today's euros; IRR translates that return into an easy-to-communicate percentage. Used together — and tempered with payback for risk and with sensitivity analysis for uncertainty — they turn a gut decision into a well-grounded one.
Next time a project is presented with an appealing return, it is worth asking three simple questions: are the cash flows discounted? what is the NPV? and does the decision hold if the rate rises or revenues come in below forecast? Whoever can answer them is deciding with data — and not with the optimism of a spreadsheet.
