What Is XIRR? Formula, Meaning and How to Calculate It

XIRR stands for Extended Internal Rate of Return. It is the single, annualized rate of return that  if applied to every individual cash flow in an investment, on the exact date each one occurred  would make the present value of all those cash flows net out to the final portfolio value. In plainer terms: it's the one number that answers "what annual return did my money actually earn, given exactly when I put it in and took it out?"

That distinction  my money, at the exact dates I moved it  is what separates XIRR from almost every other return metric an investor encounters. A mutual fund's published NAV growth, a PMS strategy's headline return, or a simple percentage gain all describe how an investment performed. XIRR describes how an investor's actual cash flows performed, which can be meaningfully different once you're making a SIP, adding lump sums, or receiving PMS/AIF distributions at irregular points in time.

XIRR is a variant of the older, more general concept of Internal Rate of Return (IRR), adapted specifically to handle cash flows that don't arrive on a neat, evenly spaced schedule  which describes almost every real personal investment portfolio.

Classic return calculations assume tidy conditions: one investment made on day one, one withdrawal at the end, or  for IRR specifically  cash flows spaced exactly one period apart (say, every twelve months). Real investing rarely looks like that.

Consider a typical Indian investor's year: a SIP debited on the 5th of every month, an extra lump sum invested when a bonus arrives in March, a partial redemption in August for a planned expense, and  for someone investing through a PMS or AIF  capital called in tranches over several months and distributions paid out whenever the fund realizes gains. None of these cash flows are evenly spaced, and none are the same size. A simple percentage-gain calculation or a standard IRR formula can't handle this cleanly.

XIRR was built to solve exactly this problem. Because it works off actual calendar dates rather than assumed periods, it can absorb any number of deposits and withdrawals, of any size, on any date, and still produce one coherent annualized return figure. This is precisely why it became the default "your returns" number shown by mutual fund platforms, brokerages, and portfolio trackers once SIP-based and app-based investing became the norm in India.

At its core, XIRR finds the discount rate, r, that satisfies this equation:

0 = Σ [ CFᵢ / (1 + r)^((dᵢ − d₀) / 365) ]

Where:

• CFᵢ is each individual cash flow (negative for money invested, positive for money received/withdrawn)
• dᵢ is the actual calendar date of that cash flow
• d₀ is the date of the first cash flow
• r is the XIRR  the value being solved for

Unlike a simple algebraic formula, this equation generally can't be solved directly  it has to be solved iteratively, by testing different values of r until the equation balances to (approximately) zero. This is exactly why it is almost never calculated by hand: spreadsheet software and financial platforms use numerical methods (commonly a Newton-Raphson-style iteration) to converge on the answer in a fraction of a second. In Excel and Google Sheets, this happens automatically inside the built-in XIRR() function.

Two conditions are required for XIRR to be calculable: there must be at least one negative cash flow (money going out of your pocket, into the investment) and at least one positive cash flow (money coming back to you, including the current/final value of what you still hold).

You don't need to solve the iterative equation yourself  both major spreadsheet tools do it for you.

• List every cash flow in one column (negative for investments, positive for withdrawals/current value) and the corresponding dates in an adjacent column.
• In an empty cell, enter: =XIRR(values, dates)  referencing the two ranges.
• Press Enter. Excel returns the annualized rate as a decimal (format the cell as a percentage).

Microsoft's own documentation confirms the function requires at least one positive and one negative value, and that dates must be entered as valid Excel dates  text dates will cause errors.

The process is nearly identical, since Google Sheets implements the same function per Google's own XIRR documentation: =XIRR(cashflow_amounts, cashflow_dates, [rate_guess]). The optional third argument lets you supply a starting guess if the default iteration fails to converge  useful for portfolios with a large number of transactions or unusual cash-flow patterns.

A common pitfall in both tools: if your final "cash flow" doesn't include the current market value of what you still hold (not just money you've actually withdrawn), your XIRR will be meaningless  the calculation needs to treat your current holding value as if you "received" it on today's date.

