NPV Calculator

Net present value answers the fundamental investment question: is this project worth more than it costs, once you account for the fact that money later is worth less than money now? A positive NPV means the discounted future cash flows exceed the upfront investment. A negative one means you would destroy value by proceeding.

Enter your details
$
$
%
years
Net present value$21,710
Present value of inflows$121,710
Initial investment$100,000
Profitability index1.22
YearCash flowPresent valueCumulative NPV
1$25,000$22,727-$77,273
2$25,000$20,661-$56,612
3$25,000$18,783-$37,829
4$25,000$17,075-$20,753
5$25,000$15,523-$5,230
6$25,000$14,112$8,882
7$25,000$12,829$21,710

Why future money gets discounted

Money received next year is worth less than money today for three reasons: today's money could be invested and earn a return, inflation erodes what future money buys, and future cash flows carry risk of not arriving. The discount rate rolls all three into one percentage.

Each year's cash flow is divided by (1 + rate)^year. At a 10% rate, 25,000 received in year one is worth about 22,727 today; the same amount in year seven is worth only about 12,829. Distance shrinks value.

Choosing the discount rate

Companies typically use their cost of capital, often 8 to 15%. The logic: a project must beat what the same money costs to raise, or earns elsewhere at similar risk, to be worth doing. Riskier projects deserve higher rates.

NPV is highly sensitive to this choice, which makes it worth testing a range. A project that only shows positive NPV at optimistic discount rates is telling you something.

Frequently asked questions

What does a positive NPV mean?

The project's discounted future cash flows exceed the initial investment, so it creates value at your discount rate. Between competing projects, the higher NPV creates more value.

What discount rate should I use?

Your cost of capital or required return, commonly 8 to 15% for businesses. Use higher rates for riskier cash flows.

What is the profitability index?

Present value of inflows divided by the initial investment. Above 1 means positive NPV. It is useful for ranking projects when capital is limited.

How does NPV differ from IRR?

NPV gives a value in currency at your chosen rate. IRR finds the rate at which NPV equals zero. They usually agree on accept/reject but can rank competing projects differently.

Can I model uneven cash flows?

This calculator uses equal annual cash flows for clarity. For uneven flows, the same discounting applies to each year individually.

Does NPV account for inflation?

Implicitly, if your discount rate includes it and your cash flows are in nominal terms. Keep both nominal or both real; mixing them is the classic error.