Calculate annualized returns for SIPs, mutual funds, stock portfolios, irregular investments, and custom cash flows using Excel-compatible XIRR methodology.
XIRR measures the annualised return of investments made on different dates. Unlike CAGR, it accounts for the exact timing of each cash flow — making it far more accurate for SIPs, lump-sum top-ups, or any irregular investment pattern.
Outflows (investments) = negative | Inflows (redemptions) = positive. Matches Excel's XIRR function exactly.
| # | Date | Cash Flow (₹) |
|---|
Enter each investment as a negative value and each redemption or maturity payout as a positive value. Dates can be in any order — the calculator sorts them automatically before computing XIRR.