Simeltaneous XIRR outputs with multiple inputs

[djh30]

Hello all,

I have a situation where I want to be able to calculate the XIRR of given distributions, combined with proceeds of a potential sale. In order to correctly calculate the XIRR, I have to create a new row that has all distributions to date and also the proceeds dictated by that given month. If I have 24 months of projections, this means I have to create 24 rows to see all the various XIRR outcomes for all 24 months if I want to see the outcomes all simultaneously.

Is there a formula that would allow me to calculate all XIRRs without having to create all the rows? Ideally, I would be able to show the XIRR potentially achieved in each month all on the same row.

I've attached an example that has a little more color.

Thanks in advance!

[joeu2004]

Crossposted in http://www.mrexcel.com/forum/excel-q...le-inputs.html [1]. See my response there.


-----
[1] http://www.mrexcel.com/forum/excel-questions/967634-simeltaneous-xirr-outputs-multiple-inputs.html

[djh30]

Crossposted in http://www.mrexcel.com/forum/excel-q...le-inputs.html [1]. See my response there.


-----
[1] http://www.mrexcel.com/forum/excel-questions/967634-simeltaneous-xirr-outputs-multiple-inputs.html

Thank you!