Difference between revisions of "Manuals/calci/XIRR"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">XIRR(V, dates, G)</font></font>'''</font> ...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> 
+
XIRR(V, dates, G)
  
<font color="#000000">'''<font face="Arial, sans-serif"><font size="2">XIRR(V, dates, G)</font></font>'''</font>
+
*'''Where '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.
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'V' '''</font></font><font face="Arial, sans-serif"><font size="2">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 and 'G' is a number that you guess is close to the result of this function.</font></font></font>
+
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
  
</div>
+
Lets see an example
----
 
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic. </font></font></font></div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left"> 
 
 
 
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function suppose at least one positive cash flow and one negative cash flow.</font></font></font>
 
 
 
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">The numbers in dates should be valid dates. </font></font></font>
 
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">XIRR shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.</font></font></font>
 
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">In most cases no need to provide guess</font></font></font>
 
 
 
<br /><br />
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
XIRR
 
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left"> 
 
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
 
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">XIRR(V, dates, G)</font></font></font>
 
  
 +
XIRR(V, dates, G)
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B C</font></font></font>
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B C</font></font></font>
  
Line 45: Line 29:
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2200 05-01-2010</font></font></font>
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2200 05-01-2010</font></font></font>
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=XIRR(B2:B6,C2:C6,0.5) is 0.3593</nowiki></font></font></font>
+
<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU</font></font></font>
  
 
</div>
 
</div>

Revision as of 06:23, 27 February 2014

XIRR(V, dates, G)

  • Where '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

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