CAGR (Compound Annual Growth Rate) answers a narrower question: if you invested one lump sum and let it compound smoothly with no additional investments or withdrawals, what annual growth rate got you from the starting value to the ending value? CAGR is clean and easy to compute  (Ending Value / Beginning Value)^(1/Years) − 1  precisely because it assumes there's only one cash flow in and one cash flow out.

That assumption is CAGR's biggest limitation: the moment you add a second cash flow  a top-up, a SIP installment, a partial withdrawal  CAGR can no longer accurately represent your return, because it has no mechanism for weighing cash flows by timing.

The practical rule: use CAGR only when you made a genuine single lump-sum investment and haven't touched it since. The moment your portfolio has more than one transaction, XIRR is the metric that actually reflects your experience.

XIRR and IRR solve the same underlying equation  they're both trying to find the discount rate that makes a series of cash flows net to zero. The difference is entirely about timing assumptions.

Standard IRR assumes cash flows occur at regular, evenly spaced intervals (annually, in most financial models) and doesn't require actual dates  just a sequence of values. XIRR requires an actual calendar date for every cash flow, and uses those real dates  including irregular gaps and stub periods  in its calculation.

For personal investing, where contributions rarely land on a perfectly even schedule, XIRR is almost always the more accurate choice. In financial modeling and corporate finance, where cash-flow schedules are often genuinely periodic by design (like an annual dividend model), plain IRR remains common. Real-estate and private-equity practitioners frequently find the two produce materially different answers on the same underlying deal  an outcome driven purely by exactly when cash actually moved, not by any difference in the investment itself.

Absolute return is the simplest metric of all: (Current Value − Invested Amount) / Invested Amount × 100. It tells you your total percentage gain, but it says nothing about how long it took to get there.

A 20% absolute return earned in 8 months is a very different outcome from a 20% absolute return earned over 4 years  but stated as a bare percentage, they look identical. This is precisely the gap XIRR closes: it annualizes the return, so a fast 20% gain shows a much higher XIRR than a slow one, letting you compare investments held for genuinely different durations on equal footing. Absolute return is only a fair comparison tool when the holding periods being compared are identical; the moment durations differ, it stops being useful and XIRR becomes necessary  a point Forbes Advisor India also flags for retail mutual fund investors comparing schemes held for different lengths of time.

This is the comparison that matters most if you invest  or are considering investing  in a PMS or AIF, and it's the one piece of the XIRR puzzle that most mutual-fund-focused explainers skip entirely.

TWRR (Time-Weighted Rate of Return) measures the return of the underlying strategy itself, treating it as if a single rupee were invested at the start and left completely untouched  it deliberately removes the effect of when money entered or left the portfolio. XIRR does the opposite: it's built specifically to capture the effect of your personal cash-flow timing.

Here's why this distinction isn't academic: under the SEBI (Portfolio Managers) Regulations, 2020, portfolio managers are required to report their strategy-level performance using TWRR, not XIRR  precisely so that a manager's reported skill can't be flattered (or unfairly punished) by the accident of when individual clients happened to add or withdraw money. Two investors in the exact same PMS strategy, invested on different dates or in different tranches, can end up with noticeably different personal XIRRs even though the strategy's TWRR  its actual, manager-attributable performance  is identical for both of them.

This is also relevant to AIFs, which operate under the SEBI (Alternative Investment Funds) Regulations, 2012. AIF capital is typically drawn down in tranches over months or years (rather than invested as one lump sum) and distributed back to investors as underlying assets are realized  a cash-flow pattern that makes XIRR, not a simple percentage gain, the only sensible way for an individual investor to track their own return.

The takeaway for PMS/AIF investors: use TWRR figures (as reported by the manager) to evaluate whether a strategy itself is performing well, and use your own XIRR to track how well your personal entries and exits into that strategy have gone. Confusing the two  for instance, assuming a manager underperformed because your personal XIRR looks weak  is one of the most common and costly misreadings in PMS/AIF investing. It's exactly the kind of reconciliation that a consolidated tracking platform, rather than manual spreadsheet work across multiple PMS statements, is built to get right.

There's no single universal benchmark, because "good" depends on the asset class, the time period, and what you're comparing against  but a few grounding principles hold across contexts:

