Extended Internal Rate of Return or XIRR is a technique to calculate the returns when there are several transactions being made at different time periods. XIRR can be considered your own return rate, which is the actual returns earned by your investments. It is a single rate of return which covers all your investments (and redemptions) made through every instalment of your SIP and amounts to the total value of your investment. XIRR can be calculated on an excel sheet. You can easily calculate XIRR on an excel sheet using the following command; XIRR(value, dates, guess)