NPV Calculator

Calculate net present value (NPV) of an investment from future cash flows. Free NPV calculator with IRR estimate and worked example.

NPV (net present value) is the present value of an investment's future cash flows minus its initial cost. This calculator handles a year-by-year cash flow stream, discounts each year back to today using your chosen rate, sums the present values, subtracts the initial investment, and shows whether the project clears that hurdle. It also estimates the IRR - the discount rate at which NPV equals zero. The accept rule is simple: positive NPV is worth doing at the rate you required, negative NPV is not.

Ad

For informational purposes only. Not financial advice. Calculations are estimates and may not reflect your exact situation. Consult a qualified financial adviser for personalised guidance.

Ad

About NPV Calculator

How Does NPV Work?

NPV discounts every future cash flow back to today and then subtracts the upfront cost. The formula is NPV = -C0 + Σ CFt / (1 + r)^t for t = 1 to n, where C0 is the year-0 outflow, CFt is the cash flow in year t, r is the discount rate per period, and n is the project life. Each year's cash flow is divided by a discount factor that grows with time, so distant cash flows count for less. Harvard Business Review's 2014 NPV refresher (still the most cited HBR explainer on the topic) frames the discount rate as the cost of capital you would have to forgo to take this project on. For corporate work that is the WACC; for personal use it is the return on your next-best alternative.

Worked example: A project costs $100,000 upfront and is expected to generate $30,000, $40,000, $35,000, $25,000, and $20,000 in years 1 through 5. The discount rate is 8% (a typical mid-size corporate WACC per NYU Stern data, January 2026). Discounting each year:

  • Year 1: $30,000 / 1.08^1 = $30,000 x 0.925926 = $27,777.78
  • Year 2: $40,000 / 1.08^2 = $40,000 x 0.857339 = $34,293.55
  • Year 3: $35,000 / 1.08^3 = $35,000 x 0.793832 = $27,784.13
  • Year 4: $25,000 / 1.08^4 = $25,000 x 0.735030 = $18,375.75
  • Year 5: $20,000 / 1.08^5 = $20,000 x 0.680583 = $13,611.66
  • Sum of present values: $121,842.87
  • NPV = $121,842.87 - $100,000 = $21,842.87

The NPV is positive, so the project beats an 8% required return and adds about $21,843 of value in today's money. The corresponding IRR (the rate that makes NPV zero) is 16.62%. The investor would only reject this if their required return exceeded 16.62%. This is exactly the calculation the tool runs in real time when you adjust the discount-rate slider.

What Is a Good NPV?

Any positive NPV is good, but bigger is better only when projects are equally risky and equally sized. NPV is a dollar figure, so a $10,000 NPV on a $50,000 project is much stronger than a $10,000 NPV on a $5 million project. The first means a 20% premium over the required return; the second means roughly 0.2%. For ranking projects of different sizes, use the ROI calculator or the Profitability Index (NPV / initial investment) alongside NPV.

The discount rate matters more than people think. The same cash flows can produce a wildly different NPV depending on the rate, and the impact grows with project life. Here is the example project above at different discount rates:

Discount RateSum of PVsNPVDecision
5%$131,325+$31,325Strong invest
8%$121,843+$21,843Invest
10%$116,120+$16,120Invest
15%$103,583+$3,583Marginal
16.62% (IRR)$100,000~$0Break-even
20%$93,126-$6,874Reject

Moving the rate from 5% to 20% turns the NPV from +$31,325 to -$6,874 on identical cash flows. This is why a sensitivity check across plausible discount rates is more useful than a single point estimate. The UK Treasury's Green Book - the official guide for evaluating public-sector projects - explicitly requires sensitivity analysis on the discount rate for exactly this reason, and uses a Social Time Preference Rate of 3.5% (declining to 3.0% after 30 years) for long-lived projects.

Discount Factor Reference Table

The discount factor for year t at rate r is 1 / (1 + r)^t. Multiply any future cash flow by the factor to get its present value. Below is a reference table for the rates and horizons people use most:

Year3%5%8%10%12%
10.97090.95240.92590.90910.8929
20.94260.90700.85730.82640.7972
30.91510.86380.79380.75130.7118
50.86260.78350.68060.62090.5674
70.81310.71070.58350.51320.4523
100.74410.61390.46320.38550.3220

