RangeXIRR() returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the RangeIRR function.
Syntax:
RangeXIRR(value, date{, value, date})
Return data type: numeric
Arguments:
| Argument | Description |
|---|---|
| value | A cash flow or a series of cash flows that correspond to a schedule of payments in dates. The series of values must contain at least one positive and one negative value. |
| date | A payment date or a schedule of payment dates that corresponds to the cash flow payments. |
Limitations:
Text values, NULL values and missing values are disregarded.
All payments are discounted based on a 365-day year.
| Examples | Results |
|---|---|
|
RangeXIRR(-2500,'2008-01-01',2750,'2008-09-01') |
Returns 0.1532 |