XIRR Calculator
Calculate the Extended Internal Rate of Return for investments with irregular cash flows and timing.
Initial Investment
Final Value
Ready to Calculate
Add your cash flows and click "Calculate XIRR" to see your investment returns.
Investments (Outflows)
- • Money you put into the investment
- • Purchase of stocks, mutual funds, etc.
- • Additional contributions or top-ups
Returns (Inflows)
- • Money you receive from the investment
- • Sale proceeds, dividends, redemptions
- • Maturity amounts
CSV Import Format
Import your cash flows from Excel or Google Sheets. Required columns: Date, Type, Amount
2024-01-01,investment,10000,Initial Investment
2024-12-31,return,12500,Final Value
Type must be "investment" or "return". Date format: YYYY-MM-DD
XIRR vs CAGR
XIRR is used for irregular cash flows with different timing, while CAGR is for regular investments. XIRR gives you the true annualized return considering the exact timing of each cash flow.
What is XIRR and Why is it Essential?
XIRR (Extended Internal Rate of Return) is the gold standard for calculating returns on investments where transactions occur on different, irregular dates. While traditional metrics like Absolute Return or Compound Annual Growth Rate (CAGR) assume a single initial investment and a single exit date, modern real-world investing (such as Mutual Fund SIPs, periodic stock purchases, bonus investments, and partial profit booking) involves multiple cash inflows and outflows spread over time.
The Mathematical Formula Behind XIRR
XIRR solves for the internal rate of return r that satisfies the Net Present Value (NPV) equation:
Where Pi is the cash flow amount on date di, d0 is the initial transaction date, and r is the annualized rate of return (XIRR).
XIRR vs CAGR vs Absolute Return: Which One to Use?
| Metric | Best Used For | Considers Dates? | Handles Multiple Transactions? |
|---|---|---|---|
| XIRR | Mutual fund SIPs, irregular stock investments, dividend payouts, multiple withdrawals | Yes (exact calendar days) | Yes (unlimited cash flows) |
| CAGR | One-time lump sum investments held over > 1 year (e.g. FD, real estate, single stock purchase) | Only start & end year | No (assumes 1 buy, 1 sell) |
| Absolute Return | Short-term investments held for < 1 year; simple gain percentage | No | No |
Practical Example: Calculating SIP Return
Suppose you invest ₹10,000 on the 1st of January, February, and March. On December 31st of that year, your total portfolio value is ₹35,000.
- Total Invested Amount: ₹30,000 (Outflows)
- Ending Portfolio Value: ₹35,000 (Inflow on Dec 31)
- Absolute Gain: ₹5,000 (+16.67%)
- True XIRR: ~21.4% per annum (accounting for the fact that portions of your money were invested for only 10 to 12 months rather than a full year).
How to calculate XIRR online for mutual fund SIPs?
To calculate XIRR for your mutual fund SIP online, enter each monthly installment date and amount as an Investment (Outflow). Finally, enter today's date and your current total portfolio valuation as a Return (Inflow). Click "Calculate XIRR" to immediately receive your true annualized percentage return.
What is considered a good XIRR in India?
For long-term Indian equity mutual funds (over a 5 to 10-year horizon), an XIRR of 12% to 15% is considered healthy and beats inflation significantly. For hybrid or balanced advantage funds, an XIRR of 9% to 11% is typical, while debt fund XIRRs usually range between 6% and 8%.
Why is my XIRR negative even when my overall returns are positive?
XIRR heavily weights the timing of large cash flows. If you invested a modest amount early that grew well, but recently made a very large investment right before a market dip, your recent high-value purchase pulls the annualized rate negative even if your absolute total profit is green.
What is the difference between IRR and XIRR?
Standard IRR assumes that cash flows occur at uniform intervals (e.g. exactly every 30 days or once every year). XIRR allows each cash flow to take place on any specific day of the year, making it far more precise for real-world investments.
Why does Excel show #NUM! or #VALUE! for XIRR, and how does this tool fix it?
Excel's =XIRR() function errors out if cash flows do not include at least one negative and one positive number, if dates are improperly formatted, or if the internal Newton-Raphson solver fails to converge within 100 iterations. Our online XIRR calculator handles convergence with robust fallback heuristics and automatic input sanitization.
Can I import my transaction statement directly via CSV?
Yes! You can export your mutual fund transaction statement from CAMS, KFintech, Zerodha Coin, or Groww, format the columns as Date, Type, Amount, and paste or upload it directly into our CSV import tool above.