RulesBase allows the user to easily merge and sort data similar to a database. This allows multiple series of cash flows to easily be merged into new series.
Enter the following rules:
Invt A Cash Flow = -10000 | 5000 by 5
Invt A Dates = {#1/1/2007,#12/31/2007,#12/31/2008, #12/31/2009,#12/31/2010,#12/31/2011}
Invt B Cash Flow = {-12000,5000,20000}
Invt B Dates = {#3/31/07,#12/31/07,#12/31/09}
Now Merge the data together and Sort:
Merged Cash Flows = Invt A Cash Flow | Invt B Cash Flow
Merged Dates = Invt A Dates | Invt B Dates
Sorted Data = sort(Merged Dates,Merged Cash Flows)
To perform an IRR on the Merged data:
Result = irr(.1,item(2,Sorted Data), item(1,Sorted Data))