XIRR, which stands for Extended Internal Rate of Return, is a financial metric used to calculate the annualized rate of return on investments that involve irregular cash flows at non-uniform time intervals. Unlike CAGR (Compound Annual Growth Rate), which assumes a single lump sum investment, or simple IRR, which assumes equally spaced cash flows, XIRR handles real-world investment patterns where money is invested on different dates and in varying amounts.

XIRR is the industry-standard method for evaluating the performance of Systematic Investment Plans (SIPs) in mutual funds, where each monthly installment is invested on a specific date. The Association of Mutual Funds in India (AMFI) officially recommends XIRR for reporting SIP returns, making it essential knowledge for every investor.

Mathematically, XIRR solves for the annual interest rate r that makes the Net Present Value (NPV) of all cash flows equal to zero. Each investment is treated as a negative cash flow (money going out), and the final maturity or redemption amount is a positive cash flow (money coming in). The algorithm iterates until it finds the precise rate that satisfies this equation.

Understanding XIRR helps you accurately compare your SIP returns against benchmark returns, fixed deposit rates, or any other investment opportunity — all expressed on the same annualized basis, enabling truly apples-to-apples comparisons.

Our XIRR Calculator takes four key inputs from you — investment frequency, start date, maturity date, recurring investment amount, and total maturity amount — and automatically calculates your annualized return using the Newton-Raphson numerical method.

The calculator also generates a wealth projection chart comparing your cumulative investment amount against your estimated portfolio growth over time. This visual makes it intuitive to see exactly how compounding works on your investment schedule and how your wealth grows beyond the money you put in.

The XIRR formula used is identical to Microsoft Excel's XIRR() function, ensuring results that match what financial professionals use every day. You can cross-verify results between this calculator and Excel at any time.

For SIP investors, XIRR is almost always the more meaningful metric. If you invest ₹5,000 per month for 5 years and redeem ₹4,00,000, CAGR would give you a misleading picture because it doesn't account for the fact that your later investments had less time to compound than your earlier ones. XIRR correctly weighs each cash flow by its exact timing, giving you a true picture of your annualized return.

Use CAGR when comparing the growth of a single index or a lump sum mutual fund investment from one date to another. Use XIRR whenever you have multiple investment dates — which is nearly always the case for retail investors using SIPs.

Let's walk through a real example to make XIRR concrete and easy to understand.

If you calculate absolute return: (8,50,000 − 6,00,000) / 6,00,000 = 41.7%. But this doesn't tell you how this compares to other investments on an annualized basis.

Using XIRR on this cash flow schedule, the calculator solves for the annual rate that makes NPV = 0, which comes out to approximately 12.6% per year. This means your investment grew at the equivalent of 12.6% compounded annually — directly comparable to a fixed deposit, Nifty 50 index returns, or any other annual return benchmark.

This is the power of XIRR: it converts a complex series of dated cash flows into a single, intuitive annual percentage that you can act on.

XIRR should be your go-to return metric whenever your investment involves more than one cash flow. Here are the most common use cases:

Essentially, if you can't use a simple "start value → end value" formula because there are multiple deposits or withdrawals involved, XIRR is the correct tool. Most retail investors fall into this category, making XIRR one of the most practical financial metrics you can learn.