RangeXIRR - script function

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?