Navigation:  Formula Reference > Spreadsheet Formula Functions >

XNPV

Previous pageReturn to chapter overviewNext page

 

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)

 

See Also

IRR

MIRR

NPV

XIRR