At 12% over 10 years, $1 of future cash is worth 32 cents today. At 3%, the same dollar is worth 74 cents. That gap is why distant cash flows are nearly worthless in high-rate environments and dominate the answer when rates are low. To see the reverse direction (today's money projected forward), use the future value calculator. For a single future amount rather than a stream, the present value calculator is the simpler tool.

NPV vs IRR: Which Is Better?

NPV is the more reliable accept-or-reject rule, but IRR is easier to communicate. Both measure the same thing - whether a project beats the cost of capital - and on a single project with one initial outflow followed by inflows, they always agree. They diverge when:

  • Comparing projects of different sizes. IRR is a percentage and ignores scale. A project with a 30% IRR on $10,000 adds less wealth than a 15% IRR on $1 million.
  • Non-conventional cash flows. If cash flow signs change more than once (outflow, inflow, outflow), the IRR equation can have multiple real solutions, per the multiple-IRR problem documented in every corporate finance textbook (e.g. Brealey, Myers and Allen's Principles of Corporate Finance). NPV always gives one answer.
  • Reinvestment assumption. IRR implicitly assumes intermediate cash flows are reinvested at the IRR itself, which is often unrealistic for high-IRR projects. NPV reinvests at the discount rate, which matches the opportunity cost.
NPVIRR
UnitsCurrency (dollars, pounds)Percentage
Reinvestment assumptionAt the discount rate (opportunity cost)At the IRR itself
Multiple solutions possible?NoYes, with non-conventional flows
Best forAccept/reject and ranking different-sized projectsQuick communication, comparing similar projects
What it tells youWealth added in today's moneyImplied return rate

The Corporate Finance Institute's NPV reference puts it bluntly: when NPV and IRR disagree, follow NPV. The same conclusion appears in the CFA curriculum and in most CFO surveys. For shorter projects where you mainly want to know "how fast does this pay back?", pair NPV with the payback period calculator instead of IRR alone - payback handles the timing question NPV intentionally compresses into one number.

Common NPV Mistakes

Small input errors produce large NPV swings because of compounding. The ones that catch out beginners (and a surprising number of MBAs):

  • Using accounting profit instead of cash flow. NPV uses cash, not profit. Depreciation is a non-cash expense - subtract it for tax purposes, then add it back to get cash flow. Working-capital changes are also cash, even though they don't hit the income statement.
  • Mixing nominal and real terms. If cash flows are in today's purchasing power (real), use a real discount rate. If they're in future dollars (nominal), use a nominal rate. Mixing them under-states or over-states NPV by 20% or more over a 10-year horizon at typical inflation rates.
  • Forgetting the terminal value. If the project keeps generating cash after the explicit forecast period, include a terminal value (often book salvage or a perpetuity: CF / (r - g)). Omitting it can flip the decision on long-lived assets.
  • Treating the discount rate as certain. A 200 basis point change in the rate can shift NPV by 30% on a 10-year project. Always run NPV at the low, mid, and high end of plausible cost-of-capital estimates - this calculator's slider is built for that.
  • Double-counting financing costs. The discount rate already captures the cost of capital. Don't subtract interest payments from the cash flows on top of discounting - that double-counts the financing cost. Use free cash flow to firm, not free cash flow to equity, when discounting at WACC.
  • Ignoring opportunity cost. If a project uses an existing asset that could otherwise be sold or rented, include the foregone cash as an opportunity cost. NPV based on incremental cash flows must capture what you give up, not just what you pay out.

Real-World NPV Applications

NPV is the workhorse of corporate capital budgeting. Graham and Harvey's 2001 survey of US CFOs (published in the Journal of Financial Economics) found roughly three-quarters of large US firms regularly use NPV when evaluating capital projects - more than any other discounted-cash-flow criterion. Some concrete uses:

  • Equipment purchases: A $250,000 machine projected to save $50,000/year in labour for 7 years at a 10% required return. Sum of PVs = $50,000 x 4.8684 (annuity factor) = $243,420. NPV = -$6,580 (reject) at 10%, but +$29,119 (accept) at 6%.
  • Real estate development: Discount the initial land cost, construction outflows, and rental cash flows back to today. A property that produces 5% gross yield with 2% inflation in net operating income has a positive NPV at discount rates up to roughly 7%.
  • Government infrastructure: The UK Treasury Green Book uses a 3.5% social time preference rate (3.0% beyond 30 years) for NPV evaluation of public projects, intentionally lower than private-sector rates to capture social benefits.
  • Pharmaceutical R&D: A drug with $200M upfront cost, 8 years of $0 cash flow during development, and 15 years of $80M/year sales. At 12% (reflecting clinical-trial failure risk), NPV is roughly +$50M. At 18% it turns negative. This sensitivity is why pharma uses NPV plus risk-adjusted decision trees.

For weighting the cost of capital used as the discount rate, the WACC calculator blends debt and equity costs based on the company's capital structure - exactly the rate corporate finance teams plug into NPV decisions.

Sources

All calculations run in your browser. No data is transmitted.

Frequently Asked Questions

What is net present value (NPV)?

NPV is the difference between the present value of future cash inflows and the initial cash outflow of a project. It tells you in today's money whether an investment is worth more than what you pay for it. A positive NPV means the project beats the discount rate you required. A negative NPV means it falls short. Zero means it exactly meets the required return.

What is the NPV formula?

NPV = -C0 + sum of CFt / (1 + r)^t for t = 1 to n. C0 is the initial investment (a cash outflow at year 0), CFt is the cash flow at year t, r is the discount rate per period, and n is the number of periods. The calculator handles each year individually so cash flows can differ year to year, which is the main thing that separates NPV from a simple present value calculation.

What discount rate should I use for NPV?

Use the rate that reflects the project's risk. For a corporate project, the weighted average cost of capital (WACC) is the standard choice, typically 8-12% for large US firms per NYU Stern's January 2026 data. For a personal investment, use your next-best alternative return (an index fund averaging around 10% nominal historically, or a government bond yield around 4-5% for a safer comparison). Higher risk deserves a higher rate.

NPV vs IRR which is better?

NPV and IRR usually agree on accept or reject, but NPV wins when they disagree. NPV gives a dollar value (how much wealth the project adds), while IRR gives a rate. IRR can be misleading for projects with non-conventional cash flows (multiple sign changes), can produce multiple solutions, and assumes reinvestment at the IRR itself. NPV doesn't have these problems. This calculator shows both so you can compare.

Can NPV be negative?

Yes. A negative NPV means the project does not earn enough to clear your required return, so it destroys value at that discount rate. It can still produce positive cash but not enough to compensate for the time value of money and risk. A common mistake is mixing this up with cash flow - a project can have a negative NPV even if total nominal cash flows exceed the initial investment.

Link to this tool

Copy this HTML to link to this tool from your website or blog.

<a href="https://toolboxkit.io/tools/npv-calculator/" title="NPV Calculator - Free Online Tool">Try NPV Calculator on ToolboxKit.io</a>