Financial
NPV
Net present value of cash flows starting at period 1.
Syntax
NPV(rate, value1, …)Example: =NPV(15%,B4:B8)+B3
Available in: All versions
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =NPV(10%,B3:B6)+B2
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Year | Cash flow | Result | |
| 2 | 0 | -10000 | 1121.50809371 | |
| 3 | 1 | 3000 | ||
| 4 | 2 | 4000 | ||
| 5 | 3 | 4500 | ||
| 6 | 4 | 2500 |
Result in D2: 1121.50809371