XNPV(R, V, D)

 

Description

This function returns the net present value for a series of cash flows (V) with variable intervals (D).  V and D must be one-dimensional ranges and have the same size.

 

Parameters

 

R

Discount rate to apply to the cash flows.

 

V

A range containing a series of cash flows.

 

D

A range containing the dates of cash flows in V.

 

Examples

 

Given:

 

 

XNPV(9.00%, B1:B5, A1:A5) = 705.1677