CAGR Explained: How to Calculate and Use It in PMS/AIF Investing
CAGR smooths every bumpy year into one clean number which is exactly why it's the most quoted, and most misunderstood, figure on any PMS or AIF fact sheet. Here's the formula, worked out, and what it's actually hiding.


CAGR (Compound Annual Growth Rate) is the single annualized rate at which an investment would have grown each year if it had compounded smoothly, instead of moving up and down as real markets do. It's calculated as (Ending Value ÷ Beginning Value)^(1/n) − 1, where n is the number of years. CAGR is the most common way PMS, AIF, and mutual fund performance is reported in India, but it has real limitations it ignores volatility, doesn't account for additional inflows or withdrawals, and says nothing about the risk taken to get there. This guide walks through the formula, worked examples, how CAGR compares to XIRR and absolute return, how it's used (and regulated) in PMS/AIF investing, and where a platform like PMS Sahi Hai and its AI assistant Nyra can help you look past the headline number.
What Is CAGR?
CAGR stands for Compound Annual Growth Rate. It answers one specific question: if this investment's real, uneven, year-to-year returns were replaced by a single, constant annual growth rate, what would that rate be?
Real investments almost never grow in a straight line. A portfolio might gain 28% one year, lose 6% the next, and gain 14% the year after that. This calculation takes the beginning value, the ending value, and the number of years in between, and smooths that entire bumpy path into one number the annualized rate that would have produced the same ending value if growth had been perfectly steady.
This is precisely why CAGR shows up everywhere in Indian investing: mutual fund fact sheets, PMS performance disclosures, AIF investor reports, and even company revenue-growth commentary. It gives investors, advisors, and portfolio managers a shared, comparable language for describing growth, according to Wikipedia's overview of the concept.
The CAGR Formula (And Why It Works)
The formula itself is simple:
CAGR = (Ending Value ÷ Beginning Value) ^ (1 ÷ n) − 1
Where:
- Ending Value = the investment's value at the end of the period
- Beginning Value = the investment's value at the start
- n = the number of years in the holding period
The exponent raising the ratio to the power of 1/n is what makes this a compounding calculation rather than a simple average. A basic average of yearly returns can be misleading because it ignores the base on which each year's gain or loss is applied; this method corrects for that by working backward from the actual start and end values, which is the same underlying logic used in fixed-deposit and loan compounding math, as explained in Wall Street Prep's breakdown of the CAGR formula.
How to Calculate CAGR Step by Step, With a Worked Example
Calculating CAGR by hand takes three steps:
- Divide the ending value by the beginning value.
- Raise that result to the power of (1 ÷ number of years).
- Subtract 1 and convert to a percentage.
Suppose an investor puts ₹10,00,000 into a PMS strategy, and five years later the portfolio is worth ₹20,00,000 with no additional money added or withdrawn along the way.
- Step 1: ₹20,00,000 ÷ ₹10,00,000 = 2
- Step 2: 2 ^ (1/5) = 1.1487
- Step 3: 1.1487 − 1 = 0.1487, or 14.87% CAGR
That 14.87% figure doesn't mean the portfolio grew exactly 14.87% every single year it might have grown 30% in year one and lost 8% in year three. What it means is that a steady 14.87% annual compounding rate would have produced the same doubling over five years. This is the core trade-off of the metric: it's clean and comparable, but it hides the texture of the journey.
How to Calculate CAGR in Excel: Four Reliable Methods
For anyone working with a spreadsheet which, in practice, is most PMS and AIF investors reviewing statements Excel supports at least four equivalent ways to compute CAGR, all detailed in Ablebits' guide to CAGR formulas in Excel:
- Direct formula: =(EndingValue/BeginningValue)^(1/n)-1
- RRI function: =RRI(nper, pv, fv) often the fastest single-function method
- POWER function: =POWER(EndingValue/BeginningValue, 1/n)-1
- RATE function: =RATE(n,,-BeginningValue,EndingValue) borrowed from annuity math, requiring the beginning value to be entered as a negative number
All four methods return the same result when applied to the same inputs; which one to use is mostly a matter of preference and which Excel version is available.
CAGR vs XIRR: What's the Real Difference
CAGR and XIRR (Extended Internal Rate of Return) are often confused because both express performance as an annualized percentage but they're built for different situations.
CAGR only works with a single beginning value and a single ending value. It cannot account for money added or withdrawn partway through the investment period. XIRR, by contrast, is designed exactly for that scenario: it factors in the exact dates and amounts of every cash flow every SIP installment, every top-up, every partial withdrawal and calculates the annualized rate that reconciles all of them with the final value, as Groww's comparison of XIRR and CAGR and Nippon India Mutual Fund's explainer both lay out.
| Aspect | CAGR | XIRR |
|---|---|---|
| Cash flow timing | Ignored uses only start and end values | Fully accounted for, using exact dates |
| Best suited for | Lump-sum, single-entry investments | SIPs, staggered PMS drawdowns, irregular top-ups/withdrawals |
| Calculation complexity | Simple, closed-form formula | Requires iterative solving (built into Excel's XIRR() function) |
| Common use case | Mutual fund and PMS fact sheets, point-to-point comparisons | Personal portfolio tracking with multiple transactions |
For a PMS or AIF investor who made a single lump-sum commitment and hasn't added or withdrawn capital since, the two figures will land close to identical. The moment there are multiple inflows or outflows which is common in PMS accounts that receive periodic top-ups XIRR becomes the more accurate measure, and the CAGR figure can meaningfully understate or overstate the investor's actual experience.
CAGR vs Absolute Return: Which Number Should You Trust
Absolute return is the simplest performance figure of all it's just the total percentage gain or loss over the entire holding period, with no annualization at all. If ₹10,00,000 grew to ₹20,00,000, the absolute return is a flat 100%, regardless of whether that happened over two years or over ten.
This is exactly where absolute return becomes misleading on its own, as multiple sources including Angel One's knowledge center comparison point out: a 100% absolute return over two years represents a very different (and far more impressive) rate of compounding than the same 100% over ten years. CAGR corrects for this by dividing the growth across the actual holding period, which is why it's the preferred metric whenever comparing investments held for different lengths of time. Absolute return still has its place for very short holding periods (under a year), annualizing a return can actually distort rather than clarify the picture, so many platforms report absolute return for sub-one-year performance and switch to CAGR beyond that.
How CAGR Applies to PMS and AIF Investing in India
PMS and AIF products are, by their nature, harder to compare than mutual funds. Each portfolio manager runs a different strategy, took clients on at different times, and reports performance on a schedule and format they largely set themselves which is exactly why a shared, annualized metric matters so much in this space specifically.
When evaluating a PMS strategy, investors typically encounter this figure across several timeframes at once 1-year, 3-year, 5-year, and since-inception because a single strategy can look dramatically different depending on the window chosen. A PMS that launched during a strong bull run might show an eye-catching since-inception figure that owes more to timing than to skill, while a strategy that launched right before a downturn might show a modest number despite genuinely sound stock-picking. Reading PMS/AIF performance responsibly means looking at the figure across multiple periods, against the right benchmark, alongside risk-adjusted metrics not cherry-picking the single most flattering window.
AIFs add another layer of complexity: many Category II and III AIFs have lock-in periods, drawdown structures, and carry/performance fees that mean the annualized return an investor actually experiences (after fees and the actual timing of capital calls) can differ meaningfully from what the fund reports at the strategy level.
How PMS Sahi Hai Helps You Understand the Inner Clause of Your Returns
This is exactly the gap PMS Sahi Hai was built to close. As India's first AI-powered PMS & AIF marketplace, PMS Sahi Hai exists on the premise that hard-earned wealth shouldn't rely on random advice and a CAGR number in isolation is about as random a basis for a decision as it gets.
The platform's PMS comparison toolandAIF comparison tool let investors look at performance the way it should be looked at: side by side across strategies, against the right benchmark, and across multiple time windows rather than as a single headline figure lifted from a pitch deck. For readers who want the fundamentals first, PMS Sahi Hai's own explainers on what PMS actually is and what an AIF actually is lay the groundwork before the numbers even enter the conversation.
At the center of this is Nyra PMS Sahi Hai's AI Wealth Compass. Nyra doesn't just display a CAGR figure; it reads the "inner clause" behind it the benchmark it's measured against, the consistency of the strategy across rolling periods, and how it fits (or duplicates) what an investor already holds. Nyra's process starts by understanding an investor's profile and goals, then analyzes the existing portfolio to reveal hidden overlaps and concentration risk, before surfacing a curated match from over 1,000 tracked PMS & AIF strategies all with the SEBI-registered oversight that PMS Sahi Hai operates under as a distributor and advisor.
What Counts as a "Good" CAGR for a PMS or AIF Strategy
There's no single universal number that defines a "good" figure it depends entirely on the strategy's mandate, market-cap focus, and the period being measured. A large-cap, benchmark-hugging PMS strategy and a concentrated small-cap or thematic AIF should be judged against very different expectations, and both should be judged against their own category benchmark, not against each other.
The more useful question isn't "is this number good in isolation" but "how does it compare to the strategy's own benchmark over the same period, and how consistent has that outperformance been across rolling time windows." A strategy that has beaten its benchmark consistently across multiple 3-year rolling periods is telling a very different story than one that beat its benchmark once, in one favorable window, and has lagged ever since.
How SEBI Regulates Performance Reporting for PMS and AIF
Because PMS and AIF performance reporting used to vary widely from one portfolio manager to another, India's market regulator has stepped in with standardization rules on both fronts.
For portfolio managers, SEBI issued a circular on performance benchmarking and reporting in December 2022. According to Business Standard's coverage of the framework, it requires every portfolio manager to classify each investment approach into one of four broad strategy categories equity, debt, hybrid, or multi-asset and to report performance against a maximum of three prescribed benchmarks per category, alongside peer comparisons, through the Association of Portfolio Managers in India (APMI). Portfolio managers must also submit monthly reports and undergo annual performance-verification audits.
For Alternative Investment Funds, SEBI's earlier benchmarking guidelines require half-yearly performance benchmarking (based on data as of March 31 and September 30 each year) against peer schemes of a similar vintage and strategy, administered through an AIF industry association, as summarized by Business Standard and AZB & Partners' legal analysis of the framework.
The scale these rules now govern is substantial: SEBI's own published statistics show total assets under management across India's portfolio management industry at ₹44,10,822 crore as of July 31, 2026, spanning discretionary, non-discretionary, advisory, and co-investment services reported by 514 registered portfolio managers. Standardized, comparable CAGR reporting isn't a nice-to-have at this scale it's a practical necessity for investors trying to make sense of an industry this large and this fragmented.
CAGR in Mutual Funds vs PMS vs AIF: Why the Same Metric Behaves Differently
The underlying math is identical wherever it's used, but what the resulting number represents shifts depending on the product. In a mutual fund, it is usually calculated on a pooled NAV that thousands of investors share, published daily, and easy to verify independently. In a PMS, each client technically holds a segregated portfolio in their own demat account so the figure quoted in a pitch deck is often a composite or model-portfolio number, and an individual client's actual return can differ based on their exact entry date and any client-specific deviations from the model. In an AIF, the calculation is complicated further by capital call structures (money isn't invested all at once), lock-ins, and carried interest meaning the fund-level figure reported to SEBI and the net, post-fee number an individual investor actually receives can diverge meaningfully. The practical takeaway: the closer a product's structure is to "single entry, single exit," the more a headline CAGR can be taken at face value; the more staggered and fee-layered the structure, the more that figure needs to be paired with XIRR and a clear read on fees before it means much.
The Limitations of CAGR You Shouldn't Ignore
For all its usefulness, CAGR has real blind spots that every PMS and AIF investor should keep in view:
- It hides volatility. Two portfolios can post an identical 15% CAGR while one had a smooth, low-drawdown ride and the other swung through a 40% drawdown along the way. The figure alone cannot tell them apart.
- It ignores cash-flow timing. As covered above, the calculation only looks at a beginning and ending value it says nothing about capital added or withdrawn in between, which is precisely where XIRR becomes necessary.
- Past performance does not predict future CAGR. It is, by definition, a backward-looking calculation. A standout 5-year figure is a description of what already happened, not a forecast of what comes next.
- It can be window-dressed. Since-inception CAGR is sensitive to the exact start date chosen; a strategy launched at a market low will show an inflated since-inception number that says more about timing luck than manager skill.
- It's reported before fees in some disclosures. Always check whether a quoted CAGR is pre-fee or post-fee the difference compounds meaningfully over a multi-year holding period, especially for AIFs with performance/carry structures.
Putting CAGR to Work in Your Own Portfolio Decisions
Used well, CAGR is a genuinely powerful starting point not because it tells the whole story, but because it gives every investor a common, honest unit of comparison. The practical checklist is straightforward:
- Always ask over what period a quoted CAGR was calculated, and whether that window was cherry-picked.
- Compare CAGR to the strategy's own category benchmark, not to unrelated strategies or to the market in general.
- Check whether cash flows were involved if capital was added or withdrawn along the way, ask for XIRR instead of, or alongside, CAGR.
- Look at CAGR across rolling periods, not just since-inception, to judge consistency rather than a single lucky window.
- Pair CAGR with a risk measure drawdown, volatility, or Sharpe ratio so a smooth compounding story isn't mistaken for a bumpy one dressed up in one clean number.
None of this requires abandoning CAGR it just means treating it as the opening question in a longer conversation about a portfolio, rather than the final answer.
How PMS Sahi Hai and Nyra Keep Your Portfolio Compounding Ahead of Time
The work doesn't stop once an investor picks a strategy with a compelling CAGR markets shift, sectors rotate, and a strategy that compounded well for three years can look very different in year four. This is where Nyra's continuous monitoring carries that conversation forward: tracking sector shifts, liquidity, and portfolio drift over time, and sending actionable rebalancing alerts rather than leaving an investor to notice a strategy has drifted only at the next annual review.
Whether an investor is a busy professional with no time to track markets, a family business consolidating scattered PMS and AIF holdings, or a first-time investor moving beyond mutual funds for the first time, the underlying need is the same: turning a CAGR figure on a fact sheet into a decision that's actually grounded in their goals, risk profile, and existing portfolio. That is, in a sentence, what Nyra Your AI Wealth Compass is built to do, whether an investor is exploring options for the first time through the PMS FAQs and AIF FAQs, or ready to go straight to the Nyra app and see where their own portfolio stands.
PMS Sahi Hai is a distributor of Portfolio Management Services and Alternative Investment Funds, APMI-registered (Registration No. APRN08358). This article is for education only and is not investment advice, a recommendation, or an offer to buy or sell any security. Investments in securities markets are subject to market risks; read all scheme-related documents carefully. Past performance is not indicative of future results. Consult your advisor before investing.

Ishaan founded PMS Sahi Hai to make India's PMS, AIF and GIFT City markets legible to serious investors, comparing every SEBI-registered manager on the same comparative basis, with no shelf products and no commission bias.
Frequently asked
Is CAGR the same as annual return?
Not quite. CAGR is an annualized rate calculated from a beginning and ending value over multiple years it represents what the annual return would have been if growth had been perfectly smooth. A single year's actual annual return, by contrast, reflects real, unsmoothed performance for that one year.
What is a good CAGR for a PMS or AIF strategy?
There's no fixed universal benchmark it depends on the strategy's mandate and the period measured. The more meaningful question is how consistently a strategy's CAGR has outperformed its own category benchmark across multiple rolling periods, not whether the number looks impressive in isolation.
Can CAGR be negative?
Yes. If the ending value is lower than the beginning value, the formula produces a negative percentage, reflecting an annualized rate of decline over the period measured.
Does CAGR account for dividends or fund distributions?
Only if those amounts are included in the ending value used in the calculation. If dividends or distributions were paid out and not reinvested or added back, the resulting figure will understate total investor return so it's worth checking whether a quoted number is total-return-inclusive.
Why do CAGR and XIRR sometimes show very different numbers for the same portfolio?
This happens whenever money was added or withdrawn partway through the holding period. The former only looks at the very first and very last values, while XIRR accounts for the exact timing and size of every cash flow in between so the two will diverge whenever cash flows were irregular.
How does a PMS or AIF's CAGR compare to a benchmark like the Nifty 50?
The same formula is applied to the benchmark index over the identical period, so the two annualized figures can be compared directly. What matters is not just whether the strategy's number is higher than the benchmark's in one window, but whether that outperformance has held up consistently across multiple rolling periods a single period of outperformance is far weaker evidence than a repeated pattern.
Keep reading
All articles
PMS Eligibility Criteria: What SEBI Actually Requires Beyond the Cheque Size
Understand PMS eligibility criteria beyond Rs 50 lakh. Learn the five SEBI requirements that truly protect investors.

Portfolio Management Services Explained: Who Is Actually Managing Your Money
Understand Portfolio Management Services: learn who manages your PMS portfolio, how discretionary mandates work, and why you retain full control.

How an NRI Opens a PMS Account in India: The Steps Before the First Cheque
NRI? Learn the 2 pathways to open a PMS account (GIFT City funds or onshore mandates) and get the exact documents you need to start.
Read it. Now pressure-test it.
Ask Nyra how this applies to your portfolio, or talk to our team, no pitch, no pressure.