XIRR
Extended Internal Rate of Return — the annualised return on a series of investments and withdrawals made on different dates. The honest metric for SIP returns.
Definition
XIRR computes the annualised return for irregular cash flows — multiple investments at different times, withdrawals, dividends, etc. It is what Excel, Google Sheets, and broker statements use for SIP and SWP return calculations.
Unlike CAGR which assumes one invest-and-redeem, XIRR weights each cash flow by its actual date. A ₹10K SIP for 5 years isn't the same as a one-time ₹6L investment with the same end value — XIRR captures this difference.
Example
SIP of ₹10K/month for 5 years (₹6L total invested), ends at ₹8.5L → XIRR ≈ 14.5%. The first month's installment had 60 months of growth; the last installment had just 1 month.
Calculators that use this
XIRR
Calculate XIRR — annualised return on irregular investments and withdrawals. The standard metric for evaluating SIP returns and other timed cash flows.
Open calculatorSIP
Calculate the future value of your monthly Systematic Investment Plan (SIP) in mutual funds. See total invested, gains, and final corpus.
Open calculatorSWP
Calculate how long a mutual fund corpus lasts under a Systematic Withdrawal Plan (SWP) — fixed monthly withdrawals while the remainder keeps growing.
Open calculatorRelated terms
More Investment terms
See all 30 glossary terms or read our Methodology for how we source these definitions.