Manuals/calci/XIRR

From ZCubes Wiki
Revision as of 21:47, 24 October 2013 by MassBot1 (talk | contribs) (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> ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

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 and '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 and dates contain a different number of values.
  • In most cases no need to provide guess




XIRR


 

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

=XIRR(B2:B6,C2:C6,0.5) is 0.3593


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