This function calculates the net present value for a schedule of cash flows that may not be periodic.
XNPV(rate,values,dates)
This function has these arguments:
| Argument | Description |
|---|---|
| rate | Discount rate to apply to the cash flows |
| values | Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment |
| dates | Schedule of payment dates that corresponds to the cash flow payments in values |
Numbers in dates are truncated to integers. A #VALUE! error is returned if any argument is nonnumeric or if any date is invalid. If a number in dates precedes the starting date, a #NUM! error is returned. If values and dates have a different number of values, a #NUM! error is returned.
Accepts numeric data for rate and values, and DateTime object data for dates. Returns numeric data.
XNPV(0.09,B2:B6,C2:C6)
This function is available in product version 2.0 or later.
IRR | NPV | MIRR | XIRR | Financial Functions