XIRR Calculator: True Annualised Return on Any Cash Flows

Why XIRR Is the Only Honest Number for a Real Portfolio

Most Indian investors judge their returns with the wrong tool. They quote the absolute gain their app displays, or they divide it by the number of years to get a rough annual figure, or they trust a SIP calculator that assumes perfectly regular instalments. Each of these breaks the moment real life intrudes, and real life always intrudes.

You increase your SIP after a raise, you pause it during a tight month, you redeem a slice for an emergency, you receive a dividend on an odd date. The instant your cash flows become irregular, every simple measure becomes misleading.

This is not a rare edge case; it is the norm. Surveys of retail mutual fund behaviour consistently show that most investors alter their contributions over time, pause during downturns, and make at least one partial withdrawal over a multi-year holding. The tidy, uninterrupted SIP that a basic calculator assumes is closer to the exception than the rule. A tool that cannot handle a paused month or a mid-course top-up is therefore not describing most people’s actual investing, which is exactly the gap a flexible XIRR calculator fills.

The stakes are not trivial. An investor who trusts a flattering absolute return may hold on to a fund that has quietly stopped performing, convinced by a big lifetime gain that actually represents a mediocre annual rate. Another, frightened by a scary-looking short-term drop, may abandon a good fund whose true long-run XIRR is perfectly healthy. Getting the return metric right is not accounting pedantry; it is the difference between a good hold-or-sell decision and a costly one, repeated across every fund in a portfolio over decades.

XIRR, the extended internal rate of return, is built precisely for this messiness. It treats every transaction as a separate dated event and finds the single annual rate that reconciles all of them with your current value. Because each cash flow is weighted by exactly how long it stayed invested, an instalment made five years ago and a top-up made last month are each counted correctly.

This is not an academic nicety; it is the same money-weighted method that CAMS and KFin use to print the annualised return on your Consolidated Account Statement.

Understanding this connection is reassuring in practice. When you enter your real transactions here and see an XIRR, you are not getting some proprietary or approximate number; you are reproducing the exact calculation the official registrars run. That means you can use this tool to verify the figure on your statement, to compute the return for a holding whose statement you have mislaid, or to model a hypothetical set of flows before you commit real money, all with confidence that the method is the industry standard.

This tool is the standalone, flexible version of that calculation. It exists precisely because a single regular-SIP figure, useful as it is, cannot describe the portfolio most people actually hold. Where our mutual fund returns calculator computes XIRR for a neat regular SIP, this one lets you enter any number of arbitrary transactions, each with its own date and amount, so it handles top-ups, partial exits, dividends and skipped months that a regular-SIP tool cannot. If your portfolio is anything other than textbook-tidy, this is the calculator that tells you the truth about your return.

It is also the right tool when you are comparing two genuinely different investments. Because XIRR reduces any pattern of cash flows to a single annualised percentage, you can put a lumpy equity SIP, a one-shot property purchase with rent and a sale, and a staggered bond ladder on the same footing and rank them honestly. No other common measure lets you compare such different structures directly, which is why XIRR is the lingua franca of professional return measurement across asset classes.

The calculator also shows the naive CAGR beside your XIRR, so you can see with your own eyes how far the simple measure drifts from reality, and it delivers a verdict comparing your XIRR against the historical Nifty benchmark. That combination turns a bare percentage into an actionable judgement about whether your money is genuinely working hard enough.

One more thing worth saying plainly: XIRR does not measure the fund, it measures you. It is money-weighted, so it captures the effect of when you chose to invest and withdraw, not just how the underlying fund performed. That is a feature, not a flaw, because the return you actually experienced is the one that matters for your goals. But it means two people in the identical fund can honestly report very different XIRRs, and comparing your XIRR against the fund’s own published return is the way to see whether your timing helped or hurt.

How XIRR Is Calculated, Step by Step

XIRR looks intimidating because there is no simple formula to plug numbers into. But the idea behind it is intuitive once you see it laid out, and understanding it helps you trust the result.

Every transaction becomes a dated cash flow

