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.
Heres a link to an example: https://suntexventures.box.com/s/tfil56ne61z9h8d9b0kvr3meg1g1ym76
Thanks in advance!
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.
Heres a link to an example: https://suntexventures.box.com/s/tfil56ne61z9h8d9b0kvr3meg1g1ym76
Thanks in advance!