XNPV
Returns net present value for irregular cash flows.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number
Examples
=XNPV(0.09, A1:A5, B1:B5) | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 20 | 4 |
| 3 | 30 | 6 |
| 4 | 40 | 8 |
| 5 | 50 | 10 |
Result 149.81126223483471
Syntax
XNPV(rate, values, dates)rate- number required
values- range required
dates- range required
Errors
#NUM!=XNPV(0.05, A1:A3, DATE(2026,1,15))
Related
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.