Difference between revisions of "Manuals/calci/XIRR"

Revision as of 05:48, 27 February 2014

XIRR(V, Dates, G)

$V$ is a series of cash flows which equivalent to a schedule of payments in dates.
$Dates$ is a schedule of payment dates which equivalent to the cash flow payments.
$G$ is a number that you guess is close to the result of this function.

This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
This function suppose at least one positive cash flow and one negative cash flow.
The numbers in dates should be valid dates.
In most cases no need to provide guess

XIRR shows the error value:

1.whenever any number in dates precedes the starting date or values 
2. $Dates$  contain a different number of values.

Equation: $\sum _{i=1}^{N}{\dfrac {P_{i}}{(1+rate)^{\tfrac {(date_{i}-date_{0})}{365}}}}=0$

XIRR(V, dates, G) B C

-10000 &!02-01-2009&!

3000 04-01-2009

4300 11-30-2009

3250 03-15-2010

2200 05-01-2010

?UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU?

Syntax

Remarks

Examples

Description

@@ Line 15: / Line 15: @@
 Equation:
-<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{date_i-date_0}{365}}=0</math>
+<math>\sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0</math>
 ==Example==