XIRR() returns the aggregated internal
rate of return for a schedule of cash flows (that is not necessarily periodic)
represented by paired numbers in pmt and date iterated
over a number of records as defined by a
XIRR(pmt, date )
Return data type: numeric
Payments.The expression or field containing the cash flows corresponding to the payment schedule given in date.
|date||The expression or field containing the schedule of dates corresponding to the cash flow payments given in pmt.|
Examples and results:
Add the example script to your app and run it. Then add, at least, the fields listed in the results column to a sheet in your app to see the result.
LOAD 2013 as Year, * inline [
] (delimiter is '|');
LOAD Year,XIRR(Payments, Date) as XIRR2013 Resident Cashflow Group By Year;