XIRR Calculator (2026) – SIP Returns & Mutual Fund XIRR Calculator
📈 Calculate Accurate SIP Returns – XIRR Method
XIRR Calculator – SIP & Investment Returns
Monthly SIP Amount (₹) ₹5,000
SIP Duration (Years) 10 Years
Current Portfolio Value (₹) ₹11,61,695
Your XIRR (Annual Return)
12.00%
Total Invested₹6,00,000
Current Value₹11,61,695
Total Gain₹5,61,695
Absolute Return93.62%
Your SIP earned 12.00% XIRR. This is comparable to large cap mutual fund returns.
Amount Invested vs Current Value
Invested
Gain
Enter each cash flow with date. Use negative values for investments (outflows) and positive for redemption/current value (inflow).
| # | Date (YYYY-MM-DD) | Amount (₹) — negative=investment | Action |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 |
Year-wise SIP Investment Tracker
| Year | Amount Invested | Cumulative Invested | Portfolio Value (at XIRR) | Gain |
|---|
What is XIRR? – Extended Internal Rate of Return Explained
XIRR (Extended Internal Rate of Return) is a financial metric used to calculate the annualized return of an investment that involves multiple cash flows at irregular intervals. It is the most accurate method to measure the real returns of a SIP (Systematic Investment Plan) mutual fund investment in India.
Unlike CAGR which works only for single lump sum investments, XIRR accounts for the fact that in a SIP, each monthly installment is invested at a different time and earns returns for a different duration. XIRR gives a single annualized rate that represents the true performance of your entire investment portfolio.
Why XIRR is the Best Metric for SIP Returns
- Handles irregular cash flows — each SIP installment invested at different dates
- Time-weighted accuracy — accounts for the fact that earlier installments earn returns for longer period
- Industry standard — AMFI (Association of Mutual Funds in India) uses XIRR for fund performance reporting
- Comparable across funds — allows fair comparison between different mutual funds with same investment pattern
- Works for redemptions too — can include partial redemptions (SWP) in calculation
When to Use XIRR
- Calculating returns on SIP investments in mutual funds
- Evaluating portfolio returns where investments were made at different times
- Comparing two SIP funds to find which gave better annualized returns
- Calculating returns on PPF, NPS or any instrument with monthly contributions
- Evaluating real estate returns with rental income and final sale proceeds
XIRR Formula & How It Works
XIRR finds the rate r such that the Net Present Value (NPV) of all cash flows equals zero:
∑ [Ci / (1 + r)^((di – d0)/365)] = 0
Ci = Cash flow at time i (negative for investments, positive for redemption)
di = Date of cash flow i
d0 = Date of first cash flow
r = XIRR (annual rate — the unknown we solve for)
This equation is solved iteratively using Newton-Raphson method.
Ci = Cash flow at time i (negative for investments, positive for redemption)
di = Date of cash flow i
d0 = Date of first cash flow
r = XIRR (annual rate — the unknown we solve for)
This equation is solved iteratively using Newton-Raphson method.
Simplified Understanding with Example
Suppose you invest ₹5,000/month in a SIP for 10 years (120 months) and the current value is ₹11,61,695:
- Total invested = ₹5,000 x 120 = ₹6,00,000
- Current portfolio value = ₹11,61,695
- The first ₹5,000 invested earned returns for 10 years (120 months)
- The last ₹5,000 invested earned returns for only 1 month
- XIRR finds the single annual rate that, applied to each cash flow for its specific duration, results in the observed final value
- In this case XIRR = 12% per annum
How to Use This XIRR Calculator
SIP Mode (Recommended for regular SIP):
- Enter your Monthly SIP Amount
- Enter SIP Duration in years
- Enter Current Portfolio Value from your fund statement
- Click Calculate XIRR — get instant annualized return
Manual Mode (For irregular investments):
- Enter each cash flow with its date
- Investment = negative value (e.g. -100000)
- Redemption/current value = positive value (e.g. 250000)
- Add as many rows as needed — click Calculate XIRR
XIRR vs CAGR – Key Differences
| Feature | XIRR | CAGR |
|---|---|---|
| Best for | SIP / multiple cash flows | Single lump sum investment |
| Cash flows | Multiple at different dates | One start, one end value |
| Accuracy for SIP | Very High (gold standard) | Misleading for SIP |
| Complexity | Complex (iterative calculation) | Simple formula |
| Excel function | =XIRR(values, dates) | =(FV/PV)^(1/n)-1 |
| Industry use | AMFI, mutual fund houses | Fund fact sheets (lump sum) |
| Can handle SWP | Yes | No |
Why CAGR Overestimates SIP Returns
Many investors mistakenly apply CAGR formula to SIP investments. Here is why this gives wrong results:
Example: ₹5,000/month SIP for 10 years, current value ₹11,61,695
Wrong CAGR calculation:
Total invested = ₹6,00,000. CAGR = (11,61,695/6,00,000)^(1/10) – 1 = 6.83%
This is WRONG — it assumes all ₹6 lakhs was invested from day 1.
Correct XIRR = 12.00%
XIRR accounts for the fact that money was invested gradually over 10 years.
Wrong CAGR calculation:
Total invested = ₹6,00,000. CAGR = (11,61,695/6,00,000)^(1/10) – 1 = 6.83%
This is WRONG — it assumes all ₹6 lakhs was invested from day 1.
Correct XIRR = 12.00%
XIRR accounts for the fact that money was invested gradually over 10 years.
XIRR Examples – Real SIP Mutual Fund Returns
Historical XIRR for popular SIP investments in India (approximate figures):
| Fund Category | SIP Amount | Duration | Total Invested | Current Value | Approx XIRR |
|---|---|---|---|---|---|
| Nifty 50 Index Fund | ₹5,000/mo | 10 years | ₹6,00,000 | ₹11,61,695 | ~12% |
| Large Cap Fund | ₹5,000/mo | 10 years | ₹6,00,000 | ₹12,50,000 | ~14% |
| Mid Cap Fund | ₹5,000/mo | 10 years | ₹6,00,000 | ₹15,00,000 | ~17% |
| Small Cap Fund | ₹5,000/mo | 10 years | ₹6,00,000 | ₹17,00,000 | ~20% |
| Debt Fund (STP) | ₹5,000/mo | 5 years | ₹3,00,000 | ₹3,85,000 | ~7.5% |
| ELSS Tax Saver | ₹5,000/mo | 10 years | ₹6,00,000 | ₹13,50,000 | ~15% |
*Values are approximate based on historical returns. Actual returns may vary. Past performance does not guarantee future results.
XIRR at Different Return Rates – ₹5,000/month SIP
| XIRR Rate | 5 Years Value | 10 Years Value | 15 Years Value | 20 Years Value |
|---|---|---|---|---|
| 8% (Debt Fund) | ₹3,67,752 | ₹9,19,847 | ₹17,32,985 | ₹29,64,580 |
| 10% (Balanced) | ₹3,89,616 | ₹10,32,780 | ₹20,93,565 | ₹38,28,440 |
| 12% (Large Cap) | ₹4,12,432 | ₹11,61,695 | ₹25,22,880 | ₹49,95,740 |
| 15% (Mid Cap) | ₹4,47,287 | ₹13,94,140 | ₹33,70,250 | ₹75,81,800 |
| 18% (Small Cap) | ₹4,85,070 | ₹16,78,750 | ₹45,07,000 | ₹1,15,64,200 |
What is a Good XIRR for SIP in India?
Evaluating whether your XIRR is good requires comparing it with the appropriate benchmark:
| XIRR Range | Rating | Comparable To | Action |
|---|---|---|---|
| Below 7% | Poor | Savings account / short-term FD | Review fund selection |
| 7% – 9% | Moderate | FD / Debt fund returns | Consider rebalancing to equity |
| 9% – 12% | Good | Index fund / balanced fund | Continue SIP, review annually |
| 12% – 15% | Very Good | Large cap / diversified fund | Stay invested, increase SIP amount |
| 15% – 18% | Excellent | Mid cap fund | Great performance — continue |
| Above 18% | Outstanding | Small cap / top performing fund | Watch risk — may not sustain |
Important Caveats About XIRR
- XIRR is point-in-time — changes every day as market moves
- Short duration XIRR (1-3 years) can be very misleading — equity investments need 7+ years to stabilize
- Always compare XIRR with benchmark index — a 12% XIRR in a year when Nifty gave 20% is actually poor
- Negative XIRR does not mean the fund is bad — it may just be a bad market phase
How to Calculate XIRR in Excel
You can calculate XIRR manually in Microsoft Excel or Google Sheets. Here are step-by-step instructions:
Step-by-Step XIRR in Excel:
- Step 1: Open Excel/Google Sheets. Create two columns — “Date” and “Amount”
- Step 2: Enter each investment date in Column A. Enter investment amounts as negative numbers in Column B (e.g. -5000 for monthly SIP)
- Step 3: In the last row, enter today’s date in Column A and your current portfolio value as positive number in Column B
- Step 4: In an empty cell, type: =XIRR(B1:B121, A1:A121)
- Step 5: Press Enter — Excel shows XIRR as a decimal. Multiply by 100 for percentage
Excel Formula: =XIRR(values, dates, [guess])
values = range of all cash flows (negative for investments, positive for current value)
dates = range of corresponding dates
guess = optional starting guess (default 0.1 = 10%)
Example for 10-year SIP of Rs 5,000/month:
=XIRR(B1:B121, A1:A121) where B1:B120 = -5000 and B121 = current value
values = range of all cash flows (negative for investments, positive for current value)
dates = range of corresponding dates
guess = optional starting guess (default 0.1 = 10%)
Example for 10-year SIP of Rs 5,000/month:
=XIRR(B1:B121, A1:A121) where B1:B120 = -5000 and B121 = current value
You can also use our free XIRR calculator above in “Manual Cash Flows” mode — no Excel needed!
Frequently Asked Questions – XIRR Calculator
What is XIRR?
XIRR (Extended Internal Rate of Return) is the annualized return rate for investments with multiple cash flows at different dates. It is the most accurate way to calculate SIP mutual fund returns. Unlike CAGR, XIRR accounts for the timing of each investment.
What is difference between XIRR and CAGR?
CAGR works for single lump sum only. XIRR works for multiple cash flows at different dates — perfect for SIP. For a 10-year SIP, XIRR gives the true annual return (~12%) while CAGR of total invested vs final value would give incorrect lower figure (~6.8%). Always use XIRR for SIP returns.
What is a good XIRR for SIP in India?
Good XIRR benchmarks: Index/Large cap funds 11-13%, Mid cap 14-18%, Small cap 15-22% over 10 years. Above 12% XIRR is generally considered good for equity SIP. Always compare with your fund’s benchmark index XIRR for fair evaluation.
How to calculate XIRR in Excel?
In Excel: Enter all SIP amounts as negative (-5000) in one column with dates. Enter current value as positive in last row. Use formula =XIRR(values range, dates range). Multiply result by 100 for percentage. Or use our free calculator above — no Excel needed!
Can XIRR be negative?
Yes. Negative XIRR means your portfolio value is currently less than total invested. This is common during market downturns for short investment periods. For equity SIP, negative XIRR in 1-3 years is not uncommon — stay invested for 7+ years for positive returns to materialize.
What is Nifty 50 SIP XIRR over 10 years?
Historical XIRR for Nifty 50 SIP over 10 years (2015-2025) is approximately 12-14% per annum. This is the benchmark that active large cap funds are measured against. Many active funds have struggled to consistently beat this XIRR over 10 years.