Hello everyone,
I please need your help in order to calculate the IRR of an investment at different dates (XIRR formula), the problem is that XIIR funcion allows only two columns of arguments (values and date). Data are organized as follows:
column A: dates
column B: cash outflows
column C: fair values of the investment at that date; it means that the fair values are "balance sheet" positions and do not correspond to increases/decreases of the period and at every date should be calculated the XIRR at that date (Column D), telling to the formula to consider as simulated cash collection only the fair value from last date.
Please find attached the example file.
Is there anyone that could help me?
Many thanks,
Francesco
I please need your help in order to calculate the IRR of an investment at different dates (XIRR formula), the problem is that XIIR funcion allows only two columns of arguments (values and date). Data are organized as follows:
column A: dates
column B: cash outflows
column C: fair values of the investment at that date; it means that the fair values are "balance sheet" positions and do not correspond to increases/decreases of the period and at every date should be calculated the XIRR at that date (Column D), telling to the formula to consider as simulated cash collection only the fair value from last date.
Please find attached the example file.
Is there anyone that could help me?
Many thanks,
Francesco
Attachments

8.9 KB Views: 6