Spread Formula Reference
XNPV
Formula Functions > Functions T to Z > XNPV

This function calculates the net present value for a schedule of cash flows that may not be periodic.

Syntax

XNPV(rate,values,dates)

Arguments

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

Remarks

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.

Data Types

Accepts numeric data for rate and values, and DateTime object data for dates. Returns numeric data.

Examples

XNPV(0.09,B2:B6,C2:C6)

Version Available

This function is available in product version 2.0 or later.

See Also

IRR | NPV | MIRR | XIRR | Financial Functions