XIRR Calculator India – SIP, Mutual Fund & Portfolio Returns

Calculate the actual annualized returns of your SIPs and lumpsum investments, even with irregular cash flows. XIRR is the gold standard for measuring mutual fund performance accurately.

Transaction List

Calculated Performance

0%

Annualized Rate

Stable Convergence

Investment Summary

Total Invested

₹0

Absolute Profit

₹0

Enter your transaction dates and amounts. Use negative values for investments/outflows and positive values for current value/redemptions.

Cash Flow Visualization

How to use this XIRR Calculator

  1. Enter all investment dates as per your account statement.
  2. Enter investment amounts (use negative values like -1000).
  3. Enter current portfolio value as a positive number with today's date.
  4. Click Calculate to see your annualized returns.

This calculator uses standard financial formulas used in investment analysis and mutual fund return calculation.

How to Calculate XIRR in Excel

While our tool is instant, you can also calculate this in a spreadsheet using the built-in formula:

=XIRR(values, dates, [guess])
  • Values: A series of cash flows that correspond to a schedule of payments in dates. (e.g., A2:A10)
  • Dates: A schedule of payment dates that corresponds to the cash flow payments. (e.g., B2:B10)

Example: In column A, put -10000 on 01-Jan-2024 and in cell A2 put 12000 on 01-Jan-2025. Cell A3 formula =XIRR(A1:A2, B1:B2) will return 20%.

What is a Good XIRR in India?

The definition of a "good" return depends on your asset class and the prevailing Inflation rate. In 2026, here are the benchmarks for Indian investors:

10–12% (Average)

Standard large-cap index returns or conservative hybrid funds.

12–15% (Good)

Target range for diversified SIP portfolios in equity funds.

15%+ (Excellent)

Top-tier small-cap or sectoral fund performance over 5+ years.

XIRR vs Absolute Return

Absolute return only calculates the point-to-point gain, completely ignoring the time factor. This makes it highly misleading for SIP investments.

  • Absolute Return: If you invest ₹1 Lakh and it becomes ₹1.2 Lakh, your absolute return is 20%, whether it took 1 year or 10 years.
  • XIRR: In the same example, if it took 1 year, XIRR is 20%. If it took 10 years, XIRR is only 1.84%.

Always use XIRR to ensure your money is growing faster than the inflation rate. For simple one-time investments, you can also use our CAGR Calculator.

What is XIRR?

XIRR (Extended Internal Rate of Return) is a method used to calculate the annualized rate of return for a series of cash flows occurring at irregular intervals. If you invest monthly through SIPs, XIRR is the only way to track actual performance when your timing varies.

While CAGR is great for point-to-point lump sum investments, it fails when you have multiple investments or partial withdrawals. In the Indian context, XIRR is the actual "personal return" you earn on your mutual fund portfolio. It provides a clear comparison against the rates from our Inflation Calculator.

XIRR vs CAGR: Which to use?

Use XIRR When:

  • You have a monthly SIP or SWP Plan.
  • You make occasional lump sum top-ups.
  • You have withdrawn some money partially.
  • You receive dividends at irregular dates.

Use CAGR When:

  • You made a one-time Lumpsum Investment.
  • You want to see simple point-to-point growth.
  • There are no intermediate cash flows.

XIRR Formula

XIRR solves for 'r' in the following Net Present Value (NPV) equation:

0 = Σ [CFi / (1 + r)(di - d0) / 365]

CFi: Cashflow amount | r: Annualized rate | di: Transaction date | d0: First date

Track long-term growth for one-time buys with our Lumpsum Calculator to see how CAGR differs from your personalized XIRR result.

XIRR Example Calculation (Real SIP Example)

Let us understand XIRR with a practical mutual fund SIP example.

  • Investment 1: ₹10,000 on Jan 2023
  • Investment 2: ₹10,000 on July 2023
  • Total invested: ₹20,000
  • Portfolio value in Jan 2025: ₹25,000

Because the first investment stayed invested longer than the second, returns are not equal. XIRR adjusts for this timing difference.

Result: XIRR = 18.2%

This means your portfolio generated an annualized return of 18.2%. Compare this with simple growth in our CAGR Calculator.

Frequently Asked Questions (XIRR)

1. Why is XIRR used for SIPs?
Because each SIP installment stays in the market for a different amount of time. XIRR normalizes these time differences into a single annual percentage. Use a SIP calculator to plan future goals.
2. Can XIRR be negative?
Yes, if the current value of your investment is lower than the total amount you invested, your XIRR will be negative. This represents a reduction in your net worth.
3. What is a good XIRR in India?
For long-term equity mutual fund investments (7-10 years), an XIRR of 12-15% is considered strong. Planning for retirement? Use our SWP Calculator for monthly income strategy.
4. Is XIRR taxable?
XIRR is just a calculation of return. Tax is applied to the actual capital gains when you redeem your units. Check your Income Tax liability for details.
5. How does XIRR handle withdrawals?
Withdrawals are treated as positive cash flows in the XIRR equation, as they represent value coming back to you.
6. Does XIRR include dividends?
Yes, you should include any dividends received as positive cash flows on the date you received them to calculate accurate XIRR.
7. Why is my XIRR different from fund returns?
The fund return is its point-to-point growth. Your XIRR depends on the *timing* of your investments. If you invested more when the market was low, your XIRR will be higher than the fund's CAGR.
8. What is the difference between XIRR and IRR?
IRR assumes cash flows happen at fixed intervals (e.g., exactly every 30 days). XIRR allows for specific, irregular dates common in real-world investing.
9. Does XIRR account for inflation?
No, XIRR gives you the nominal rate of return. To find the real return, compare returns against our Inflation Calculator findings.
10. Can I calculate XIRR for my whole portfolio?
Yes, just treat your initial investment and all subsequent buys as outflows (negative) and the total current portfolio value as an inflow (positive). Track total wealth using our Net Worth Tool.

Related Financial Tools

SIP Tool

Lumpsum

CAGR Tool

Inflation

SWP Tool

Net Worth

Retirement

Disclaimer

Estimated results for educational purposes only. XIRR is calculated based on mathematical models and may vary slightly from bank/broker statements. Mutual fund investments are subject to market risks. Please consult a SEBI registered financial advisor for personalized advice.

Last Updated: April 2026