Financial
XNPV
NPV for cash flows on arbitrary dates.
Syntax
XNPV(rate, values, dates)Example: =XNPV(15%,B2:B6,A2:A6)
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: =XNPV(10%,B2:B5,A2:A5)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Cash flow | Result | |
| 2 | 1/1/2026 | -10000 | 1344.63782042 | |
| 3 | 6/1/2026 | 3000 | ||
| 4 | 1/1/2027 | 4500 | ||
| 5 | 6/1/2027 | 5000 |
Result in D2: 1344.63782042