Finance.Xirr Method (Double[], DateTime[])

FinanceXirr Method (Double, DateTime)

Returns the internal rate of return for a schedule of cash flows.

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

Syntax

public static double Xirr(
	double[] pmt,
	DateTime[] dates
)

Public Shared Function Xirr ( 
	pmt As Double(),
	dates As DateTime()
) As Double

public:
static double Xirr(
	array<double>^ pmt, 
	array<DateTime>^ dates
)

static member Xirr : 
        pmt : float[] * 
        dates : DateTime[] -> float

Parameters

pmt: Type: SystemDouble
A double array which contains cash flow values which correspond to a schedule of payments in dates.
dates: Type: SystemDateTime
A DateTime array which contains a schedule of payment dates.

Return Value

Type: Double
A double which specifies the internal rate of return.

Remarks

It is not necessary that the cash flows be periodic. It can be found by solving the following:

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

In the equation above, represents the th payment date. represents the 1st payment date. ${\it value}$ represents the th cash flow. ${\it rate}$ is the internal rate of return.

Reference

Finance Class

Xirr Overload

Imsl.Finance Namespace

Other Resources

Example