
XIRR essentially returns the internal rate of return (IRR) for a series of cash flows that occur at irregular intervals. See https://exceljet.net/excelfunctions/excelxirrfunction

Basically, it is the money weighted returns.
Based on the average amount of money you have invested, what is the returns you get?
Or “returns in absolute value for that year” / “average amount of money invested in that year”
How is XIRR compute and what does the number mean?
1 Like
Hi,
So what does it mean if it is a negative number?
And what does it mean if it is a positive number?
Thank you in advance.
Hi,
This means that you have a net loss.
This means that you have a net profit.