XIRR Calculator - Calculate SIP and Mutual Fund Returns (India 2026)

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

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

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, you can estimate your potential growth using our SIP Calculator, but 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 inflation-beating return" you earn on your mutual fund portfolio. It accounts for the exact date of every rupee invested, providing 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.

XIRR Example Calculation

Example: ₹10,000 invested Jan 2023 ₹10,000 invested July 2023 Current value ₹25,000. XIRR = 18.2% Explanation: Because money invested earlier grew longer.

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.
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.
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 to manage monthly income once you hit your targets.
4. Is XIRR taxable?
XIRR is just a calculation of return. Tax is applied to the actual capital gains when you redeem your units.
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.
9. Does XIRR account for inflation?
No, XIRR gives you the nominal rate of return. To find the real return, you should compare nominal 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).

Related Financial Tools

SIP Tool

Lumpsum

CAGR Tool

Inflation

SWP Tool

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.

Last Updated: March 2026