XIRR: The Only Return Number That Actually Tells the Truth

Here's a small experiment. Open your mutual fund app right now and look at the "returns" number next to your SIP. It's probably something like 14.3% or 11.8%. Now ask yourself a slightly uncomfortable question: what exactly does that number mean? It can't be a simple percentage gain because you invested money on 36 different dates, not one. It can't be CAGR because CAGR only works for a single lumpsum invested once and redeemed once. The number staring back at you is almost certainly XIRR, and it's doing something mathematically more interesting than you might think. This guide walks you through what XIRR actually measures, how our XIRR Calculator solves for it numerically, and why it's the only return metric that doesn't lie to you when your cashflows are irregular.

Fair warning: there's a tiny bit of math in this post. I'll keep it friendly. You don't need to become a quant — you just need to stop squinting at return numbers and wondering what they really mean.

What Is XIRR, Really?

XIRR stands for Extended Internal Rate of Return. The "internal rate of return" part means "the annual rate that makes the present value of all your cashflows sum to zero." The "extended" part means "and we're allowing cashflows to happen on any date, not just annual anniversaries." Put them together and you get: "the constant annualised rate that, if applied to every one of your investments for the exact time that investment was held, would produce exactly the final value you're now seeing." It's the single rate that makes the entire messy history of your investment consistent.

Why do we need this? Because real investments are messy. You SIP ₹5,000 on the 1st of every month, miss one month when your card fails, top up ₹20,000 in November as a Diwali bonus, partially redeem ₹30,000 in March for a medical emergency, and finish with ₹4.8 lakh in your folio today. What's your return? CAGR chokes on this — it assumes a single start date and single end date. XIRR handles it like it's the easiest question in the world.

How the XIRR Calculator Actually Works

XIRR has no closed-form algebraic solution. You can't just plug numbers into a formula and get the answer the way you can with simple compound interest. Instead, the calculator solves the following equation numerically:

∑ [ C_i ÷ (1 + r)^{(t_i − t₀)/365} ] = 0

Where C_i is the cashflow (positive for investments, negative for redemptions), t_i is the date of that cashflow, and r is the annualised return we're trying to find. The calculator uses the Newton-Raphson method — a numerical iteration technique that starts with a guess (usually 10%), checks how far off the equation is, adjusts the guess based on the slope of the error function, and repeats until it converges to a rate that makes the equation balance. It typically converges in 5–15 iterations. The same algorithm Excel uses. The same algorithm every SEBI-registered portfolio tracker uses under the hood.

The practical takeaway: you don't have to care about Newton-Raphson. Just enter your transactions with dates and amounts, mark investments as positive, mark redemptions (and the current portfolio value) as negative, and the calculator spits out your true annualised return.

CAGR answers "how much did your money grow, assuming you put it all in on day one?" XIRR answers "how much did each rupee actually grow for the exact time it was actually invested?" One is a fiction that simplifies the answer. The other is reality, crunched into a single number.

A Worked Example: Rehan's Two-Year SIP

Let's build intuition with a simplified case. Rehan has been SIP-ing ₹10,000/month into a flexi-cap fund for exactly 24 months. Total invested: ₹2,40,000. Current portfolio value: ₹2,85,000. What's his return?

The naive answer: absolute return

He computes (2,85,000 − 2,40,000) ÷ 2,40,000 × 100 = 18.75%. This sounds great but is meaningless without a time dimension. Is 18.75% over 24 months good? Depends on whether each rupee was invested for 24 months or less.

The slightly-better-but-still-wrong answer: CAGR

He treats it as if he invested ₹2.4 lakh on day one and it became ₹2.85 lakh in 2 years. CAGR = (2.85/2.40)^(1/2) − 1 = 8.97%. But this is wrong — he didn't invest ₹2.4 lakh on day one. He invested ₹10,000 on month 1 (which got 24 months of growth), ₹10,000 on month 2 (23 months of growth), all the way down to ₹10,000 on month 24 (0 months of growth). The actual annualised return per rupee is much higher because the average rupee was only invested for 12 months.

The right answer: XIRR

He enters 24 positive rows of ₹10,000 on their actual dates, plus one final row with today's date and −₹2,85,000 (the redemption value). The calculator computes an XIRR of roughly 17.2%. That's the true annualised rate — meaningfully higher than CAGR because each instalment was only invested for part of the period, so it had less time to generate those gains. Without XIRR, he would have dramatically understated his fund's performance.

This is why every mutual fund app in India shows you XIRR and not CAGR for SIP portfolios. CAGR would make even high-performing SIPs look mediocre, because the math would punish the early-stage weighting of cashflows.

XIRR vs CAGR vs Absolute Return — When to Use Which

• Absolute Return: Useful only as a headline number. Meaningless without the duration. "I made 40%" is only impressive if you didn't take 12 years to do it.
• CAGR: Correct and meaningful only for single lumpsum investments where you know the exact start and end. Index returns, FD returns, NAV-to-NAV fund returns are all fair CAGR use cases.
• XIRR: Correct for everything else. SIPs, portfolios with top-ups, partial redemptions, stock positions with multiple buys and sells, real estate with rental + sale proceeds. Any time money flows in or out at different dates, XIRR is the right tool.

Common Mistakes in XIRR Interpretation

