NPV Calculator

Calculate Net Present Value, IRR, payback period and a full discounted cash-flow schedule.

Ad placeholder (leaderboard)
Enjoying the tools? Go Pro for £4.99 (one-time) and remove all ads — forever, on this device. Remove ads — £4.99

Net Present Value (NPV) is the single most important metric in capital budgeting. It answers the fundamental question: does this investment create or destroy value, measured in today’s money? By discounting every future cash flow back to the present, NPV accounts for the time value of money — a pound received in five years is worth less than a pound today because you could have invested it in the meantime. This calculator gives you NPV, Internal Rate of Return (IRR), two payback periods and a complete discounted cash-flow schedule, all computed instantly in your browser.

How it works

You provide a discount rate (your hurdle rate or cost of capital) and a series of cash flows — one per period, starting at period 0 (today). The tool applies the standard NPV formula:

NPV = sum of [ CF_t / (1 + r)^t ] for t = 0, 1, 2, … n

where CF_t is the net cash flow at period t and r is the discount rate per period. Period 0 is usually a negative number representing the upfront investment. Each subsequent period is the net cash inflow or outflow at the end of that period.

IRR is found via bisection: the tool searches for the rate r* at which NPV equals zero by bracketing the root between -99.99% and 1000% and halving the interval up to 200 times, stopping when the result converges to within 1 × 10⁻¹⁰. This is robust for conventional cash-flow patterns (one sign change from negative to positive). If the cash-flow pattern has multiple sign changes — for example a project with a large decommissioning cost at the end — multiple IRRs may exist and the NPV profile is the more reliable decision tool.

The Profitability Index (PI) equals (NPV + |initial outlay|) / |initial outlay|. It ranks projects by value created per unit of capital invested, which is useful when you have a limited capital budget and must choose between projects of different sizes. A PI above 1.0 means accept; below 1.0 means reject.

Worked example

A logistics company considers installing automated sorters for £100,000 today (Period 0 = −100,000). Expected net savings and revenues over five years:

PeriodCash flow (£)
0−100,000
130,000
240,000
350,000
430,000
520,000

At a 10% hurdle rate:

  • Discount factors: 1.000, 0.909, 0.826, 0.751, 0.683, 0.621
  • Discounted CFs: −100,000 / 27,273 / 33,058 / 37,566 / 20,490 / 12,418
  • NPV = +£30,805 → project creates value; accept it
  • IRR ≈ 20.8% (well above the 10% hurdle)
  • Simple payback ≈ 3.0 years (cumulative raw CF turns positive mid-Period 3)
  • Discounted payback ≈ 3.7 years
  • Profitability Index ≈ 1.308

If the hurdle rate rises to 18%, the NPV falls to roughly +£3,400 — still positive but far less compelling. At about 20.8% it reaches zero (the IRR), and above that the NPV turns negative, meaning the project no longer covers its cost of capital. This sensitivity to the discount rate is why testing multiple rates matters.

All figures are calculated locally in your browser — nothing is uploaded or stored.

Ad placeholder (rectangle)