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.
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 |
