XIRR Calculator
Finance & InvestmentCalculate XIRR for your mutual fund SIP, lumpsum, or portfolio with irregular cash flows. Get the true annualised return on any investment in seconds.
Cash Flow Entries
Enter each transaction — investments as outflows, redemptions and current portfolio value as inflows.
4 entries
XIRR (Annualised Return)
What is a XIRR?
The XIRR Calculator computes the Extended Internal Rate of Return — the true annualised return on an investment where cash flows occur at different dates and in different amounts. Every serious mutual fund investor in India needs to understand XIRR because standard returns like simple percentage gain or even CAGR fail to account for the timing of individual transactions. A ₹10,000 SIP invested over three years at irregular intervals is not the same as ₹30,000 invested as a lump sum — and XIRR captures that difference precisely.
XIRR is the rate r at which the Net Present Value of all your cash flows equals zero. Each investment outflow is negative, each redemption or the current portfolio value is positive, and the dates matter exactly. The calculation is inherently iterative — there is no algebraic shortcut — which is why having a calculator that runs the Newton-Raphson algorithm instantly is so useful.
For Indian investors, XIRR matters because most wealth is built through SIP (Systematic Investment Plans). A ₹5,000 monthly SIP over ten years involves 120 transactions on 120 different dates. The earliest instalments have compounded for ten years; the most recent barely started. Rolling up all of that into a single return figure that is comparable to a fixed deposit rate or an index benchmark is precisely what XIRR does. Platforms like Groww, Zerodha Coin, and Kuvera all report XIRR as your portfolio return because it is the only honest number.
XIRR also solves a specific Indian problem: mid-year lump sum top-ups during market dips alongside a running SIP. If you invested ₹1 lakh extra in March 2020 when markets fell 38% and your SIP continued uninterrupted, a simple average return calculation would not capture the outsized benefit of that timing. XIRR does. Similarly, if you started a SIP Calculator projection at 12% CAGR but your actual XIRR over five years is only 8%, the gap represents real underperformance worth investigating — not a rounding error.
How to use this XIRR calculator
Enter the Date of your first transaction — click the date field in the first row and select the date you made your first investment. For a running SIP, this is the date of your very first instalment.
Enter the Amount — type the investment amount in the Amount (₹) field. Always enter a positive number regardless of whether it is an investment or a return.
Set the Type to "Investment" — the Type dropdown should be set to "Investment" for every outflow (money leaving your bank account to go into the fund).
Click "+ Add Transaction" for each subsequent investment — add a new row for every SIP instalment, lump sum top-up, or additional investment. For a monthly SIP, you will have one row per month. For annual investments, you will have one per year.
Add your final row for current portfolio value — in the last row, enter today's date, your current portfolio value (from your fund statement or app), and set Type to "Return / Value". If you have made any partial redemptions, add those as separate "Return / Value" rows with their actual redemption dates and amounts.
Read the results panel — the XIRR percentage is shown prominently. Compare it against the benchmark return you expected (e.g., Nifty 50 XIRR or FD rate) and check the Total Gains and Absolute Return for the complete picture.
Formula & Methodology
XIRR finds the annualised rate r such that the Net Present Value of all cash flows discounted to the first transaction date equals zero. XIRR formula: Σ Cᵢ ÷ (1 + r)^(dᵢ − d₀) ÷ 365 = 0 Variable definitions: - Cᵢ = cash flow at transaction i (negative for investments, positive for redemptions or current value) - dᵢ = date of transaction i (in days since epoch) - d₀ = date of the first transaction (the reference date) - (dᵢ − d₀) ÷ 365 = time in years between d₀ and transaction i - r = XIRR — the annualised rate being solved for Solving method: Newton-Raphson iteration. Starting from an initial guess of r = 0.1 (10%), each iteration refines the estimate using: r₍ₙ₊₁₎ = rₙ − f(rₙ) ÷ f′(rₙ) Where f(r) is the NPV function and f′(r) is its derivative with respect to r. The iteration continues until the change in r between steps is less than 0.0000000001 (1 × 10⁻¹⁰), ensuring precision to many decimal places. Worked example: Suppose you invested ₹10,000 in a mutual fund SIP on three dates, and your current portfolio value is ₹38,000 on 13 June 2026: | Date | Cash Flow | |---|---| | 01 Jan 2023 | −₹10,000 | | 01 Jan 2024 | −₹10,000 | | 01 Jan 2025 | −₹10,000 | | 13 Jun 2026 | +₹38,000 | - Total invested: ₹30,000 - Current value: ₹38,000 - Absolute return: (₹8,000 ÷ ₹30,000) × 100 = 26.67% - Investment period: approximately 3.45 years (from 1 Jan 2023 to 13 Jun 2026) - XIRR: ≈ 9.74% p.a. (solved iteratively) The XIRR of 9.74% means your investment has grown at the equivalent of 9.74% per year compounded — far more informative than the raw 26.67% absolute return. To model what this portfolio could look like in ten more years if returns continue at a similar rate, use our CAGR Calculator to project the compounded outcome. To compare with a withdrawal strategy going forward, use the SWP Calculator to plan systematic redemptions from the same corpus. Key assumptions: - Year is defined as 365 days (no leap-year adjustment in the exponent) - All cash flows use exact calendar dates as entered - Investments (outflows) are entered as negative values internally; the UI converts "Investment" type entries to negative automatically - The calculator tries six different initial guesses to avoid local minima during Newton-Raphson convergence - XIRR is undefined if all cash flows have the same sign (all outflows or all inflows)