Difference between revisions of "Manuals/calci/XIRR"

Revision as of 05:25, 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. XIRR shows the error value

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

In most cases no need to provide guess

Lets see an example

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 1: / Line 1: @@
-XIRR(V, dates, G)
+<div style="font-size:30px">'''XIRR(V, Dates, G)'''</div><br/>
-*'''Where 'V' '''is a series of cash flows which equivalent to a schedule of payments in dates,
+*<math>V</math> 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
+*<math>Dates</math> 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.
+*<math>G</math> is a number that you guess is close to the result of this function.
+==Description==
 *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.