Hello, I've searched this forum and the larger web and cannot seem to find a solution for my problem.
I need to run an XIRR formula across multiple investors who contributed and received distributions from a project at different times during the life of the asset. The problem is that I can't figure out how to formulate the XIRR so that, for each investor, it looks at their individual cash flows and does not start calculating the returns until the first contribution date for each individual investor.
Attached is an example. Would greatly appreciate any help!
Thanks in advance.