NPV calculator
Net present value is what a stream of future cash is worth today, minus what it costs. A positive NPV means the project earns more than your required return, so it is worth doing on those numbers.
It clears the 12% you asked for.
- Present value of the cash back
- $110K
- Profitability index
- 1.10
- Internal rate of return
- 15.9%
What each year is worth today
| Year | Cash flow | Worth today |
|---|---|---|
| 0 | -$100,000 | -$100,000 |
| 1 | $20,000 | $17,857 |
| 2 | $35,000 | $27,902 |
| 3 | $45,000 | $32,030 |
| 4 | $50,000 | $31,776 |
How it works
Money later is worth less than money now, since you could invest it in the meantime and because the future is uncertain. The discount rate sets how much less. Each year's cash is divided by one plus the rate, once for each year it is away.
Present value of a year = cash flow ÷ (1 + rate)^year
NPV = sum of present values − investment today
Profitability index = present value of cash back ÷ investment
Pick a rate that matches the risk: close to a bank loan for a safe project, much higher for anything uncertain. The table under the calculator shows what each year is worth today, so you can see how little the far years count.
Worked example
You invest $100,000 and expect $20,000, $35,000, $45,000 and $50,000 over four years, at a 12% discount rate.
NPV = $9,565
Present value of the cash back = $110K
Internal rate of return = 15.9%
Where this goes wrong
Questions founders ask
What does a positive NPV mean?
That the investment earns more than your discount rate. A negative NPV can still be profitable in plain dollars, but it earns less than your required return.
What discount rate should I use?
Your cost of capital or the return you could get elsewhere at similar risk. Big companies often use about 8% to 12%, and venture-style risks call for far higher rates.
NPV or IRR?
NPV is more reliable when comparing projects of different sizes, because it gives dollars. IRR is easier to explain. Use both.
