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

FinanceXirr Method (Double, DateTime, Double)

Returns the internal rate of return for a schedule of cash flows with a user supplied initial guess.

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

Syntax

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

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

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

static member Xirr : 
        pmt : float[] * 
        dates : DateTime[] * 
        guess : float -> 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.
guess: Type: SystemDouble
A double value which represents an initial guess at the return value from this function.

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