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