Difference between revisions of "Manuals/calci/XIRR"

From ZCubes Wiki
Jump to navigation Jump to search
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 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.
 
*This function suppose at least one positive cash flow and one negative cash flow.

Revision as of 06:25, 27 February 2014

XIRR(V, Dates, G)


  • is a series of cash flows which equivalent to a schedule of payments in dates.
  • is a schedule of payment dates which equivalent to the cash flow payments.
  • 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.

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

Column1
Column2
Column3 Column4
Row1 -10000 02-01-2009
Row2 3000 04-01-2009
Row3 4300 11-30-2009
Row4 3250 03-15-2010
Row5 2200 05-01-2010
Row6 0.3593