Calculate the Extended Internal Rate of Return (XIRR) for your investments with irregular cash flows. Perfect for SIPs, mutual funds, stocks, and any investment with multiple transactions at different dates.
| # | Date | Type | Amount | Days from Start |
|---|
XIRR meaning in finance: Extended Internal Rate of Return. It is the single most accurate metric for measuring annualised returns on any investment where cash flows occur at irregular, real-world dates — which describes almost every SIP, stock portfolio, or mutual fund investment that real investors actually hold. Understanding what XIRR represents, and using our XIRR calculator to compute it precisely, is the difference between knowing your investment’s headline return and knowing your actual personal return.
The concept was first standardised as a spreadsheet function by Microsoft Excel in the 1990s and has since become the standard methodology used by mutual fund platforms, portfolio management services, and SEBI-registered investment advisors in India when reporting investor-specific returns. AMFI (Association of Mutual Funds in India) recommends XIRR as the correct method for calculating returns on SIP investments — specifically because CAGR and simple absolute return calculations fail to account for
the timing and size variation of individual cash flows.
XIRR’s core insight is that ₹10,000 invested today is not the same as ₹10,000 invested two years later — even if both go into the same fund. The earlier investment has had more time to compound. XIRR weights every cash flow by its exact date, producing a return figure that reflects when you actually deployed capital, not just how much you deployed. No other simple return metric does this correctly for irregular investments.
XIRR always expresses returns as an annualised percentage — making it directly comparable across different investment types and holding periods. Whether your SIP ran for 14 months or 7 years, the XIRR output is always expressed as a per-annum rate. This is why our tool functions as both an XIRR calculator and an annualized return calculator — the result is inherently annualised.
Monthly SIPs, quarterly top-ups, a lump sum added during a market dip, a partial redemption to fund a goal, dividends received on specific dates — XIRR handles all of these in a single calculation. You simply enter each cash flow with its exact date, and the algorithm finds the single annual rate that makes the net present value of all flows equal to zero. No other return metric is this flexible.
A mutual fund might advertise a CAGR of 18% over 5 years. But if you started SIPs in month 3, skipped a few months, added a lump sum near the peak, and partially redeemed at a low — your personal XIRR could be 11% or 22% depending on the timing. The fund’s published return is irrelevant to your actual experience. Your XIRR calculator result is the only honest answer.
The XIRR formula is rooted in the concept of Net Present Value (NPV). It finds the annualised discount rate — the XIRR — that makes the sum of all discounted cash flows equal to exactly zero. Written formally:
Σ [ CFᵢ ÷ (1 + r)^((dᵢ − d₀) / 365) ] = 0
Where: CFᵢ = Cash flow at transaction i (negative for outflows, positive for inflows) |
r = XIRR (the annual rate we’re solving for) |
dᵢ = Date of transaction i |
d₀ = Date of the first transaction (start date) |
365 = Days in a year (actual/365 day count convention)
This equation cannot be solved algebraically — there is no closed-form solution. Instead, the XIRR formula is solved numerically using the Newton-Raphson iterative method, which is exactly what our XIRR calculator runs in the background. Starting from an initial guess of 10%, the algorithm iteratively adjusts the rate until the NPV of all cash flows converges to within 0.000001 of zero — typically in 20–100 iterations, taking milliseconds.
You invested ₹10,000 on 1 January 2023 (CF₁ = −10,000),
₹10,000 on 1 July 2023 (CF₂ = −10,000, day 181), and
₹10,000 on 1 January 2024 (CF₃ = −10,000, day 365).
Your portfolio is worth ₹37,500 on 1 January 2025
(CF₄ = +37,500, day 730). Total invested: ₹30,000.
Net gain: ₹7,500 (25% absolute return).
NPV = −10,000/(1+r)^(0/365) + (−10,000)/(1+r)^(181/365) +
(−10,000)/(1+r)^(365/365) + 37,500/(1+r)^(730/365) = 0
Simplifying: −10,000 − 10,000/(1+r)^0.496 − 10,000/(1+r)^1.000 +
37,500/(1+r)^2.000 = 0
Starting guess r = 0.10 (10%): NPV ≈ −10,000 − 9,530 − 9,091 +
30,992 = +2,371. Too high — increase r. At r = 0.18: NPV ≈
−10,000 − 9,218 − 8,475 + 26,943 = −750. Between 0.10 and 0.18.
After further iterations, the algorithm converges to r ≈ 16.5%
where NPV ≈ 0. The XIRR is ~16.5% per annum —
significantly more informative than the 25% absolute return figure.
If all ₹30,000 had been invested on Day 1 (lump sum) and grew
to ₹37,500 in exactly 2 years, the CAGR would be 11.8%. But
because the second and third instalments were invested later
(with less time to grow), a higher annual rate of 16.5% is
required to explain the same ₹37,500 outcome. This is the
power of the XIRR formula — it rewards
accurate timing-aware return measurement.
Every return metric answers a slightly different question. Choosing the wrong one gives you a misleading picture of your investment performance. Here is a complete, practical guide to when each metric is appropriate — and when only an annualized return calculator using XIRR will give you the truth.
| Metric | Best For | Key Limitation | Example Use |
|---|---|---|---|
| XIRR | SIPs, any irregular cash flows, mixed investments + withdrawals | Requires actual dates; may not converge for extreme edge cases | Your personal SIP return, real estate with EMIs and rent |
| CAGR | Single lump-sum investment held to maturity | Completely ignores intermediate cash flows — wrong for SIPs | A ₹1L FD held 5 years, fund’s advertised performance |
| Absolute Return | Quick snapshot of total profit percentage | Does not account for time — 50% over 10 years vs 2 years look identical | Rough check: “Am I in profit or loss?” |
| IRR | Project cash flows with assumed equal intervals | Assumes periodic (monthly/annual) flows — inaccurate for real dates | Business capital budgeting, loan analysis |
| TWRR | Evaluating fund manager performance (ignores investor timing) | Not useful for personal investor returns — removes timing effect | Comparing two fund managers on equal footing |
Consider a real scenario: a mutual fund advertises a 5-year CAGR of 16%. An investor who ran a ₹5,000/month SIP for those 5 years invested a total of ₹3,00,000 and their portfolio is worth ₹4,85,000 today. Their absolute return is 61.7%. But neither figure answers the right question.
Running these numbers through our XIRR calculator (60 monthly investments of −₹5,000 plus a final positive cash flow of ₹4,85,000) produces an XIRR of approximately 14.2% per annum — lower than the fund’s CAGR because early SIP instalments had more time to grow, implicitly applying higher weight to their contribution. The investor didn’t achieve the fund’s 16% because SIP units were bought at varying NAVs throughout the period, some at peaks and some at troughs. XIRR reveals this reality; CAGR conceals it.
You have more than one investment transaction (any SIP), you’ve made partial withdrawals at any point, your investment dates are irregular or variable, you want to compare your personal return against a benchmark or FD rate, or you want to evaluate real estate including EMIs paid and rental income received.
XIRR should not be used to compare different fund managers’ performance (use TWRR instead, as it neutralizes investor timing), to evaluate a bond’s yield to maturity (use YTM), or when you have fewer than two cash flow dates. Also, XIRR can produce misleading results when cash flows alternate in sign more than once — a limitation shared
with all IRR-family metrics.
The XIRR calculator is the right tool for any investment situation where you have multiple transactions on different dates. Here are eight concrete scenarios — with specific guidance on how to enter the data correctly — so you get an accurate annualized return calculator result every time.
The most common use case. Enter each monthly investment as a negative cash flow with its actual debit date (not the 1st of each month unless that is your actual debit date — SIP debit dates vary by fund house). Add today’s current portfolio value as the final positive cash flow dated today. The XIRR result is your personal annualized return on
that specific fund. Run separate calculations for each fund to identify your best and worst performers on a like-for-like basis.
You invested ₹2,00,000 in March 2022, added ₹50,000 during the June 2022 market dip, and ₹75,000 more in December 2023. Your portfolio is now worth ₹4,10,000. Enter all four cash flows (three negative, one positive) with exact dates into our XIRR calculator. The result will correctly weight the benefit of buying during the dip. CAGR would be
incapable of capturing this timing advantage.
You ran a SIP for 3 years, then redeemed ₹80,000 to fund a vacation, and continued investing. Enter the redemption as a positive cash flow on the redemption date. Continue entering subsequent SIP debits as negative flows, and today’s remaining portfolio value as the final positive cash flow. XIRR handles this correctly — it accounts for the fact that ₹80,000 was returned to you early and no longer compounding in the fund.
You bought shares of three companies on different dates at different prices, sold two positions partially, and still hold the rest. Enter every buy transaction as a negative cash flow and every sell as a positive cash flow. Add the current market value of unsold holdings as a final positive cash flow dated today. The XIRR result tells you your actual annualized return across the entire portfolio — accounting for every position’s timing precisely.
Enter your down payment and each EMI as negative cash flows on their actual payment dates — you can use our Loan Calculator to get a full EMI schedule if you don’t have exact figures handy. Enter any rental income received as positive cash flows on the dates received.
For the final cash flow, enter the current market value of the property (or the sale proceeds if sold) as a positive value dated today or the sale date. The XIRR result integrates all costs and all income into a single annualized return — the only honest way to evaluate real estate performance against other asset classes.
PPF allows deposits from ₹500 to ₹1.5 lakh per year — and most investors don’t deposit the same amount every year or on the same date. Use our XIRR calculator with your actual deposit dates and amounts to verify that your effective return is matching the declared PPF interest rate of 7.1%. If you deposit late each year (after April 5th), you lose interest for that month — XIRR will quantify the exact cost of that timing error. To get a broader picture of how your PPF deposits compare against other investment vehicles, you can model projected growth using our Investment Calculator.
Unit Linked Insurance Plans involve irregular premium payments, charges in early years, and maturity or surrender values. Enter every premium as a negative cash flow and either the current fund value or any partial surrender as positive flows. XIRR will reveal the true return after all charges — often far lower than the illustrated returns in the policy document. This is one of the most revealing uses of an annualized return calculator for Indian investors.
Non-Convertible Debentures pay interest (coupons) at irregular intervals on specific dates, and return the principal at maturity. Enter the purchase price as a negative cash flow, each coupon received as a positive cash flow on its actual payment date, and the principal redemption as the final positive cash flow on the maturity date. The XIRR result
will closely match (and allow you to verify) the issuer’s stated Yield to Maturity (YTM).
Our XIRR calculator is designed to handle any number of transactions across any time period — from a simple 3-transaction test to a 10-year, 120-SIP instalment portfolio. Follow these steps to get an accurate annualized return calculator result every time.
Collect the date and amount of every investment you made — bank statement, mutual fund statement (download from CAMS or KFintech), broker ledger, or Form 26AS. You need exact dates, not approximate months. A transaction on 5 March vs 25 March makes a measurable difference in XIRR, especially over many years. Most fund platforms allow you to export a transaction statement as a PDF or Excel file.
Outflows (negative values): Every investment, purchase, premium payment, or EMI — money leaving your pocket. Enter these as negative amounts (the calculator labels them “Investment”). Inflows (positive values): Every redemption, dividend received, coupon payment, rental income, or partial withdrawal — money coming back to you. Enter these as positive amounts (the calculator labels them “Redemption”). The sign convention is critical — reversing it will produce a nonsensical XIRR.
Unless you have fully redeemed the investment, add one final row: today’s date and your current portfolio value as a positive cash flow. This represents the hypothetical “what if I redeemed everything today” scenario — it closes the calculation and makes the XIRR reflect unrealized gains alongside realized ones. Use the “Add Current Value” button which auto-fills today’s date. For a fully redeemed investment, skip this step — your final actual redemption is already in the data.
Check three things: (1) Every investment row has a negative amount.
(2) Every redemption/current value row has a positive amount.
(3) There is at least one negative and at least one positive cash flow — XIRR requires both for the equation to have a solution. A common mistake is entering all values as positive; the XIRR calculator will return an error in that case because no discount rate can make a sum of all-positive flows equal to zero.
Compare your XIRR to the benchmarks shown in the calculator: Fixed Deposit (~7%), PPF (7.1%), and Nifty 50 long-run average (~12%). An XIRR above 12% for an equity investment over 5+ years indicates above-market performance. For debt investments, an XIRR above 7–8% is generally strong. Read the detailed guidance on XIRR benchmarks in the section below — context is everything when evaluating an annualized return calculator result.
Click “Load Sample Data (SIP Example)” to see a pre-filled 12-month SIP scenario. Run the calculation and study the Cash Flow Timeline and Transactions Summary to understand exactly how inputs map to outputs. Then clear and enter your own data. The sample dataset is specifically designed to produce an XIRR in the 12–16% range
— typical for a well-performing large-cap equity fund.
After running the XIRR calculator, the most important question is: is this result good, average, or poor? The answer depends entirely on which asset class you invested in and over what period. Here is a comprehensive benchmark framework for Indian investors in 2025–26.
| Asset Class | Expected XIRR Range | Good XIRR Benchmark | Notes |
|---|---|---|---|
| Large-Cap Equity Funds | 10–14% | >12% (5+ year SIP) | Benchmark: Nifty 50 TRI ~12% long-run avg |
| Mid/Small-Cap Equity Funds | 12–18% | >15% (5+ year SIP) | Higher volatility; XIRR varies widely by entry timing |
| Flexi/Multi-Cap Funds | 11–16% | >13% | Good all-weather option; benchmark varies |
| Debt / Liquid Funds | 6–9% | >7.5% | Compare against PPF (7.1%) and FD (6.5–7.5%) |
| PPF | 7.1% (fixed) | 7.1% by definition | Late deposits (after Apr 5) reduce effective XIRR |
| Fixed Deposits | 6.5–7.5% | Match or beat PPF | Pre-tax; post-tax XIRR is ~4.5–5% in 30% bracket |
| Real Estate | 6–12% | >10% (all-in, including costs) | Must include registration, maintenance costs for honest result |
| Gold / Sovereign Gold Bonds | 7–11% | >8% (SGBs have 2.5% interest kicker) | SGBs are CGT-free at maturity — pre-tax XIRR understates value |
For an equity investment over 5+ years, an XIRR above 15% represents genuinely superior performance — above the Nifty 50 long-run average and in the top quartile of equity fund performance. This is achievable through good fund selection, consistent SIP discipline (avoiding panic exits during downturns), and fortunate entry timing. Celebrate the result but don’t project it forward — past XIRR does not guarantee future returns.
For a diversified equity SIP, this range indicates market-matching or slightly above-market performance. Most well-run large-cap and flexi-cap funds deliver in this range over 5+ year periods. If your XIRR sits here, your investment selection and behavior have been broadly sound. Ensure you are not paying excessive expense ratios (above 1.5% for equity funds) which can erode 1–2% of returns annually from the pre-expense XIRR.
For an equity investment, an XIRR below 8% over 5+ years is a red flag — you may have done better in PPF or a simple index fund. Use the XIRR calculator results to identify which funds are dragging portfolio performance and consider a structured portfolio review with a registered investment advisor. If you’re exploring gold as an alternative asset, our Gold Calculator can help you estimate returns on gold holdings as part of your broader portfolio review. Common causes: high expense ratio funds, panic redemptions during market falls (selling at lows), or selecting poorly performing categories. Use the XIRR calculator results to identify which funds are dragging portfolio performance and consider a structured portfolio review with a registered investment advisor.
A negative XIRR means you have lost money in absolute terms — your total current value plus all past redemptions is less than what you invested. This can happen in thematic or sectoral funds during prolonged downturns, in individual stocks, or in investments you made during a market peak and held for a short period. A negative XIRR is not always a reason to panic — if the investment period is short (<2 years) and the market has been in a correction, continuing the SIP during the downturn often recovers XIRR significantly.
SIP (Systematic Investment Plan) returns are one of the most misunderstood topics in personal finance in India. Every fund house and financial platform quotes CAGR for fund performance — but your personal SIP return requires an XIRR calculator to compute accurately. Here is everything you need to know.
When you invest via SIP, each monthly instalment buys units at the NAV on that specific date. Your first instalment has been invested the longest; your most recent instalment has barely had time to grow. The total value of your portfolio today is the result of hundreds of small investments, each compounding for a different duration. No single “start date” applies — so any metric that requires a single start date (CAGR, absolute return) will produce a distorted answer.
XIRR solves for the single annualized rate that simultaneously satisfies the time-weighted return on all instalments — giving you your true personal return on a per-annum basis. This is why the XIRR formula is the industry standard for SIP return calculation, endorsed by AMFI, SEBI, and every reputable financial planning certification body in India.
| Scenario | SIP Duration | Total Invested | Portfolio Value | XIRR |
|---|---|---|---|---|
| Strong Bull Market | 5 years (60 months) | ₹3,00,000 | ₹6,20,000 | ~26% |
| Average Market (typical) | 5 years | ₹3,00,000 | ₹4,85,000 | ~14.2% |
| Moderate Growth | 5 years | ₹3,00,000 | ₹4,10,000 | ~10.5% |
| Flat/Sideways Market | 5 years | ₹3,00,000 | ₹3,25,000 | ~2.9% |
| Bear Market Entry | 3 years | ₹1,80,000 | ₹1,60,000 | ~−6.8% |
Illustrative figures based on Nifty 50 TRI historical return patterns. Actual returns will vary. Past performance does not guarantee future results.
The Consolidated Account Statement (CAS) from CAMS (www.camsonline.com) or KFintech contains every SIP transaction across all your mutual funds with exact dates and amounts. Use this as your data source for the XIRR calculator — it eliminates manual data entry errors completely.
Calculate XIRR for each of your funds once a year — ideally in April when you also review your financial year. Consistent underperformance (XIRR below category average for 3+ years) is a valid reason to switch funds. Short-term XIRR fluctuations are normal and should not trigger decisions.
Your XIRR and the fund’s published CAGR measure different things. Compare your XIRR to your fund’s category average XIRR (available on platforms like Value research or Morningstar) or to a benchmark index XIRR calculated over the same dates. That is the only apples-to-apples comparison.
In mutual fund investing, XIRR meaning is your personal annualise return, calculated by accounting for the exact date and amount of every SIP instalment, lump sum, partial redemption, and dividend you received. Unlike the fund’s published CAGR (which measures the fund’s performance from a fixed start date), XIRR measures your return based on when you personally invested. Two investors in the same fund can have very different XIRR figures if they started at different times or followed different investment patterns.
The XIRR formula solves for the annualised rate r that makes the net present value of all dated cash flows equal to zero: Σ [CFᵢ / (1 + r)^((dᵢ − d₀)/365)] = 0. Since this equation has no algebraic closed form, it is solved iteratively using the Newton-Raphson method, starting from an initial guess (typically 10%) and refining until the NPV converges to near zero. Our XIRR calculator runs this algorithm automatically — identical to Excel’s =XIRR() function — and typically converges in under 100 iterations.
For equity mutual fund SIPs held for 5 or more years, an XIRR of 12–15% is considered good — it indicates performance in line with or above the Nifty 50 long-run average. An XIRR above 15% is excellent. For debt fund SIPs, 7–9% is the expected range — compare against the PPF rate (7.1%) and current FD rates as your benchmark. For short SIP periods(under 3 years), XIRR results are highly volatile and less meaningful as a long-term performance indicator.
CAGR (Compound Annual Growth Rate) calculates the annualized return from a single investment made on a single date — it requires exactly one start date and one end date. It is the right tool for evaluating a lump-sum investment or a fund’s own performance from inception. For a straightforward lump-sum or recurring deposit scenario, our Investment Calculator gives you a quick CAGR-based projection. XIRR handles any number of cash flows on any dates, making it the correct tool for SIPs, portfolios with additions and withdrawals, and any real-world investment pattern. When someone says “CAGR for SIP returns,” they are technically incorrect — the right metric and the right tool is XIRR.
Yes, XIRR can be negative. A negative XIRR means your investment is currently in a loss — the total current value of your portfolio plus any redemptions you have already received is less than the total amount you invested. This is normal for investments held for short periods during a market downturn. For a long-term SIP (5+ years), a negative XIRR is rare but can occur in severely underperforming sectors or thematic funds. A negative XIRR does not necessarily mean you should redeem — in many cases, continuing the SIP is the best response.
Yes — for a complete and honest total return calculation, dividends, interest payments, and any other income received from the investment should be included as positive cash flows on their actual receipt dates. Omitting them understates your true return. For growth-option mutual funds (where dividends are reinvested automatically), no separate entry is needed — the NAV growth already captures reinvested income. For dividend-option funds, IDCW (Income Distribution cum Capital Withdrawal) payouts should be entered as positive cash flows.
This is completely expected and is precisely what XIRR is designed to reveal. The fund’s published return measures performance from a fixed historical start date to today — it is the same for every investor regardless of when they personally invested. Your XIRR from this annualized return calculator measures your personal return based on your actual investment dates and amounts. If you invested heavily during a market high, your XIRR will be lower than the fund’s CAGR. If you had the discipline to invest more during corrections, your XIRR may exceed the fund’s stated return.
Enter each monthly SIP debit as a separate row with the exact debit date (check your bank statement) and the investment amount as a negative value. For 12 months of ₹5,000 SIP, you will have 12 rows of −5,000 with 12 different dates. Then add one final row with today’s date and your current portfolio value (from your fund’s current NAV × units held) as a positive value. Click “Calculate XIRR.” If you have a large number of transactions, use the “Load Sample Data” button first to understand the correct format, then replace with your own data.
Yes — XIRR is an annualized return metric. The output of any annualized return calculator using the XIRR method is always expressed as a per-annum percentage rate, regardless of whether your investment ran for 8 months or 8 years. This makes it directly comparable across different investment horizons and asset classes — a key reason why XIRR is considered the gold standard for personal investment return measurement. A 15% XIRR on a 2-year investment and a 15% XIRR on a 10-year investment mean the same thing: your money grew at 15% per year on a compounded, time-weighted basis.
You need a minimum of two cash flow entries: at least one negative (outflow/investment) and at least one positive (inflow/redemption or current value). Additionally, the two dates must be different — same-day cash flows create a mathematical singularity. In practice, for meaningful XIRR results, a minimum investment period of 6 months with at least 3–4 transactions is recommended. Very short periods (less than 30 days) can produce extreme annualized XIRR figures that are mathematically correct but practically meaningless.
IRR assumes cash flows occur at regular intervals (monthly, yearly). XIRR handles irregular intervals by using actual dates. Use XIRR when your investment dates are not evenly spaced.