02-18-2015 04:26 AM
I would like to know if it is possible to use the XIRR function on multiple investments, where each investment has its own number/range of dates and rates.
I am unsure of how to do this in SAS and hoping that someone would be willing to help me
I've attached a sketch from Excel of how my data looks like and what I am hoping to achieve. In the picture below the first row are just the variable names.
I would greatly appreciate any help.