NPV function
the net present value of an investment based on a series of periodic cash flows and a discount rate.
Financial
Where can you use it?
Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.
Scenario in the workbook
Discount end-of-period cash flows. The first amount is received one period from now.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Criterion | Amount |
| 7 | 0 | 100 | 200 |
| 8 | 0.1 | 110 | 121 |
| 9 | 0 | 0 | 25 |
Record 1
=NPV(A7,B7,C7)Expected result300
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=NPV(0,100,200)Turkish Excel · tr-TR
=NBD(0;100;200)Expected result
300
Worked examples
Discount end-of-period cash flows. The first amount is received one period from now.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Criterion | Amount |
| 7 | 0 | 100 | 200 |
| 8 | 0.1 | 110 | 121 |
| 9 | 0 | 0 | 25 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =NPV(A7,B7,C7) |
300 |
| Record 2 | =NPV(A8,B8,C8) |
200 |
| Record 3 | =NPV(A9,B9,C9) |
25 |