CAGR Calculator: Your Investment’s True Annual Growth

Rakesh Ghorpade almost redeemed a fund that was quietly beating everything else he owned, because a relationship manager did the arithmetic on the wrong formula and handed him a smaller number than the truth.

Rakesh runs a two-bay garage on the Kolhapur road out of Ichalkaranji, the kind of business where cash comes in Tuesday and a supplier bill is due Thursday. Four years ago he started an ₹8,000 monthly SIP into an equity fund, mostly because a customer whose car he serviced every month wouldn’t stop talking about it. He never touched the number until his bank’s RM pulled up his account during an unrelated visit and said, not unkindly, “sir, this is giving you only 10.8% CAGR, this endowment plan I have will beat that.” Rakesh almost signed. This is the story of the formula that nearly cost him, and the one SEBI actually requires for money that goes in every month instead of once.

The three metrics SEBI actually requires, and why it matters which one you use

Almost nobody outside a compliance department knows this, but SEBI does not leave “which return metric to show” to a fund’s marketing team. Mutual fund disclosure norms distinguish between return periods and cash-flow patterns, and require a different, specific calculation for each:

For holding periods of less than one year, schemes must show only the plain absolute return — the straight percentage gain, not annualised at all, because stretching a nine-month gain into a fictitious “yearly rate” exaggerates it. For a single lump sum held one year or longer, the required metric is the compounded annual growth rate — CAGR — computed point-to-point between one starting value and one ending value. And where the investment is not a single lump sum but a series of contributions on different dates — a SIP being the everyday example — CAGR is not the applicable metric at all. The computation that actually accounts for the timing and size of each instalment is XIRR, and it is what the Consolidated Account Statement and SIP-return disclosures are built around.

What the RM’s number actually did to Rakesh’s money

Here is the arithmetic the RM ran, and it looks perfectly reasonable if you don’t know the rule above. He took Rakesh’s total invested amount, Rs 3,84,000 across 48 monthly instalments, treated it as if it were a single sum Rakesh had put in on day one, and plugged it straight into the CAGR formula against the current value of Rs 5,80,000:

CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ years) − 1 = (5,80,000 ÷ 3,84,000)^(1/4) − 1 = (1.5104)^0.25 − 1, which comes out to roughly 10.9% a year.

That calculation is not wrong as arithmetic. It is wrong as a description of Rakesh’s money, because it silently assumes the entire Rs 3,84,000 sat invested for the full four years. It didn’t. His first Rs 8,000 instalment had four years to grow; his most recent one had barely a month. Treating forty-eight separate contributions, most of them made in the last two years, as if they were one lump sum deposited on day one systematically understates the true rate of return whenever the fund has been rising — because the formula divides the whole gain across a holding period that most of the money never actually experienced.

The number XIRR actually gives you

Run the same money through the calculation that matches its actual shape — forty-eight separate cash flows, each with its own date, solved for the single annual rate that reconciles all of them to the final Rs 5,80,000 — and the answer moves a long way from 10.9%. A rough, honest way to feel why: the average rupee in Rakesh’s SIP had been invested for roughly half the total tenure, about two years, not four. Applying the same total growth over two years instead of four needs a much higher annual rate to get there — in the region of 19–20%, not 11%.

That gap is not a rounding error. It is the difference between a fund that looks mediocre and a fund that is, by a wide margin, one of the better things Rakesh owns. It is also, uncomfortably, the exact gap that made the RM’s pitch look attractive.

What nobody tells you about the factsheet in front of you

The uncomfortable part is that this mistake is not confined to bank branches. Plenty of fund comparison pages, and even some SIP calculators sold as “simple”, quietly compute a CAGR-style figure on total invested versus current value and print it as if it were the fund’s real annualised return. It reads cleanly and nobody stops to ask why a SIP — which by definition involves money going in on forty-eight or sixty different dates — gets reduced to a single before-and-after number. The error survives precisely because it looks like the CAGR everyone learned in school, and the box it’s printed in never says “this is the wrong tool for this cash-flow pattern.”

The direction of the error also isn’t fixed. In a fund that’s been rising steadily, misapplied CAGR understates the true return, as it did for Rakesh. In a fund that fell hard early and recovered late, the same misapplied formula can overstate it, because it ignores that a large share of the money went in only after the recovery had already started. Either way, the number is describing a lump sum that never existed.

What to actually do with your own SIP statement

Don’t trust a single “CAGR” figure on any statement that involves more than one contribution date, including SIPs, step-up SIPs, or any fund you’ve topped up irregularly. Ask specifically whether the number quoted is XIRR or CAGR, and if it’s CAGR on a SIP, treat it as unreliable rather than merely approximate. YOU ENTER your own instalment amounts and dates, along with the current value, and IT TELLS YOU the actual money-weighted annual return — the one number that reflects what your rupees, each on its own date, actually did.

For a SIP specifically, the calculator on this page handles the lump-sum, point-to-point case cleanly — which is exactly why it matters to first confirm which case you’re in. If your money went in on more than one date, the number you want is XIRR, not the CAGR formula above, however tempting it is to reuse the same tool for both.

What this does not mean

This does not mean every RM who quotes a CAGR figure is trying to mislead anyone. Most bank staff are working from a template that has always computed it this way, and few have ever been shown the SEBI distinction between the three metrics. It also does not mean Rakesh’s SIP is guaranteed to keep returning anywhere near 19–20%; XIRR describes what already happened, not what will happen next, and a market correction next quarter would change the number substantially. It does not mean the endowment plan he was pitched is automatically bad for everyone — only that comparing its projected return against a wrongly-deflated SIP figure was never a fair comparison to begin with. And it does not mean absolute return or CAGR are useless metrics; they are the correct tool for exactly the situations SEBI specifies — a lump sum, held for a defined period. The mistake is not the formula. It is using it on money it was never built to describe.

Frequently asked questions

Why does a SIP need XIRR instead of CAGR at all?

CAGR assumes one starting balance growing untouched to one ending balance. A SIP has forty-eight, sixty, or however many separate starting balances, each on its own date. XIRR solves for the single annual rate that reconciles every one of those individual cash flows to the final value, which is what a staggered investment actually requires.

Can I compute XIRR by hand the way I can compute CAGR?

Not comfortably. CAGR has a closed-form formula you can do on a calculator. XIRR requires solving an equation with as many terms as you have cash flows, which is why it is normally left to a calculator or spreadsheet function rather than worked out longhand — but the input you need is simple: every date and amount that went in or came out.

Is the fund’s factsheet CAGR the same as my personal CAGR?

Only if you invested the entire amount as a single lump sum on the factsheet’s start date. If you invested via SIP, added lump sums at different times, or redeemed partially, your personal return will differ from the factsheet number, sometimes by a wide margin, exactly as it did for Rakesh.

What CAGR number should make me pause?

Any equity CAGR figure being applied to a SIP or any account with more than one contribution date. That mismatch alone, regardless of whether the resulting number looks good or bad, means the figure isn’t describing your actual money.

Regulatory source: SEBI‘s mutual fund disclosure norms require returns under one year to be shown only as absolute figures, returns of one year or more on a single investment as compounded annual growth rate, and returns on staggered investments such as SIPs to be computed as XIRR rather than CAGR. The reconstruction of Rakesh’s statement, the RM’s miscalculation and the resulting comparison are this article’s own.

---

Disclaimer: This article is for general information only and is not financial or tax advice. “Rakesh Ghorpade” is a composite character, not a real individual, built to illustrate a common calculation error. Consult a qualified advisor before making investment decisions, and verify which return metric — absolute, CAGR or XIRR — applies to your own cash-flow pattern before comparing any two products.