
Most investors judge a fund by one number: the return it has generated. But with alternative investment funds, that number depends entirely on which formula was used to arrive at it, and the two most common ones, XIRR and CAGR, can tell very different stories about the same fund.
XIRR (Extended Internal Rate of Return) calculates annualized return for cash flows that occur at irregular dates. CAGR (Compound Annual Growth Rate) calculates annualized return assuming a single lump sum invested at the start and withdrawn at the end. The distinction matters more in AIFs than almost anywhere else in the investing world.
Why Don't AIFs Behave Like a Lump-Sum Investment?
A mutual fund SIP has one entry pattern. A stock purchase has one entry date and, usually, one exit. An AIF has neither.
When an investor commits ₹1 crore to a Category I AIF, that money isn't deployed on day one. It moves in tranches, called capital calls, spread across 18 to 36 months as the fund manager identifies and closes deals. Returns come back the same way: partial exits, dividend distributions, and final proceeds arrive at different points across the fund's life, not as one lump sum at maturity.
This is precisely the kind of cash flow pattern CAGR was never built to handle.
CAGR = (Ending Value / Beginning Value)^(1/n) − 1
where n is the number of years.
CAGR works cleanly when there's one investment date and one exit date. Buy a stock at ₹100, sell it three years later at ₹150, and CAGR tells you the fund grew at roughly 14.5% a year. Clean, accurate, done.
Apply the same formula to an AIF, and it falls apart. If an investor's ₹1 crore commitment was drawn down as ₹25 lakh in year one, ₹40 lakh in year two, and ₹35 lakh in year three, CAGR has no way to account for the fact that some of that capital was working for three years while some was working for barely a few months.
It treats the entire ₹1 crore as if it were invested on day one, which understates the fund's actual efficiency at deploying and returning capital. Take a stock trade: buy at ₹100, sell three years later at ₹150, and CAGR puts the annual growth at roughly 14.5%. One entry, one exit, nothing complicated about it.
An AIF doesn't play by those rules. XIRR, or Extended Internal Rate of Return, works out annualized return for cash flows landing on irregular dates. CAGR, or Compound Annual Growth Rate, assumes something simpler: one lump sum going in at the start and one coming out at the end. It treats the full ₹1 crore as though it all went in on day one, and in doing so, quietly understates how efficiently the fund actually deployed and returned money.
XIRR solves this by treating every capital call as a cash outflow and every distribution as a cash inflow, each tagged with its actual date.XIRR closes that gap by treating every capital call as money going out and every distribution as money coming back, each one dated to when it actually happened. It then computes the single annualized rate that makes the net present value of all these cash flows equal to zero.
There's no clean algebraic formula for XIRR the way there is for CAGR. It's solved iteratively, which is why every AIF factsheet, fund administrator platform, and even a basic spreadsheet calculates it rather than deriving it by hand.
A Working Example
Consider an investor with the following cash flow pattern in a Category I AIF:
Total invested: ₹1 crore. Total returned: ₹1.55 crore. A simple "1.55x return" headline sounds identical whether that money took two years or five years to come back, and that's exactly the gap XIRR closes. Running these five dated cash flows through XIRR gives an annualized return that accounts for exactly how long each rupee was actually deployed, typically landing meaningfully higher than what a naive CAGR-style calculation on total invested versus total returned would suggest, because the later capital calls had far less time to compound before the fund started returning money.
0
76
0
Share On
Table Of Content
Introduction
CAGR (Compound Annual Growth Rate)
XIRR (Extended Internal Rate of Return)
Where the Two Numbers Diverge in Practice?
Conclusion
Tags