XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic.
FinancialFinance & Accounting
What it does
Calculates Net Present Value for irregular intervals.
Syntax
XNPV(rate, values, dates)
Arguments
rate(number) — Discount rate.values(range) — Cash flows.dates(range) — Dates.
Examples
Irregular NPV
Calculate value.
FORMULA
=XNPV(0.1, B2:B4, A2:A4)
RESULT
150.5
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Date | Flow |
| 2 | 2023-01-01 | -1000 |
| 3 | 2023-06-01 | 500 |
| 4 | 2024-01-01 | 800 |