XIRR Calculator: Calculate Mutual Fund & SIP Returns

By Wealthova | Last Updated: July 23, 2026

When you invest in a Fixed Deposit, calculating your returns is easy. You put a single sum of money in, wait a few years, and take a single sum out. But what happens when you invest in a Mutual Fund SIP, where you are depositing ₹5,000 every single month? Or when you withdraw ₹20,000 in the middle of a market crash, and then reinvest ₹50,000 when the market recovers?

Standard return formulas (like Absolute Return or CAGR) completely fail when cash flows are messy and irregular. This is where XIRR (Extended Internal Rate of Return) becomes the most important metric in an investor’s toolkit. XIRR calculates your exact, true annualized return by taking the specific date of every single transaction into account.

Use our free, interactive XIRR Calculator below to instantly track your portfolio’s performance. Simply input your investment dates (money out) and your withdrawal dates or current portfolio value (money in) to calculate your true Annualized Return.

If you are new to mutual funds, the term “Extended Internal Rate of Return” sounds incredibly intimidating. But in simple terms, XIRR is just the annualized growth rate of an investment that has multiple cash flows happening at different times.

Imagine you start a ₹10,000 monthly SIP in a Nifty 50 Index Fund for exactly one year (12 installments). Your total investment is ₹1,20,000. Let’s say at the end of the year, the portfolio is worth ₹1,30,000.

• A rookie investor might think they made a flat return on their ₹1.2 Lakhs.
• However, your first ₹10,000 installment was invested for a full 12 months, giving it time to grow. But your last ₹10,000 installment was only invested for a single month! It barely earned any return at all.

XIRR solves this problem. It assigns a specific “weight” to every single transaction based on exactly how many days that specific chunk of money stayed in the market. It calculates the individual return of every single ₹10,000 installment, aggregates them, and provides you with one single, accurate annualized percentage.

If you open Zerodha Coin, Groww, or Kuvera and look at your SIP portfolio, you will almost exclusively see XIRR prominently displayed. This is not an accident—it is mandated by market regulators.

When you invest systematically, you are deploying capital across wildly different market conditions.

• In January, you might buy mutual fund units when the Nifty is at 22,000.
• In March, the market might crash, and your SIP buys units when the Nifty is at 19,000 (getting you more units for the same price).
• In July, the market rallies, and you buy at 24,000.

Because every single month buys units at a different NAV (Net Asset Value), your overall return is a massive, blended average. Using CAGR on this portfolio is mathematically invalid because CAGR assumes all your money was invested on day one. XIRR is the only mathematical formula capable of solving this complex equation, proving exactly how hard your overall capital is working for you on a per-annum basis.

While XIRR is famous for mutual funds, savvy investors use it to calculate the true profitability of Real Estate.

When you buy a house, the cash flows are incredibly messy. You pay a large downpayment (Invest). You pay monthly EMIs (Invest). You might spend cash on renovations (Invest). But you also receive monthly rental yield (Withdraw/Return), and eventually, you sell the property for a massive lump sum (Withdraw).

By logging every EMI date and rental income date into our XIRR calculator, you can find the exact annualized return of your property. This is the only mathematically accurate way to compare if your real estate investment actually beat a standard Mutual Fund SIP!

Because XIRR relies on tracking specific transaction dates to the exact day, using Excel spreadsheets can quickly become a frustrating mess of formatting errors. Our interactive tool is custom-engineered to make this complex algorithmic math effortless. Here is how to use it:

• Step 1: Log Your Investments (Cash Outflow): Click the “+ Add Transaction” button. Select the exact date you invested the money, choose “Invest” from the dropdown menu, and enter the rupee amount. In the backend, the calculator registers this as a negative cash flow (capital leaving your bank account). Log every SIP installment or lumpsum purchase you have made.
• Step 2: Log Your Withdrawals or Current Value (Cash Inflow): If you sold mutual fund units and withdrew cash, select “Withdraw” and enter the date and amount. If you haven’t withdrawn anything but want to know your exact return today, simply enter today’s date, select “Withdraw”, and input the total current market value of your entire portfolio.
• Step 3: Analyze the Output: The moment you input at least one investment and one withdrawal/current value, the engine runs a complex Newton-Raphson iteration loop to instantly calculate your Annualized Return (XIRR). The dynamic dashboard and doughnut chart will instantly update, contrasting your hard-earned invested capital against your total market returns.

While you can technically calculate XIRR using formulas in Excel or Google Sheets, doing it manually requires perfect date formatting and a strict understanding of positive versus negative integer rules. A single misplaced minus sign will ruin the entire calculation.

Here is why our dedicated engine is the smartest way to track your true wealth:

• Eliminates Complex Spreadsheet Formatting: When building an Excel XIRR formula, you must manually remember to enter all investments as negative numbers and all withdrawals as positive numbers. Our intuitive ledger eliminates this confusion. You simply select “Invest” or “Withdraw” from the dropdown, and our backend handles all the complex algebraic sorting automatically.
• Institutional-Grade Algorithmic Accuracy: XIRR cannot be solved with a simple straight-line math equation; it requires complex, repetitive algorithmic guessing. Our JavaScript engine runs a highly advanced Newton-Raphson iteration loop that tests multiple discount rates in milliseconds. This guarantees you get the exact, pinpoint percentage used by top Indian Asset Management Companies (AMCs).
• Instant Visual Wealth Translation: A raw percentage on a screen doesn’t always tell the full emotional story of your portfolio. The moment your XIRR is calculated, our dynamic doughnut chart visually translates that percentage into absolute wealth, immediately showing you the exact visual ratio of your hard-earned invested capital versus your pure market profit.
• Built for Total Financial Chaos: The true power of this calculator is its flexibility. It effortlessly handles entirely chaotic, irregular cash flows. Whether you are tracking a scattered mutual fund SIP, random lumpsum injections during market dips, partial portfolio redemptions, or even the messy, multi-year cash flows of buying and renting out physical Real Estate, this tool processes it all flawlessly.