XIRR Calculator
Quick Presets
Cash Flows
💡 Investments are outflows (negative). Redemptions/current value are inflows (positive). The last entry should be your current portfolio value or final redemption.
Extended Internal Rate of Return
0.00%
Total Invested
₹0
Total Redeemed
₹0
Net Gain
₹0
Absolute %
0%
Duration
0 Yrs
Cash Flow Timeline
Portfolio Growth at XIRR
Cash Flow Summary
| # | Date | Type | Amount (₹) | Cum. Invested | Cum. Redeemed |
|---|
What is the XIRR Calculator?
The XIRR Calculator is a free online financial tool that calculates the Extended Internal Rate of Return on your investments. Unlike CAGR which only works for a single lumpsum investment, XIRR handles multiple cash flows at different dates — making it the ideal metric for SIP investors, mutual fund holders, and anyone with irregular investments or partial withdrawals. XIRR gives you a single annualized return rate that accounts for the exact timing and amount of each transaction. Whether you're evaluating your mutual fund SIP performance, comparing portfolio returns, or analyzing irregular investment patterns, our XIRR calculator provides instant, accurate results with visual charts and detailed breakdowns.
How Can an XIRR Calculator Help You?
- • SIP Return Tracking: Calculate the true annualized return on your monthly SIP investments, accounting for each installment's exact date and compounding effect.
- • Irregular Investment Analysis: Get accurate returns when you've made additional top-ups, partial withdrawals, or switched between funds at different times.
- • Portfolio Comparison: Compare multiple mutual funds or investment strategies on an equal annualized basis, even if contribution patterns differ.
- • Redemption Planning: Understand your actual returns before deciding when and how much to redeem from your investments.
- • Tax Planning: Know your exact returns to plan capital gains tax on equity and debt mutual fund investments.
How to Use This XIRR Calculator
- 1. Enter each cash flow — select the type (Investment or Redemption), date, and amount.
- 2. Use Quick Presets to load common scenarios (Monthly SIP, Quarterly, or Irregular).
- 3. Click "Add Row" to add more cash flows as needed.
- 4. The last entry should be your current portfolio value or final redemption amount.
- 5. Click "Calculate XIRR" to see your annualized return, charts, and detailed breakdown.
XIRR Formula
Where Cᵢ = each cash flow (negative for investments, positive for redemptions), dᵢ = date of each cash flow, d₀ = date of the first cash flow, and r = the annualized rate of return. The equation is solved iteratively using the Newton-Raphson method.
Practical Example — Monthly SIP
Scenario: You invested ₹5,000/month via SIP for 36 months (Jan 2022 – Dec 2024) in an equity mutual fund. On 1st Jan 2025, your portfolio value is ₹2,50,000.
| Detail | Value |
|---|---|
| Total Invested | ₹1,80,000 (36 × ₹5,000) |
| Final Portfolio Value | ₹2,50,000 |
| Absolute Return | ₹70,000 (38.9%) |
| XIRR | ~20.6% |
Notice: The absolute return is only 38.9%, but the XIRR is 20.6% because the later installments had less time to grow. XIRR correctly weighs each cash flow's time in the market.
Practical Example — Irregular Investments
Scenario: You made irregular investments in a stock and also withdrew partially.
| Date | Type | Amount |
|---|---|---|
| 15 Mar 2020 | Investment | ₹2,00,000 |
| 20 Sep 2020 | Investment | ₹1,00,000 |
| 10 Jun 2021 | Redemption | ₹50,000 |
| 01 Feb 2022 | Investment | ₹75,000 |
| 15 Nov 2023 | Investment | ₹50,000 |
| 01 Jan 2026 | Redemption | ₹6,00,000 |
Total Invested: ₹4,25,000 | Total Redeemed: ₹6,50,000 | Net Gain: ₹2,25,000 (52.9%). The XIRR calculates to approximately 14.8% — the true annualized return accounting for the timing of each cash flow.
CAGR vs XIRR — When to Use Which?
| Feature | CAGR | XIRR |
|---|---|---|
| Cash Flows | Single lumpsum only | Multiple, irregular |
| Date Sensitivity | Ignores intermediate dates | Every date matters |
| Best For | FD, lumpsum equity, real estate | SIP, SWP, partial redemptions |
| Accuracy | Approximate for multi-flow | Most accurate |
| Calculation | Simple formula | Iterative (Newton-Raphson) |
How to Calculate XIRR in Excel
- 1. In Column A, list all cash flow amounts. Use negative values for investments and positive values for redemptions.
- 2. In Column B, enter the corresponding dates for each transaction.
- 3. In the last row, enter your current portfolio value (positive) and today's date.
- 4. Use the formula:
=XIRR(A1:A10, B1:B10, 0.1)
The third argument (0.1) is an optional initial guess. Excel uses an iterative method similar to our calculator to find the rate. If Excel returns #NUM!, try a different guess value like 0.5 or 1.0.
Benefits of Using XIRR
- ✓ Most accurate return metric for SIP and irregular investments.
- ✓ Accounts for the exact timing of each transaction — not just start and end.
- ✓ Gives a single annualized rate making comparison easy across assets.
- ✓ Handles partial redemptions and additional top-ups correctly.
- ✓ Industry-standard metric used by financial advisors and fund managers.
Limitations of XIRR
- ✗ Assumes a single constant rate — actual returns may vary year to year.
- ✗ Can produce misleading results for very short periods (less than 1 year).
- ✗ May not converge for extreme or unusual cash flow patterns.
- ✗ Does not factor in taxes, exit loads, or expense ratios.
Why Use Our XIRR Calculator?
- • 100% free — no signup, no ads, no data collection.
- • Add unlimited cash flows with dates and amounts.
- • Quick presets for common scenarios (Monthly SIP, Quarterly, Irregular).
- • 3 visual charts — Doughnut (invested vs returns), Cash Flow Timeline, and Portfolio Growth.
- • Detailed cash flow summary table with cumulative tracking.
- • Works on mobile and desktop — fully responsive.
Frequently Asked Questions
What is XIRR?
XIRR stands for Extended Internal Rate of Return. It calculates the annualized return on investments where multiple transactions (investments and redemptions) happen at different dates. Unlike CAGR which only handles a single lumpsum, XIRR is the go-to metric for SIP investors and anyone with irregular investment patterns.
How is XIRR different from CAGR?
CAGR calculates the growth rate for a single lumpsum investment from start to finish. XIRR handles multiple cash flows at different dates, making it more accurate for SIPs where each installment has a different holding period. If you have a single investment and a single final value, use CAGR. If you have multiple transactions, always use XIRR.
Can XIRR be negative?
Yes. If your total redemptions are less than your total investments, the XIRR will be negative, indicating that your investment has lost value on an annualized basis.
Why is my XIRR different from the fund's stated returns?
Fund returns are typically shown as point-to-point CAGR of the NAV. Your personal XIRR will differ because it depends on when and how much you invested. If you invested more at higher NAVs, your XIRR will be lower than the fund's CAGR, and vice versa.
What is a good XIRR for mutual fund SIP?
For Indian equity mutual funds, a long-term SIP XIRR of 12-15% is considered good. Large-cap funds typically deliver 10-13% XIRR, while mid and small-cap funds can deliver 15-20%+ over long periods. Always compare against the benchmark index and factor in inflation (6-7%).
How to calculate XIRR for SIP in Excel?
List all SIP investments as negative values in one column and their dates in another. Add the current portfolio value as a positive value with today's date in the last row. Then use the formula: =XIRR(values_range, dates_range, 0.1). The result is your annualized SIP return.