Finance.Xnpv Method

FinanceXnpv Method

Returns the present value for a schedule of cash flows.

Namespace: Imsl.Finance
Assembly: ImslCS (in ImslCS.dll) Version: 6.5.2.0

Syntax

public static double Xnpv(
	double rate,
	double[] cashFlow,
	DateTime[] dates
)

Public Shared Function Xnpv ( 
	rate As Double,
	cashFlow As Double(),
	dates As DateTime()
) As Double

public:
static double Xnpv(
	double rate, 
	array<double>^ cashFlow, 
	array<DateTime>^ dates
)

static member Xnpv : 
        rate : float * 
        cashFlow : float[] * 
        dates : DateTime[] -> float

rate: Type: SystemDouble
A double which specifies the interest rate.
cashFlow: Type: SystemDouble
A double array containing the cash flows.
dates: Type: SystemDateTime
A DateTime array which contains a schedule of payment dates.

Type: Double
A double which specifies the present value.

Remarks

It is not necessary that the cash flows be periodic. It is computed using the following:

$\sum\limits_{i = 1}^{\it count} {{{{\it value}_i } \over {\left( {1 + {\it rate}} \right)^{\left( {d_i - d_1 } \right)/365}}}}$

In the equation above, represents the th payment date, represents the first payment date, and ${\it value}_i$ represents the th cash flow.