Manuals/calci/XIRR

Revision as of 06:47, 27 February 2014 by Abin (talk | contribs) (→‎Description)
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.
  • 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.  contain a different number of values.

Equation:  

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