Net Present Value (NPV) Calculator

What should I know about NPV Formula?

NPV = -Initial Investment + CF₁/(1+r) + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ. A positive NPV means the investment creates value above the hurdle rate. A negative NPV means it destroys value — you'd be better returning the money to investors or finding an alternative.

What do I need to know about Choosing a Discount Rate?

For personal decisions, use your opportunity cost (e.g. 7% for stock market returns). For business decisions, use the Weighted Average Cost of Capital (WACC). A higher discount rate makes future cash flows worth less today — a critical insight for long-term projects.

What's the difference between NPV and IRR?

IRR (Internal Rate of Return) is the discount rate that makes NPV = 0. It's the true return of the investment. Compare IRR to your hurdle rate — if IRR > hurdle rate, proceed. NPV is generally more reliable when comparing projects of different sizes.

When to Seek Financial Advice?

Calculator results provide estimates based on stated inputs and should not replace professional financial advice for significant decisions. Free, regulated financial guidance is available through MoneyHelper (moneyhelper.org.uk, 0800 011 3797) for general money queries. Regulated independent financial advisers (IFAs) — find one at unbiased.co.uk — provide personalised advice on mortgages, pensions, investments, and insurance. Advice fees are typically £150-350 per hour or a percentage of assets under management, usually around 1-2% annually. For smaller, one-off decisions, free and impartial guidance is available from MoneyHelper (moneyhelper.org.uk), a government-backed service — a good first stop before paying for full advice.

What should I know about Sensitivity to the Discount Rate?

NPV is often far more sensitive to the discount rate assumption than people expect, because the rate is compounded over every future period — a project with cash flows stretching 10+ years into the future can swing from clearly positive NPV to clearly negative NPV with just a few percentage points' change in discount rate. This matters because the discount rate is usually an estimate (a company's weighted average cost of capital, or a required rate of return), not a known fact, and reasonable people can disagree on the right figure by 2-3 percentage points or more. Good practice is to run the NPV calculation at a range of discount rates — for example, your base-case estimate, plus 2 points, and minus 2 points — rather than relying on a single number, to see whether the investment decision actually changes across that range or stays robustly positive (or negative) regardless. A decision that only looks good at the most optimistic discount rate assumption is a much weaker case than one that holds up across a realistic range.

What's the key thing to understand about Why Timing of Cash Flows Matters?

Two projects can have identical total cash flows over their lifetime and very different NPVs simply because of when the money arrives. A project that returns most of its cash in years 1-2 will have a higher NPV than one with identical total returns concentrated in years 8-10, because near-term cash flows are discounted less heavily. This is why NPV is considered a more rigorous investment appraisal tool than simple payback period or total-return comparisons: it penalises cash flows that arrive late, reflecting the real opportunity cost of waiting for your money. In practice, this means NPV calculations reward front-loaded returns and are naturally cautious about long-dated projects, even genuinely good ones, if the bulk of the payoff sits many years out. When comparing two investment options with similar total NPV, it's worth separately checking the payback period and the shape of the cash flow timeline, since NPV alone can mask important differences in risk and liquidity between a fast-returning and a slow-returning project.

Why a Dollar or Pound Today Is Worth More Than the Same Amount in the Future

Net Present Value (NPV) is built on the principle that money available today is worth more than an identical nominal amount received in the future, because today's money could be invested and grow in the meantime — or simply because of inflation eroding future purchasing power and the basic uncertainty of a future payment actually arriving. NPV calculates this by "discounting" each future cash flow back to its present-day equivalent value using a chosen discount rate, then summing all those discounted amounts (including the initial investment, typically entered as a negative cash flow at time zero) to arrive at a single figure representing the project or investment's value in today's terms.

Why the Choice of Discount Rate Can Flip a Positive NPV Into a Negative One

The discount rate used in an NPV calculation is not an arbitrary input — it should reflect the opportunity cost of capital, essentially the return you could reasonably expect from an alternative investment of similar risk, and a higher discount rate shrinks the present value of every future cash flow, more severely for cash flows further in the future. Because of this sensitivity, a project or investment that shows a healthy positive NPV at a conservative discount rate can turn negative at a higher, more demanding rate, which is exactly why serious financial analysis often tests NPV across a range of discount rate assumptions rather than relying on a single rate, to understand how robust the conclusion really is to that underlying assumption.

Worked Example: NPV of a Five-Year Investment

Suppose an initial investment of $50,000 is expected to generate the following cash flows over five years, evaluated at a discount rate of 8%.

Summing the present values gives a Net Present Value of approximately $6,931 (11,112 + 12,000 + 11,907 + 11,021 + 10,891 − 50,000). Because NPV is positive, this investment is expected to generate value above the 8% hurdle rate used in the discounting — a project only clears the 'worth doing' bar at a given discount rate if its discounted cash inflows exceed the initial outlay. Notice how later cash flows (year 5's $16,000) contribute less to the final NPV (only $10,891 of present value) than earlier ones, purely because of discounting — this is why the timing of cash flows, not just their total, matters so much to the final result.

Why the Discount Rate Choice Can Flip the Decision

Using the same cash flows as the worked example above, raising the discount rate from 8% to 14% — perhaps because the project is judged riskier, or the company's cost of capital has risen — changes the discount factors enough that NPV falls to roughly negative $2,000 to -$3,000, flipping the investment decision from 'accept' to 'reject' using the exact same projected cash flows. This sensitivity is precisely why the discount rate chosen matters as much as the cash flow forecasts themselves: it should typically reflect the investor's cost of capital (what they could earn or what financing this costs) adjusted for the specific risk of the project, not an arbitrary round number. A common practice is to run the same NPV calculation at several discount rates — a 'sensitivity table' — rather than relying on a single rate, specifically because a project that looks attractive at one reasonable discount rate assumption can look unattractive at another equally reasonable one, especially for projects with cash flows weighted toward later years.

NPV vs Payback Period as Decision Tools

Payback period — how long it takes for cumulative cash inflows to equal the initial investment — is a simpler and more intuitive metric than NPV, which is part of why many businesses look at both. In the five-year worked example above, cumulative cash flows reach $50,000 sometime during year 4 (12,000+14,000+15,000+15,000 = 56,000 by the end of year 4), giving a payback period of a little under 4 years. Payback period, however, ignores the time value of money entirely (it doesn't discount future cash flows) and ignores everything that happens after the payback point is reached, which means it can favor a project with fast but modest total returns over one with a slower payback but a much larger NPV once all cash flows are properly discounted and totaled. Because of these blind spots, payback period is best used as a secondary liquidity/risk check (how long is capital tied up before being recovered) alongside NPV as the primary value-creation metric, rather than as a substitute for it.