❤ Want to see our calculators more often in Google? Add us as a trusted source:
A compound annual growth calculator answers the question every investor eventually asks: what annual rate did my money actually earn? Absolute returns tell you the total percentage gain, but they ignore how long the journey took. A 60% gain over five years is not the same as a 60% gain over ten. The compound annual growth rate, or CAGR, converts any start-to-finish change into a single, time-adjusted annual rate. This makes it possible to compare a five-year mutual fund against a three-year fixed deposit, or a stock held for eight years against a bond held for two.
CAGR is the constant annual rate at which an investment would have grown if it had compounded steadily from its beginning value to its ending value over a specified number of years. It is a smoothed figure — not a record of what happened each year. Actual returns may have been higher, lower, or negative at various points. CAGR irons out those fluctuations to give one comparable number.
The formula is straightforward but frequently misunderstood:
Multiply the result by 100 to express it as a percentage. The exponent 1/n is what converts a total growth multiple into an annual rate. Without it, you are measuring absolute return, not CAGR.
Consider a concrete example. An investor puts ₹2,00,000 into an equity mutual fund. Four years later, the value is ₹3,50,000. The absolute return is 75%. The CAGR is:
This means the investment grew at an average annual rate of about 15.1%. If it had compounded at exactly 15.1% every year, the final value would be the same ₹3,50,000. A compound annual growth calculator automates this exponent calculation, which is impractical to do accurately by hand for most periods.
Spreadsheet users have three approaches, and only two of them are correct.
The wrong way — simple division:
This divides the total gain by the number of years and by the initial amount. It ignores compounding entirely and produces a number that is not CAGR. Do not use it for investment comparisons.
The correct way — the exponent formula:
Here A1 is the beginning value, B1 is the ending value, and C1 is the number of years. Format the cell as a percentage. This replicates the CAGR formula exactly.
Excel also has a dedicated function:
RRI stands for "rate of return on investment" and returns the equivalent interest rate for the growth of an investment. It produces the same result as the exponent formula but with less typing and fewer opportunities for bracket errors. For anyone building a CAGR calculator or auditing one, RRI is the cleaner choice.
The distinction between CAGR and absolute return is one of the most practical things an investor can internalise. They answer different questions, and using the wrong one leads to flawed conclusions.
| Point of comparison | Absolute Return | CAGR |
|---|---|---|
| What it measures | Total percentage change from start to finish | Annualised compounded growth rate |
| Accounts for time | No | Yes |
| Reveals year-by-year volatility | No | No |
| Best used for | Short-term holdings, raw gain or loss | Multi-year comparisons, goal planning |
| Inputs required | Beginning and ending values | Beginning value, ending value, years |
Suppose two funds both returned 50% absolute. Fund A did it in three years. Fund B took seven years. Absolute return says they are identical. CAGR says Fund A grew at roughly 14.5% annually while Fund B grew at about 6.0%. The difference is enormous, and it only becomes visible when time is factored in.
The reverse mistake is also common. A fund showing a 12% CAGR over ten years looks impressive, but if the same fund fell 40% in year three, the CAGR hides that painful drawdown. CAGR smooths volatility by design. It is a summary metric, not a risk metric. Pair it with compound interest projections and drawdown data for a complete picture.
For a lump sum mutual fund investment, CAGR works exactly as described. One amount goes in at the start, one value comes out at the end, and the formula gives the annualised rate.
A systematic investment plan, or SIP, is different. Money enters the fund every month, quarter, or year. Each instalment has its own holding period, and later instalments have less time to compound. Applying the standard CAGR formula to a SIP by treating the total invested amount as the beginning value understates the true return, because it assumes all the money was invested on day one.
Consider a ₹5,000 monthly SIP for three years. The total invested is ₹1,80,000. If the final corpus is ₹2,25,000, the absolute return is 25%. A naive CAGR calculation using ₹1,80,000 and ₹2,25,000 over three years gives about 7.7%. But the first instalment had three full years to grow, while the last had only one month. The actual annualised return, measured properly with XIRR, might be closer to 14–15%. This is why serious SIP evaluation uses XIRR, not CAGR.
A CAGR calculator remains useful for SIP planning if you use it to project a required rate rather than to measure historical SIP performance. Set the current invested amount, the target corpus, and the time horizon, and the tool returns the annualised rate you need. That rate then informs your asset allocation and expected return assumptions.
CAGR is a planning tool as much as a measurement tool. Rearrange the formula to solve for the rate you need:
Suppose you have ₹5,00,000 today and want ₹20,00,000 in twelve years. The required CAGR is:
That 12.25% figure is your target annual growth rate. You can now ask a more useful question: which asset mix has historically delivered around 12% CAGR over twelve-year periods? Indian equity indices have historically ranged between 11% and 14% over long horizons, though past performance does not guarantee future results. Debt instruments typically deliver 6–8%. A blended portfolio might target 10–11%.
XIRR, or Extended Internal Rate of Return, is the metric of choice when cash flows are irregular. It considers both the amount and the timing of every transaction, not just the start and end values.
| Scenario | Best metric | Why |
|---|---|---|
| One-time lump sum investment | CAGR | Single beginning and ending value; no intermediate flows |
| Monthly SIP in a mutual fund | XIRR | Multiple inflows at different dates; timing matters |
| Fixed deposit with reinvested interest | CAGR | No withdrawals; compounding is implicit |
| Portfolio with periodic withdrawals | XIRR | Outflows reduce the capital base at different points |
| Stock held for several years with dividends | XIRR | Dividends are cash flows; timing affects the true return |
The practical rule is simple. If money goes in once and comes out once, use CAGR. If money moves in or out multiple times, use XIRR. Using CAGR for a SIP or a dividend-paying stock produces a number that looks plausible but is mathematically incorrect for the actual cash flow pattern.
There is no universal answer because "good" depends on the asset class, the time period, and the risk taken. A few benchmarks help frame expectations.
A CAGR of 20% sounds impressive until you realise it came with a 50% drawdown. A CAGR of 11% with low volatility may be the better outcome for most investors. CAGR measures return, not risk-adjusted return. For that, you need volatility, Sharpe ratio, or maximum drawdown data alongside it.
Several errors appear repeatedly in practice. Avoiding them improves the reliability of every comparison you make.
A 12–15% CAGR over 10 years is considered strong for equity mutual funds, though it varies by category. Large-cap funds typically deliver 10–13%, while mid and small-cap funds can exceed 15% but with higher volatility. Debt funds usually range from 6–8%. Always compare a fund's CAGR against its benchmark index and category average, not against fixed deposits alone.
Yes. A negative CAGR means the investment has lost value over the period. For example, if ₹1,00,000 falls to ₹85,000 in three years, the CAGR is approximately -5.3% per year. This tells you the annualised rate of decline, which is more meaningful than saying the total loss was 15%. Negative CAGR often appears during market corrections or for underperforming assets.
Absolute return shows the total percentage change from start to finish and ignores how long it took. CAGR converts that same change into an annualised rate, factoring in the time period. For example, a 75% absolute return over five years equates to about 11.8% CAGR. CAGR is better for comparing investments held for different durations, while absolute return gives the raw gain or loss.
CAGR is designed for lump sum investments with a single beginning and ending value. For SIPs, where money enters at multiple points, XIRR is the more accurate measure because it accounts for the timing and amount of each instalment. However, you can still get a rough CAGR for a SIP by treating the total invested amount as the beginning value and the final corpus as the ending value, but this understates the true return because it ignores compounding on early instalments.
Use the formula: =((Ending Value/Beginning Value)^(1/Years))-1. For example, if A1 is the beginning value, B1 is the ending value, and C1 is the number of years, type =((B1/A1)^(1/C1))-1. Format the cell as a percentage. Excel's RRI function also works: =RRI(C1, A1, B1). Avoid simple division like (Ending-Beginning)/Beginning because it ignores compounding.
CAGR assumes a single investment at the start and no intermediate cash flows. XIRR handles multiple cash flows at different dates, making it suitable for SIPs, recurring deposits, and portfolios with regular contributions or withdrawals. XIRR gives a more realistic picture of returns when money moves in and out at different times, while CAGR is simpler and works well for one-time lump sum investments.
Not necessarily. A higher CAGR means higher historical growth, but it may come with greater volatility or risk. A fund with a 20% CAGR that swung wildly between +50% and -30% is not comparable to a fund with a steady 14% CAGR. Always pair CAGR with risk measures like standard deviation or maximum drawdown before drawing conclusions.
Start with your target amount and the years you have. Rearrange the CAGR formula to find the required annual growth rate: CAGR = (Target/Current)^(1/Years)-1. For example, to turn ₹5 lakh into ₹20 lakh in 12 years, you need a CAGR of about 12.2%. Use this rate to select an asset mix that historically delivers similar returns, then review annually.
In sum, a compound annual growth calculator transforms a raw percentage change into a standardised annual rate that makes comparisons meaningful across time periods and asset classes. Whether you are evaluating a mutual fund's ten-year track record, checking whether a stock has beaten its benchmark, planning the CAGR required to reach a retirement target, or deciding between a lump sum and a SIP structure, the calculator removes the exponent arithmetic that makes manual computation impractical. Use the CAGR calculator above, enter your beginning value, ending value, and years, and treat the output as what it is: a time-adjusted summary of growth, not a promise of future returns. Pair it with XIRR for cash-flow-heavy investments, absolute return for short-term holdings, and risk metrics for a complete view of performance.