Quick XIRR — Regular SIP
For a regular monthly SIP, enter details below. For irregular cash flows, use the manual entry table on the right.
e.g. 36 months = 3 years
Your mutual fund's current value
Results update automatically
Your XIRR
True annualised return
0%
Total Invested₹0
Current Value₹0
Absolute Gain₹0
Simple Return0%
How is XIRR Calculated?
XIRR finds the discount rate (r) that makes the Net Present Value (NPV) of all your cash flows equal to zero. Investments are negative flows (money out), and the final portfolio value is a positive flow (money in). The calculation is solved iteratively using the Newton-Raphson method.
NPV = sum of [ CF_i / (1 + XIRR)^(d_i / 365) ] = 0
CF_i = Cash flow on date i (negative for investments, positive for redemptions)
d_i = Number of days from the first transaction
XIRR = Solved iteratively using Newton-Raphson method
For a regular SIP: investments are -P each month, final value is +current_value
XIRR vs CAGR vs Absolute Return
Absolute return = (Current Value - Invested) / Invested. This ignores time and is misleading. CAGR assumes one lumpsum at the start. XIRR accounts for every SIP date — making it the most accurate metric for SIP investors. Always use XIRR to evaluate your mutual fund performance.
Frequently Asked Questions
What is XIRR and how is it different from CAGR? ⌄
CAGR assumes a single lumpsum investment at the start. XIRR (Extended Internal Rate of Return) handles multiple investments and withdrawals at different dates, giving the true annualised return. For SIPs and real-world portfolios, XIRR is always more accurate than CAGR.
What is a good XIRR for a mutual fund SIP? ⌄
A good XIRR for an equity mutual fund SIP over 5+ years is 12–18% p.a. Large-cap/Nifty index funds typically deliver 11–13% XIRR. Mid-cap and small-cap can deliver 14–18% over long periods. Anything above 20% consistently is exceptional.
Can XIRR be negative? ⌄
Yes. If your current portfolio value is less than the total amount invested (especially in a market downturn), XIRR will be negative. This is normal in the short term for equity investments.
How does XIRR handle SWP withdrawals? ⌄
Withdrawals are entered as positive cash flows (money coming to you). Investments are entered as negative cash flows (money going out). XIRR finds the rate that makes all these flows net to zero in present value terms.
Why does my XIRR differ from my app? ⌄
XIRR is solved iteratively (Newton-Raphson method) and can have multiple solutions. Small differences in the initial guess, date handling, or rounding can cause slight variations between calculators. A difference of ±0.1% is normal.