The formula for calculating the XIRR is: ∑CAGR of all instalments and on Excel or Google Spreadsheet the formula is “=XIRR (cashflow amount, cashflow dates, [rate guess])”.