Tools

How to calculate XIRR?

XIRR meaning in mutual fund is to calculate returns on investments where there are multiple transactions taking place in different times. Full form of XIRR is Extended Internal Rate of Return.

To Calculate XIRR use XIRR function given in excel. Range of Values will be series of Cash Flow, Range of Dates will be payment dates.

=XIRR ( Range of Values , Range of Dates , Guess)

Example :- =XIRR(B6:B10,C6:C10,0.01)