Manuals/calci/XIRR
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 |