SIMPLEGENCE
← Back to All Tools
Investing Tool

XIRR Calculator

The only accurate way to measure returns on SIPs, partial withdrawals, and irregular investments

Skip to Calculator ↓

What is XIRR — and Why Every SIP Investor Needs It

Most investors look at their mutual fund app and see "returns: 15%." But is that actually their return? Not necessarily. That number is usually point-to-point CAGR — calculated as if you invested all your money on day one.

The reality with SIPs: You invest a fixed amount every month. Each instalment has a different entry date, and therefore a different number of days in the market. The last few SIP payments have barely had time to grow. Simple CAGR ignores all of this.

XIRR — Extended Internal Rate of Return — is the mathematical answer to this problem. It finds the single annual rate that, when applied to each cash flow on its actual date, makes the net present value equal to zero. In plain English: it's your personalised annualised return, accounting for exactly when each rupee entered or left your portfolio.

The rule of thumb: Investments are negative cash flows (money leaving your pocket). Redemptions and your current portfolio value are positive cash flows (money coming back to you). XIRR solves for the rate that balances them all.

When to Use XIRR vs CAGR

Scenario Use
Lumpsum — single buy, single sell CAGR
SIP — regular monthly investments XIRR
SIP + partial withdrawals XIRR
Multiple buys at different prices XIRR
Mutual fund portfolio overall return XIRR

XIRR Calculator

Choose SIP Mode for regular monthly investments, or Manual Mode for custom cash flows

Fixed amount invested each month
Month your first SIP was deducted
Total value of this investment today (NAV × units held)
Date Amount (₹) Type
How to fill this in:

Select Investment for money you put in (SIP debits, lumpsum buys). Select Redemption for money you received (partial withdrawals, full redemptions). Select Current Value for what your portfolio is worth today — enter today's date and total portfolio value as a positive amount. You need at least one Investment and one Current Value / Redemption row.

—
Extended Internal Rate of Return (XIRR)
Total Invested
—
Current Value
—
Absolute Gain
—

Benchmark: Nifty 50 index fund SIP XIRR ~ 11–13% (10-year historical)

How to Read Your XIRR

Above 15% — Excellent

Significantly outperforming the index. Usually seen in mid/small-cap heavy portfolios in bull markets. Ensure the fund's risk level matches your profile.

12–15% — Strong

Beating the Nifty 50 benchmark consistently. This is excellent long-term wealth creation for an equity SIP.

8–12% — Good

Reasonable performance — beating fixed deposits (6–7%) and inflation (5–6%). Review your fund against its category peers for further improvement.

0–8% — Moderate

Underperforming equity benchmarks. Consider whether your fund selection, investment horizon, or asset allocation needs a review.

Negative — Loss

Your portfolio is currently in the red. If you have been investing for less than 2–3 years or started near a market peak, this is not unusual — equity takes time. Review after 5+ years before making changes.

XIRR vs CAGR vs Absolute Return — Key Differences

Metric Best For Handles Multiple Flows? Time-Weighted?
Absolute Return Quick sense check No No
CAGR Lumpsum investments No Yes (simple)
XIRR SIPs, irregular cash flows Yes Yes (precise)
Pro Tip:

Mutual fund apps often show "returns" as CAGR of the NAV — not your personal XIRR. If you have been doing a SIP, the app's displayed CAGR can be significantly higher than your actual XIRR, because your early instalments are over-weighted in the CAGR calculation. Always use XIRR for your personal return.

Frequently Asked Questions

CAGR (Compound Annual Growth Rate) is for a single lump-sum investment — one entry point, one exit. It cannot handle multiple cash flows at different dates. XIRR (Extended Internal Rate of Return) handles multiple investments and withdrawals at irregular intervals. For any SIP, XIRR is the only accurate measure of your actual return. CAGR on a SIP would overstate your real returns because it ignores that most of your money was invested recently, not from day one. If you invest ₹5,000/month for 5 years, only your very first SIP instalment has had 5 full years to compound — the rest have had less. XIRR accounts for this precisely.
Mutual fund returns (1Y/3Y/5Y) are point-to-point or rolling CAGR — they assume you invested a lumpsum on exactly that date. Your SIP XIRR is personalised — it reflects when you actually invested each instalment. If you invested more during a market peak, your XIRR will be lower than the fund's stated CAGR. This is normal and is actually the correct picture of your wealth creation. The fund's CAGR tells you how the fund performed; your XIRR tells you how you performed as an investor in that fund.
In Zerodha Coin: Go to Portfolio — XIRR is shown for each fund and overall. In Groww: Portfolio page shows "Returns %" which is XIRR. In MF Central (mfcentral.com): download the consolidated account statement (CAS) — the returns shown are XIRR. In Value Research Online: upload your CAS and it computes XIRR per fund and total portfolio. The Simplegence XIRR Calculator gives the same result when you input the same cash flows — useful when you want to verify or compute XIRR across platforms.
Enter today's total portfolio value (or redemption value) as a positive cash flow with today's date. This is what your investments are worth right now — the NAV × units you hold. You can find this in your broker's portfolio page, NSDL/CDSL CAS, or directly from the AMC's website. If you've already fully redeemed, enter the redemption amount and the redemption date instead of current value. If you've made multiple partial redemptions over time, enter each one on its respective date in Manual Mode.
As a benchmark: Nifty 50 index funds have delivered approximately 11–13% XIRR for 10-year SIPs historically. An XIRR above 12% means you're beating the index — strong performance. 8–12% is good (beats fixed deposits at 6–7% and inflation at 5–6%). Below 8% suggests the fund may be underperforming — review your fund selection against its category average. Negative XIRR is expected in the first 1–2 years during a market downturn; judge equity SIP performance only after 5+ years of consistent investment.