Manuals/calci/XIRR

XIRR(v,d,g,ac,nt)

$v$ is the array of values.
$d$ is the date value.
$g$ is the starting number is close to the result of XIRR.
$ac$ is the accuracy value.
$nt$ is the number of iterations.

Description

This function gives the internal rate of return for a series.
In this function the cash flows that occur at uniform intervals which means that is not necessarily periodic.
To calculate the internal rate of return for a series in a periodic time ,we can use the IRR function.
$XIRR$ is the $IRR$ when the periodicity between cash flows is not equal.
$XIRR$ function uses the iterative process to calculate the returns, so it is not possible to trial by hand.
So this is most powerful function in CALCI.
In $XIRR(v,d,g,ac,nt)$ , $v$ is an values which is the array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.
$v$ must have atleast one positive and one negative value to find the internal rate of return.
Normally the first payment is optional,so the corresponding payment that occurs at the beginning of the investment.
Then the first payment should be negative value.
$d$ is the date value which is indicating the schedule of the payment.
Also the first payment date is the beginning of the schedule of payments.
And date should entered in DATE function format.
$g$ is the guess which is indicating the number that you guess is close to the result of $XIRR$ .
$ac$ is the accuracy value .
$nt$ is the number of iterations.
suppose when we are omitting the value of $nt$ ,by default it will consider as 10.
The value of $v$ can be array or reference argument contains text, logical values or empty cells, the values which are ignored.
The $g$ value is optional, when we are omitting the $g$ value,by default it will consider the value as 10%(0.1).
This function is using iterative technique, so we can't find a result after 100 iterations.
So the rate is changed until:

    di=the ith, or last,payment date.
    d1=the 0th payment date.
    Pi=the ith or last payment.

The rate of return calculated by $XIRR$ is the interest rate corresponding to $XNPV=0$ .
This function will give the result as error when

  1. Any date is not a valid date or not in a date function format.
  2. Any date is precedes the starting date.
  3. Also v and d is having different number of values.