• Compare like with like. A good XIRR for an equity-oriented PMS strategy should be judged against equity benchmarks and equity peer strategies, not against a debt fund's typical range, and vice versa.
• Longer periods matter more than short bursts. A high XIRR measured over three months can reflect a temporary rally rather than durable skill; it becomes more meaningful as a performance signal the longer the measurement window (generally 3–5 years or more).
• It should outpace inflation. At minimum, a "good" XIRR needs to comfortably exceed India's prevailing inflation rate  otherwise the investment isn't building real, inflation-adjusted wealth even if the nominal number looks positive.
• For PMS/AIF specifically, compare your personal XIRR against the strategy's own TWRR for the same period, as discussed above  a large, persistent gap between the two is worth investigating (it usually means the timing of your contributions, not the manager, is driving the difference).

Rather than chasing a single magic number, the more useful question is: is my XIRR beating a relevant benchmark, over a long enough period, after accounting for the risk I took to get there?

XIRR is powerful, but it isn't a perfect or complete measure of investment quality, and treating it as one can lead to bad decisions.

It reflects your behavior as much as the investment's performance. Because XIRR is so sensitive to cash-flow timing, an investor who got lucky with entry timing can show a flattering number on a mediocre strategy, while an investor who added a large sum right before a downturn can show a poor one on a genuinely strong strategy. This is the same underlying reason SEBI mandates TWRR, not XIRR, for portfolio-manager performance reporting.

Short-period and unusual-transaction distortion. A very short measurement window, or one dominated by a single unusually large cash flow near the end, can produce an annualized figure that looks dramatically higher or lower than the investment's genuine long-run character.

Garbage in, garbage out. XIRR is calculated iteratively from every date and amount you feed it  a single mistyped date or omitted transaction (a common risk when manually reconciling statements from multiple PMS or AIF managers in a spreadsheet) can silently distort the entire result, and because there's no simple formula to sanity-check by eye, these errors are easy to miss.

It doesn't measure risk. Two portfolios can post an identical XIRR while one took on dramatically more volatility or concentration risk to get there. It should always be read alongside a genuine risk assessment, not in isolation.

Everything above explains why XIRR is the right lens for tracking your personal returns  and also why it's genuinely hard to get right once you're investing across more than one PMS or AIF. Every manager sends a different statement, on a different cycle, in a different format; capital calls, drawdowns, and distributions land on different dates across strategies; and reconciling all of it into one honest, consolidated XIRR by hand is exactly the kind of error-prone spreadsheet work most investors don't have time for.

That's the problem PMS Sahi Hai, India's AI-powered PMS & AIF marketplace and its AI wealth assistant, Nyra, are built to solve. Instead of manually collecting transaction data from every manager's statement, Nyra pulls it together automatically and keeps a single, continuously updated XIRR across your entire PMS and AIF portfolio  not just one strategy at a time. Because Nyra also maps overlap and concentration across your holdings, it pairs your XIRR with the context that a bare percentage can't give you: whether the return you're seeing is coming from genuine diversification and manager skill, or from concentrated bets you may not have realized you were making.

Nyra's process is built around five steps: understanding your profile and goals, analyzing your existing portfolio for hidden overlap and concentration, matching you to a curated shortlist from 1,000+ tracked PMS and AIF strategies, enabling smart investing directly through the platform, and then providing continuous monitoring  including the rebalancing alerts that turn a static XIRR number into an ongoing, actionable view of your wealth. You can explore how PMS and AIF structures themselves work on PMS Sahi Hai's What is PMS and What is AIF pages, or go straight to comparing live strategies on the PMS comparison tool.

XIRR is the closest thing to a true, personal scorecard for your investing  but only if it's calculated correctly, across every holding, with every transaction accounted for. If you're managing SIPs, a PMS, or an AIF (or all three) and aren't confident your consolidated return picture is accurate, that's exactly what PMS Sahi Hai's Nyra was built to fix. Start with Nyra to see your real, consolidated XIRR  and the hidden overlaps and risks a bare percentage never shows you.