Personal Finance Insurance Credit Score Credit Cards Loans Investing Calculators All guides Subscribe

Net Present Value (NPV) Calculator

This net present value (NPV) calculator discounts up to ten years of cash flows back to today and tells you whether an investment adds value at your required rate of return. It also reports the IRR, discounted payback period and profitability index, so small business owners, investors and students can judge a project from several angles at once.

What is net present value?

Net present value is the sum of all of a project’s cash flows, each converted into today’s dollars, minus the money you put in up front. It rests on the time value of money: a dollar received in five years is worth less than a dollar today, because today’s dollar could be invested and earn a return in the meantime.

A positive NPV means the project earns more than your discount rate and adds value. A negative NPV means you would do better putting the money in an alternative that earns the discount rate. Because NPV is measured in dollars, it shows how much value a project creates, not just whether it clears a hurdle.

How to use the Net Present Value (NPV) Calculator

  1. Discount rate — the annual return you require, often your cost of capital, WACC, or the return on your next-best investment. Riskier projects warrant a higher rate.
  2. Year 0 (initial investment, negative) — the upfront cost, entered as a negative number, for example -50,000. Year 0 is today and is not discounted.
  3. Year 1 cash flow through Year 10 cash flow — the net cash the project generates (or costs) at the end of each year. Enter negative values for years with further outlays, and leave unused later years at zero; trailing zero years are ignored.

How the net present value is calculated

Each year’s cash flow is divided by (1 + r) raised to the number of years from today, and the results are added together.

NPV = CF0 + CF1 ÷ (1 + r)1 + CF2 ÷ (1 + r)2 + … + CFn ÷ (1 + r)nwhere CFt is the net cash flow in year t, CF0 is the negative initial investment, r is the discount rate as a decimal and n is the final year

Alongside NPV, the tool shows an accept or reject decision at your rate, the IRR (the rate at which NPV equals zero), the discounted payback period (when cumulative discounted cash flow turns positive, interpolated within the year) and the profitability index (1 + NPV ÷ initial investment). A year-by-year table lists each cash flow, its present value and the running cumulative present value.

Worked example

A business is weighing a $50,000 equipment purchase expected to produce $12,000, $15,000, $18,000, $20,000 and $22,000 in net cash over the next five years. Its required return is 10%.

Item Value
Year 0: -$50,000 (not discounted) -$50,000
Year 1: $12,000 ÷ 1.10 $10,909
Year 2: $15,000 ÷ 1.102 $12,397
Year 3: $18,000 ÷ 1.103 $13,524
Year 4: $20,000 ÷ 1.104 $13,660
Year 5: $22,000 ÷ 1.105 $13,660
Net present value $14,150

The NPV is positive, so the project clears the 10% hurdle and the decision is to accept. The IRR is 19.44%, the discounted payback is about 4.0 years and the profitability index is 1.28, meaning each dollar invested returns $1.28 in present value.

Interpreting the results

  • NPV above zero: the project beats your required return. Zero: it earns exactly that return. Below zero: it falls short.
  • When choosing between mutually exclusive projects, prefer the one with the higher NPV, even if another has a higher IRR.
  • Test a range of discount rates. If NPV turns negative with a small increase in the rate, the project has little margin for error.
  • Use the profitability index to rank projects when capital is limited, since it shows value created per dollar invested.
  • Count only incremental cash flows: extra revenue, cost savings, added maintenance, taxes and any salvage value. Ignore money already spent.
  • Remember that cash flow estimates in later years are the least reliable; build a conservative case alongside your base case.

Keep in mind: NPV is only as good as its inputs. The calculator assumes each cash flow arrives at the end of its year and uses a single discount rate throughout, so projects with irregular timing or changing risk need a more detailed model.

Frequently asked questions

What discount rate should I use for NPV?

Use the return you could reasonably earn elsewhere at similar risk. Companies commonly use their weighted average cost of capital, while individual investors may use their expected portfolio return or a loan rate they would otherwise pay down. Add a premium for projects that are riskier than usual.

What is the difference between NPV and IRR?

NPV measures value created in dollars at a chosen discount rate, while IRR is the discount rate that makes NPV exactly zero. Both usually agree on whether to accept a single project, but they can rank competing projects differently. When they conflict, NPV is generally the better guide.

Can NPV be negative?

Yes. A negative NPV means the project’s discounted cash inflows do not cover its cost at your required return. It may still earn a positive return, just less than your discount rate.

Why does Excel’s NPV function give a different answer?

Excel’s NPV function treats the first value in the range as arriving one period from now and discounts it. To match this calculator, apply NPV to years 1 through n only, then add the year 0 investment separately.

What is a good profitability index?

A profitability index above 1.0 means the project’s present value of inflows exceeds its cost, which matches a positive NPV. Higher is better, and the index is most useful for ranking projects when you cannot fund them all.

Results are estimates for educational purposes and are not financial, tax or legal advice. Figures reflect 2026 rules where noted; confirm details with official sources or a qualified professional.

Scroll to Top