In need of support?

Support is provided on a first come, first served basis through email. Additional sources are:

  • Help and Tutorial: RulesBase includes an extensive help file and a Language Tutorial.
  • Support KnowledgeBase: the Gray Box Software website, located at www.grayboxsoftware.com maintains a knowledgebase of known issues.
  • Contact if you can not find an answer. We also welcome comments or suggestions at .

* - denotes required field

* Name:
* Phone:
* Email:
* Comments:
 

Knowledge Base

How To Merge Multiple Investments for Calculating IRRs

Published October 02, 2006

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))

Return to Knowledge Base