Money you invest is recorded as a negative cash flow on the date you invested it, and money that comes back to you, whether a redemption, a dividend, or your current portfolio value, is a positive cash flow on its date.

A three-year SIP becomes thirty-six negative flows plus one positive flow for today’s value. A lump sum with a later top-up and a partial exit becomes two negatives and one positive, plus the final value.

This framing also makes clear why the dates matter as much as the amounts. Two portfolios that received identical rupees can have very different XIRRs purely because of when the money went in and came out. A rupee invested at a market low and sold at a high earns a far higher time-weighted rate than the same rupee invested at a high, even though both appear identical on a simple total. XIRR is the only common measure that captures this timing effect, which is precisely the effect that separates lucky or well-timed investing from the rest.

Each flow is discounted by its own time in the market

XIRR finds the annual rate that, when used to discount every cash flow back to the first date, makes them all sum to zero. A flow that stayed invested for four years is discounted over four years; one that stayed for four months is discounted over four months.

This per-flow weighting is the heart of XIRR and the reason it beats every simpler measure for irregular investing.

The rate is solved iteratively

Because the equation cannot be rearranged to isolate the rate, it is solved by iteration. This calculator uses the Newton-Raphson method, which converges quickly, with a bisection fallback that guarantees a solution even for awkward cash-flow patterns.

It is the same mathematics behind the XIRR function in Excel and Google Sheets, so the answer matches what a spreadsheet would give for the same inputs.

The result is always annualised

Whatever the length of your investment, XIRR expresses the return as a percentage per year. This makes it directly comparable across holdings of different durations: an eight-month punt and an eight-year SIP can be judged on the same scale.

It is why a small gain over a very short period can show a large XIRR, and a large gain over a very long period can show a small one, both of which are mathematically correct and genuinely informative.

A common worry is whether the iterative solving introduces error. In practice it does not. The Newton-Raphson method converges on the true rate to many decimal places within a handful of steps for ordinary cash-flow patterns, and the bisection fallback handles the rare awkward cases where Newton-Raphson might otherwise oscillate. The precision of the method vastly exceeds the precision you need for any real decision, so the only meaningful source of error is the data you feed in, never the calculation itself.

XIRR Versus CAGR, Absolute Return and Simple Averages

Choosing the right return metric matters more than getting an extra decimal place. Using the wrong one can overstate your performance by a factor of two and lead you to keep a laggard or sell a winner. Here is how the common measures relate.

The practical rule is simple. If you invested once and valued once, CAGR is fine and XIRR gives the identical answer. The moment you have more than one cash flow at different dates, CAGR breaks and XIRR becomes the only correct choice. Absolute return should never be used over periods longer than a year, and a simple average of annual returns should essentially never be used at all, because it ignores the order and size of your flows. A worked contrast makes it vivid. Suppose you invest 1 lakh, and over three years it returns plus 50 percent, minus 40 percent, then plus 30 percent. The simple average of those three yearly returns is a cheerful plus 13.3 percent, but your actual money, compounded through that sequence, grew to only about 1.17 lakh, a true annualised return closer to 5.4 percent. The simple average flatters wildly because it ignores that the 40 percent fall hit a larger base. XIRR and CAGR both capture the real compounded outcome; the simple average does not, which is why professionals never quote it. For authoritative guidance on how mutual fund returns are measured and disclosed, see the Securities and Exchange Board of India at sebi.gov.in and the Association of Mutual Funds in India at amfiindia.com.

It is worth understanding why the industry standardised on XIRR for investor statements. Regulators wanted a single, comparable, tamper-resistant number that reflected each investor’s real experience, so that a fund could not flatter its record by quoting a convenient point-to-point CAGR. Because XIRR incorporates the exact dates and sizes of every flow, it cannot be gamed by cherry-picking a start date, and it lets a saver compare a lumpy, real-world portfolio against a clean benchmark on equal terms. That regulatory preference is why the number on your statement is XIRR and why learning to read it is worth the small effort.

Common Mistakes That Distort Your XIRR

Because XIRR is only as good as its inputs, most wrong answers come from the data, not the maths. Avoiding a handful of predictable errors is what separates a trustworthy figure from a misleading one.

