XIRR Calculator

XIRR stands for Extended Internal Rate of Return. It is the gold standard for measuring the annualised return on investments that involve irregular cashflows. While simple returns and CAGR work well for single lumpsum investments, most real-world investment portfolios in India involve multiple transactions at different dates: monthly SIPs, occasional lumpsum top-ups, partial withdrawals, dividend reinvestments, and final redemptions. XIRR captures all of this complexity and distils it into a single annualised percentage return that accurately reflects what your money actually earned.

Technically, XIRR is the discount rate that makes the Net Present Value (NPV) of all cashflows — both inflows (investments) and outflows (redemptions and current value) — equal to zero. It is calculated using the Newton-Raphson iterative method, which converges on the precise rate through successive approximations. The formula accounts for the exact dates of each cashflow, not just the amounts, making it far more accurate than simple return calculations or even CAGR for irregular investment patterns.

Why CAGR Is Not Enough for SIP Investors

CAGR (Compound Annual Growth Rate) only works for a single investment made at a single point in time and measured at another single point. It assumes no intermediate cashflows of any kind. If you invest Rs 1 lakh and it becomes Rs 2 lakh in 5 years, CAGR correctly tells you the annualised return is 14.87%. But what if you invested Rs 1 lakh initially, added Rs 50,000 after 2 years, and withdrew Rs 30,000 after 4 years? CAGR cannot handle this real-world scenario. XIRR can, and it gives the precise annualised rate that accounts for every rupee and every date.

For SIP investors — which includes the vast majority of Indian mutual fund investors — XIRR is especially critical. Each monthly SIP instalment has a different holding period, so the returns on the first instalment (which has been invested the longest and compounded the most) are very different from the last instalment (which may have been invested for only a month). XIRR weights each cashflow correctly by its time in the market and gives you the single annualised return that accounts for all of them simultaneously.

This distinction matters enormously when evaluating portfolio performance. The Consolidated Account Statement (CAS) from CAMS or KFintech now shows XIRR for each fund and for the overall portfolio, precisely because mutual fund regulators and the industry recognise that XIRR is the only correct metric for multi-cashflow portfolios. If your fund factsheet shows a 5-year CAGR of 15% but your personal XIRR is 9%, you invested at an unfavourable time — both numbers are accurate, they just answer different questions.

How to Calculate XIRR: The Mathematics

To calculate XIRR, you need two pieces of information for each transaction: the amount and the date. Investments (money going out of your pocket) are entered as negative amounts, and redemptions or current portfolio value (money coming back to you) are entered as positive amounts. The last entry should always be the current market value of your investment with today's date, representing the hypothetical final inflow if you were to redeem everything today.

The calculator uses the Newton-Raphson method — the same approach used by Microsoft Excel's XIRR function — to find the rate r that satisfies this equation: Sum of [Cashflow_i / (1 + r)^((Date_i - Date_0) / 365)] = 0. This iterative process typically converges in 10-20 iterations to a precision of eight decimal places, giving you a highly accurate annualised return figure. The algorithm assumes 365-day year convention, consistent with the standard used by Indian mutual fund platforms and AMFI reporting.

XIRR vs IRR: An Important Technical Distinction

IRR (Internal Rate of Return) assumes cashflows occur at perfectly regular intervals — monthly, quarterly, or annually. XIRR extends this by handling cashflows at any irregular dates, which is why it has the word “Extended” in its name. For SIPs that are truly monthly with no gaps, extra investments, or withdrawal, IRR and XIRR will give nearly identical results.

In practice, however, perfect regularity is rare. Investors often miss a SIP date due to insufficient bank balance, make additional lumpsum investments after receiving bonuses, do partial withdrawals for emergencies, or have varying SIP amounts from step-up SIPs. In all these real-world cases, XIRR provides the correct annualised return while IRR would give an inaccurate answer because it assumes regularity that does not exist. This is why XIRR is universally preferred over IRR in personal finance and investment analysis.

Interpreting Your XIRR Results in Indian Context

A positive XIRR indicates your investment is generating positive real returns. For context, equity mutual fund SIPs in India have historically delivered XIRR of 12-15% over 10+ year periods on diversified large-cap and flexi-cap funds. Mid-cap and small-cap fund SIPs have delivered 14-18% XIRR historically, but with significantly higher interim volatility. Debt fund SIPs typically show 6-8% XIRR, and balanced advantage fund SIPs approximately 9-11%.

Comparing your portfolio XIRR with benchmark indices (Nifty 50 TRI CAGR or Nifty 50 SIP XIRR over the same period) tells you whether your investment choices are generating alpha or underperforming the market. Most SEBI-registered investment advisors now provide XIRR-based portfolio reports as a standard deliverable, recognising that it is the only honest measure of your personal investment performance.

Be cautious when interpreting XIRR for very short holding periods. A 3-month gain of 5% annualises to approximately 20% XIRR, which dramatically overstates the likely long-term return. Similarly, a short-term loss annualises to a very negative XIRR that overstates the long-term risk. XIRR is most meaningful and reliable for holding periods of 2 years or more, where the annualisation reflects a realistic long-term return trend rather than a short-term fluctuation.

XIRR for Real Estate and Other Illiquid Investments

XIRR is not limited to mutual funds. It is the correct measure for any investment with irregular cashflows: real estate (purchase, rental income, maintenance costs, eventual sale proceeds), direct equity stocks (multiple purchases at different times, dividend receipts, and eventual sale), portfolio management services (PMS), and even fixed deposits with partial premature withdrawals.

For real estate XIRR calculation, enter the purchase price (and all transaction costs like stamp duty, brokerage, and renovation) as the initial negative cashflow. Enter monthly rental income as positive cashflows at each receipt date. Enter maintenance and property tax payments as negative cashflows when paid. Finally, enter the current market value or sale proceeds as the terminal positive cashflow. The resulting XIRR gives you the true total return on your real estate investment, accounting for both capital appreciation and rental income — far more accurate than simply looking at purchase versus current price.

Practical Tips for Accurate XIRR Calculation

Get your exact transaction history from your Consolidated Account Statement (CAS) from CAMS or KFintech, or from your broker's transaction history. Every SIP date and NAV is recorded. Use the exact dates rather than approximating, since XIRR is sensitive to dates — a 15-day difference in a large transaction can move XIRR by 0.5-1%.

For the terminal cashflow (current value), use the end-of-day NAV on the date you are calculating XIRR. Do not use a mid-day estimated value. Most mutual fund platforms show the latest NAV-based portfolio value, which you can use directly. Recalculate your XIRR quarterly or annually to track how your returns are trending as you add more investments over time.