Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

To calculate XIRR, enter details of all SIP purchases and the current value or the redemption value along with the date in the Excel columns. Make sure the dates are on the left side, while the ...