NPV Calculator — Net Present Value of Multi-Year Cash Flows

The discount rate is an assumption, not a fact — and it drives the answer more than the cash flows do

The same project can show an NPV of +$29,079 at a 10% discount rate and −$704 at 20%. Identical cash flows, identical investment. The only thing that changed is your assumption about the return you require — and it flipped the recommendation from yes to no. Most people run NPV once, at whatever rate feels reasonable, and never discover how close to a boundary they were.

How the discounting works here

The tool computes NPV as the initial investment subtracted from the sum of each future cash flow divided by (1 + r) raised to the power of its period. The initial investment sits at period 0 and is not discounted; the first cash flow is discounted by period 1, the second by period 2, and so on. That convention is worth stating explicitly, because spreadsheet functions differ on it — the NPV function in Excel also treats its first value as period 1, so if you have included the initial outlay inside the range you will get a different answer from this tool.

The effect of compounding is easy to underestimate: at 10%, a dollar arriving in year five is worth about 62 cents today. At 15% it is worth about 50 cents. Distant money loses value quickly, and it loses it faster the higher your rate.

One set of cash flows, three rates, opposite conclusions

Take $100,000 invested against returns of $25,000, $30,000, $35,000, $40,000 and $45,000 over five years — $175,000 in total, which looks comfortably profitable before any discounting.

Moving from 10% to 15% costs $16,399 of NPV. Moving to 20% erases it entirely. The project that looked like it returned $75,000 of profit is, at a 20% required return, marginally not worth doing.

The practical lesson: never report a single NPV without stating the rate that produced it, and always test a range. A figure that stays positive from 8% to 20% is a robust decision; one that turns negative at 12% is a coin toss dressed up as arithmetic.

What the rate actually represents

It is not a standard to look up. It stands for the return available on the next best use of the same money, adjusted for the risk of these particular cash flows. A riskier project justifies a higher rate, which punishes distant inflows harder — which is precisely why speculative long-dated projects are so sensitive to the assumption, and why two reasonable people can look at one forecast and disagree about whether to proceed.

A positive NPV means it beats your hurdle, not that it makes money

This distinction gets muddled constantly. If your rate is 10% and NPV is positive, the project is expected to return more than 10% — it beats the benchmark you set. A negative NPV does not mean the project loses cash; the example above at 20% still returns $175,000 on $100,000. It simply fails to clear a 20% hurdle.

So NPV answers a relative question — does this beat my required return? — and not an absolute one. Pick the hurdle honestly, because a rate set too low will bless almost anything.

Precision in the output hides uncertainty in the input

An NPV computed to the penny from a guess about year five is still a guess. The formula is exact; the forecast is not, and the output inherits every bit of that uncertainty while looking authoritative.

The model also assumes each cash flow lands exactly on its period boundary, which real projects rarely manage. A payment that slips two quarters is discounted differently, and a project whose returns are back-loaded is far more exposed to both the rate and the timing than the single headline figure suggests.

IRR, for contrast

The internal rate of return is the discount rate at which NPV equals zero — for the example above, about 19.7%, which is why 20% just tips it negative. Its appeal is that it avoids choosing a rate at all.

The costs are real, though: IRR implicitly assumes interim cash flows are reinvested at the IRR itself, which is usually optimistic, and a project with alternating inflows and outflows can have several mathematically valid IRRs. This tool computes NPV, which requires you to name your hurdle rate. Having to defend that number is a feature rather than an inconvenience.

By contrast, ROI ignores timing altogether, treating a dollar in year one exactly like a dollar in year five — which is how a project can show a healthy total return and still fail on NPV.