Find the true annualised return on your SIP or mutual fund investments. Handles any number of cash flows at irregular dates — just like Excel XIRR.
Quick Templates
Cash Flows (-ve = you paid, +ve = you received)
#
Date
Amount (₹)
Type
ⓘ Last row should be positive (current value / redemption amount)
XIRR — Annualised Return
—
Enter cash flows above to calculate
Total Invested
₹0
Current Value
₹0
Absolute Gain
0%
No. of Cash Flows
0
Period (days)
—
Iterations
—
📝 XIRR Formula (Newton-Raphson)
NPV = Σ CF_i / (1 + XIRR)^(d_i / 365) = 0
CF_i = cash flow at date i | d_i = days from first date to date i | XIRR = annualised rate Iteration: rate = rate − NPV(rate) / NPV'(rate) | Converges when |NPV| < 0.000001
🏗 Your XIRR vs Benchmarks
Cumulative Investment vs Portfolio Value Over Time
ⓘ XIRR is meaningful for periods of 1+ year. Short-period XIRR can appear extremely high or low due to annualisation. Always compare XIRR of the same fund over different periods. Negative cash flows = investments; Positive cash flows = redemptions or current value.
Frequently Asked Questions
What is XIRR and why is it used for mutual funds? +
XIRR (Extended Internal Rate of Return) is the annualised return for investments with multiple cash flows at irregular dates. SIP has many monthly outflows (investments) and one final inflow (redemption). Simple CAGR can't handle this. XIRR finds the single rate that makes NPV of all cash flows = 0. It's the most accurate return measure for SIP/MF.
How is XIRR different from CAGR? +
CAGR works for a single lump sum. XIRR works for multiple investments at different dates. For lump sum: XIRR = CAGR. For SIP: only XIRR gives the true per-year return, accounting for when each instalment was invested and how long it had to grow.
How do I enter cash flows? +
Use NEGATIVE values for money you PAY (investments). Use POSITIVE values for money you RECEIVE (redemptions, dividends). The last entry should always be positive — your current portfolio value or redemption amount. Dates must be in order from oldest to newest.
What is a good XIRR for SIP in India? +
Below 8% = underperforming FD. 8-12% = decent. 12-15% = good, broadly in line with Nifty 50 historical CAGR. 15-18% = excellent. Above 20% = very high (may be a short bull-market period). Debt fund XIRR of 6-8% is normal. Always evaluate over 3+ years.
What algorithm does XIRR use? +
XIRR uses Newton-Raphson iteration. Start with rate = 10%. Compute NPV = Σ CF_i/(1+r)^(days_i/365). Update rate = rate − NPV/NPV'. Repeat until |NPV| < 0.000001. Same as Excel's XIRR function. Typically converges in 20-50 iterations.
Why does XIRR show a very high or very low number? +
Short periods can show extreme XIRR. A 50% gain in 6 months = 125% XIRR (annualised). A -30% loss in 6 months = -51% XIRR. XIRR is most meaningful over 1+ year horizons. Also verify all cash flow signs are correct — a wrong sign can produce an extreme result.