Getting the signs backwards

The single most common mistake is entering investments as positive and redemptions as negative, or mixing them up. Money leaving your pocket into an investment must be negative; money coming back to you, including your current value, must be positive. Reverse the signs and the XIRR comes out nonsensical or fails to solve. When in doubt, remember: a SIP instalment is always negative, your portfolio value today is always positive.

Forgetting the current value

If you have not fully exited an investment, you must include your current portfolio value as a positive cash flow dated today. Omitting it leaves the calculation with only outflows and no meaningful return to find. The current value stands in for the money you would receive if you redeemed everything now, and it is essential for any ongoing SIP or holding.

Leaving out transactions

Every top-up, every partial redemption and every dividend taken in cash is a real cash flow that changes the answer. Leaving out a mid-period redemption, for instance, makes the calculator assume that money kept compounding when it actually left, overstating your return. Pull the complete transaction list from your consolidated account statement rather than working from memory.

Reading too much into a short period

XIRR annualises whatever period you give it, so a few weeks or months of data produces extreme figures that say nothing about the future. A 5 percent gain in one month annualises to roughly 80 percent, which is real for that month but meaningless as a forecast. Only trust an XIRR computed over a reasonably long span, ideally a full market cycle, before drawing conclusions about a fund’s quality.

How to Pull the Right Cash Flows From Your Statement

An accurate XIRR starts with an accurate transaction list, and the best source is your Consolidated Account Statement from CAMS or KFin. Knowing what to copy across saves both effort and error.

Download the CAS with transaction detail

Request the detailed CAS, not the summary, from the CAMS or KFin website using your registered email and PAN. The detailed version lists every purchase, every SIP instalment, every redemption and every dividend with its exact date and amount, which is precisely what XIRR needs. The summary version shows only balances and hides the timing that makes XIRR meaningful.

Enter purchases as negatives, redemptions as positives

Copy each purchase and SIP instalment as a negative amount on its transaction date, and each redemption or dividend payout as a positive amount on its date. If a scheme is still held, add its latest value as a positive flow dated today. Do this per scheme if you want a fund-level XIRR, or combine all schemes for a portfolio-level figure, remembering that the portfolio number blends winners and losers.

Handle switches and SWPs carefully

A switch out of one fund into another appears as a redemption from the first and a purchase into the second; enter both legs on their dates. A systematic withdrawal plan is simply a series of positive redemption flows at regular intervals, each on its date. Getting these right matters because switches and SWPs are exactly the irregular events that make XIRR necessary in the first place, and skipping them quietly distorts the result.

Cross-check against the statement’s own figure

The CAS prints its own annualised return for each scheme, computed with XIRR. Once you have entered your flows, compare the calculator’s XIRR against that printed figure; a close match confirms you captured every transaction. A large gap usually means a missing flow or a wrong sign, which you can then hunt down. This cross-check is the simplest way to be confident your inputs are complete.

Three Investors and What XIRR Revealed

The gap between what an app shows and what XIRR reveals is easiest to see with real numbers. The three investors below each learned something their portfolio summary had hidden. All figures are reproducible in the tool above.

Six Ways to Read Your XIRR Correctly

The number is only as useful as your interpretation of it. These six habits separate investors who understand their real return from those who are fooled by a flattering or frightening figure.

Each is quick to apply once the instinct is built, and together they turn XIRR from a number you glance at into a genuine decision tool.

XIRR Facts Worth Remembering

Keep these reference points in mind and you can interpret any XIRR figure, whether from this tool, a fund statement or a spreadsheet, in seconds and without second-guessing the method behind it.

Practical Checklist Before You Trust an XIRR

These points double as a checklist before you trust any XIRR you are shown: confirm the signs are right, the current value is included, every transaction is present, and the period is long enough to be meaningful. Investments negative, redemptions and current value positive, nothing omitted, and at least a full market cycle of history. Run through them once and the figure you get, here or in a spreadsheet or on a statement, becomes something you can confidently act on rather than merely glance at.

Frequently Asked Questions on XIRR

Related Calculators