• Forgetting the sign convention. Investments are positive (money going out of your pocket into the fund); redemptions and current value are negative (money coming back to you). Swap these and you'll get a completely wrong — often negative — XIRR.
• Not including current portfolio value as the final negative row. If you've not redeemed, you still need to tell the calculator what your holdings are "worth" today as a hypothetical redemption. Otherwise there's no final cashflow and the math doesn't balance.
• Comparing XIRR across different periods. A 16% XIRR over 2 years isn't comparable to an 11% XIRR over 10 years — the 10-year number is more robust because it's measured across multiple market cycles. Long-horizon XIRRs are trustworthy; short-horizon XIRRs are noisy.
• Confusing XIRR with fund NAV return. The fund's published 3-year return is usually a point-to-point CAGR of the NAV. Your XIRR can differ from this because your money went in on different dates than the measurement start date — you didn't buy at day zero.
• Using XIRR for instruments with equal, regular cashflows. For a recurring deposit with strictly equal monthly deposits and one final redemption, IRR and XIRR converge to basically the same number. XIRR is overkill for those cases, but it's still correct.

Key Terms Worth Knowing

• Cash flow: Any transaction that moves money in or out of your investment. Purchases, SIP instalments, top-ups, dividends, redemptions, and the current valuation all count.
• Sign convention: The rule that "money out of your pocket is positive, money into your pocket is negative." Getting this backwards is the #1 XIRR mistake.
• Newton-Raphson: The iterative numerical method used to solve for XIRR. You don't need to understand it — just know the calculator is using it under the hood.
• NPV (Net Present Value): The sum of all cashflows discounted back to today's value. XIRR is defined as "the rate at which NPV = 0."
• IRR: Internal Rate of Return. Same concept as XIRR but only for cashflows at regular equal intervals. Rare in practice.
• Discount rate: The rate used to bring future cashflows back to present value. XIRR is the discount rate that makes your particular set of cashflows sum to zero.
• Time-weighted return: An alternative metric that removes the effect of cashflow timing. Useful when comparing fund manager skill, but XIRR is better for measuring your actual outcome.
• Money-weighted return: Another name for IRR/XIRR — it weights returns by how much money was invested at each point in time.

How to Use Our XIRR Calculator in 30 Seconds

1. Add each investment transaction as a positive row. Type the date and the amount. SIP installments, top-ups, and bonus contributions all go here.
2. Add redemptions as negative rows. Any money that came back to you, including partial redemptions and dividend payouts.
3. Add one final negative row with today's date and the current portfolio value. This represents the hypothetical "sell everything now" number.
4. Hit Add Transaction as many times as you need. The calculator handles any number of rows.
5. Read the XIRR. Positive means you're earning a real return. Negative means you're losing money in time-adjusted terms. Compare against your fund's benchmark index over the same period to see how well you've done.

Frequently Asked Questions

Why does my broker's XIRR sometimes differ from my own calculation?

Usually because of edge cases in how transactions are accounted for — exit loads, stamp duty, dividend reinvestments auto-recorded as new purchases, or rounding in NAV prices. The differences are typically small (0.1–0.5 percentage points). If your self-computed XIRR differs by more than 1 percentage point, double-check that you've captured every single transaction, including small ones like dividend reinvestments and STT.

Can XIRR have multiple solutions?

Mathematically, yes — when cashflows change sign multiple times (invest, redeem, invest, redeem), the XIRR equation can have more than one valid rate. In practice, for most normal investor portfolios, there's only one economically meaningful answer and Newton-Raphson converges to it. The edge cases are rare enough that you can ignore them for personal finance purposes.

Is a 12% XIRR actually good for an equity mutual fund?

Context-dependent. If your benchmark (say Nifty 500 TRI) returned 14% XIRR over the same period, your 12% is lagging and you should investigate. If the benchmark returned 9%, you've handily beaten it. Always compare XIRR to a relevant index over the same cashflow timeline — absolute numbers don't tell you whether the fund manager added value.

How does XIRR treat dividends from my investments?

Dividends are just another negative cashflow (money into your pocket). Add them as negative rows on the dates you received them, and they'll be correctly factored into the XIRR calculation. If you reinvested the dividend, it's both a negative (cash in) and a positive (cash back out to buy new units) on the same date — the two cancel out, which is correct because no net money actually left or entered your personal balance sheet.

Can I use XIRR for real estate or a business investment?

Absolutely. In fact, this is one of the best use cases. Enter your down payment, construction-linked instalments, registration fees, loan EMIs, rental income, and eventual sale proceeds — XIRR will tell you what your real annualised return on the property was. Most real estate investors dramatically overestimate their returns because they only compare purchase price to sale price, ignoring holding costs, interest, and opportunity cost. XIRR forces honesty.

Does XIRR account for taxes?

Only if you enter the post-tax net amount in your redemption rows. If your last row is the gross redemption value, you'll get a pre-tax XIRR. For a true post-tax picture, subtract LTCG tax from the final redemption before entering it as a negative cashflow. Most serious investors compute both and use the post-tax number for comparing against other options like FDs (which are usually quoted post-TDS).

What does a negative XIRR actually mean in rupee terms?

It means the present value of your redemptions (plus current holdings) is less than the present value of your investments — in other words, when adjusted for time, you've lost money. A small negative XIRR (say −2%) can happen even when you got back more nominal rupees than you invested, because the time value of money makes the later returns "worth less" in present terms. A large negative XIRR correlates with an actual capital loss.

How often should I check my portfolio's XIRR?

Once or twice a year is plenty. XIRR is a long-horizon metric — short-term fluctuations make it noisy and can tempt you into bad behavioural decisions. Check it at the end of each financial year to evaluate performance, rebalance if needed, and then close the tab.

The One Thing to Take Away

XIRR is the honest answer to "what did my portfolio really return?" It accounts for every rupee, every date, every cashflow direction, and collapses the entire messy history into a single annualised number you can actually compare across investments, funds, and years. Use the XIRR Calculator once a year on each of your major portfolios — it takes five minutes, and the clarity it gives you about what's working and what isn't is worth a thousand opinion pieces.

If the number is uncomfortable, the number is still useful. It just means you have something to fix. That's also a feature, not a bug.