NPV, IRR and payback period: evaluate an investment

An investment can look profitable while tying up money for a long time or producing most of its gains only near the end. To go beyond a simple comparison of cost and final gain, three indicators are especially useful: net present value (NPV), internal rate of return (IRR) and the payback period.

Bethemesh provides an NPV calculator, an IRR calculator and a payback period calculator to examine the same cash flows from three complementary perspectives.

One project, three different questions

Consider an initial investment of €10,000 followed by four annual cash flows of €3,000, €3,500, €4,000 and €4,500.

Adding the flows shows €15,000 in total future cash inflows, but that does not answer every question. One euro received four years from now does not necessarily have the same economic value as one euro available today.

NPV asks: how much value does the project create today after applying a discount rate? IRR asks: what rate of return is implied by these cash flows? Payback asks: how long does it take to recover the initial outlay?

NPV: measure value created today

NPV discounts every future cash flow and subtracts the initial investment:

NPV = − initial investment + sum of discounted cash flows

For period t and discount rate r:

Discounted cash flow = cash flow / (1 + r)^t

A positive NPV means that, at the chosen discount rate, the present value of future cash flows exceeds the initial investment. A negative NPV means the opposite.

The discount rate therefore matters greatly. Depending on the context, it may represent a required return, cost of capital or another comparison rate. The NPV calculator lets you change it and inspect its effect period by period.

IRR: find the project’s implied return

IRR is the discount rate at which NPV equals zero:

NPV(IRR) = 0

It expresses the return associated with a series of cash flows as a rate. It can be compared with a required return when the assumptions and periods are consistent.

The IRR calculator finds that rate from the initial investment and future cash flows.

IRR has an important limitation: some cash-flow patterns, particularly those that change sign more than once, can produce multiple mathematical solutions or make a single IRR ambiguous. A unique result should therefore not be forced when the cash flows do not support one.

Payback period: when is the investment recovered?

The payback period accumulates cash flows until they offset the initial investment.

With €10,000 invested and the cash flows in our example, the cumulative amount reaches €6,500 after two periods and passes €10,000 during the third. Recovery therefore occurs between those dates.

The payback period calculator distinguishes simple payback from discounted payback. Discounted payback applies a discount rate and is generally longer when that rate is positive.

Payback is intuitive for understanding how quickly capital is recovered, but it does not measure the project’s full profitability and can ignore cash flows occurring after recovery.

NPV, IRR or payback: which should you use?

You do not need to choose only one. They complement each other:

• NPV expresses value creation as a monetary amount;
• IRR expresses return as a rate;
• payback period measures how quickly invested capital returns.

Two projects can therefore tell different stories. One may recover its cost quickly but create little additional value, while another may have a longer payback and a higher NPV.

What about ROI?

ROI is still excellent for a first look because it compares net gain with investment cost. The guide ROI calculation: formula and return on investment explains the calculation and its limitations.

The key difference is timing. Simple ROI does not account for when gains occur. NPV, IRR and payback use the sequence of cash flows, while NPV and discounted payback can explicitly account for the time value of money.

ROI may be enough for a quick assessment. When projects have cash flows distributed differently over time, NPV, IRR and payback provide a more complete comparison.

Limitations to keep in mind

None of these indicators predicts the future. Results depend directly on the cash-flow assumptions and, for discounted calculations, the selected rate. Uncertain future income remains uncertain even when it is entered into a precise formula.

These measures also do not replace analysis of risk, financing, taxation or project-specific constraints. Their role is to transform a cash-flow scenario into explicit, comparable indicators.

For a different business question, the break-even calculator shows the level of sales required to cover costs.