Home › Blog › CAGR Calculator Guide

❤ Want to see our calculators more often in Google? Add us as a trusted source:

CAGR Calculator: Measure Compound Annual Growth Rate

Calculator200 Editorial Team — published September 2026, updated 14 September 2026

A CAGR calculator answers a question that raw percentage gains cannot: how fast did an investment actually grow each year? Enter three numbers — beginning value, ending value, and holding period — and the tool returns the compound annual growth rate, a single smoothed figure that accounts for the compounding effect of reinvested returns. Whether you are comparing two mutual funds held for different durations, checking whether a stock has beaten its benchmark, or projecting revenue growth for a business plan, a CAGR calculator delivers the annualised rate that makes comparison possible. The formula is straightforward, but the insight it provides is anything but trivial.

What CAGR Means and Why It Matters

CAGR stands for Compound Annual Growth Rate. It represents the constant annual rate at which an investment would have grown from its initial value to its final value over a specified period, assuming all gains were reinvested at the end of each year. In plain terms, it answers a counterfactual question: if this investment had grown at the same percentage every single year, what would that percentage be?

Real investments do not grow in a straight line. A mutual fund might surge 30% one year, dip 12% the next, and recover modestly the year after. CAGR smooths those fluctuations into a single annualised rate. That is precisely why it matters for comparison. Two investments held for different lengths of time cannot be fairly judged by their total returns alone. A 60% total return over five years is not the same as a 60% return over ten years. CAGR strips away the distortion of time and puts both on the same annual footing.

The metric is backward-looking. It describes historical performance. It does not predict future returns, and it does not capture the risk taken to achieve those returns. A fund with a high CAGR may have endured stomach-churning volatility along the way. CAGR tells you the destination; it does not describe the journey.

The CAGR Formula Explained

The formula is compact, but each component deserves attention.

CAGR = (Ending Value ÷ Beginning Value)(1 ÷ Number of Years) − 1

Multiply the result by 100 to express it as a percentage. The three inputs are:

Consider a straightforward example. You invest ₹2,00,000 in a mutual fund. After five years, the value is ₹3,22,102. The calculation is:

CAGR = (3,22,102 ÷ 2,00,000)(1 ÷ 5) − 1
= (1.61051)0.2 − 1
= 1.10 − 1
= 0.10

The CAGR is 10% per annum. This does not mean the fund returned exactly 10% each year. It means that if the fund had grown at a steady 10% compound rate, it would have reached the same ending value in the same period.

The order of operations matters. Exponents are calculated before subtraction. A common error is to subtract the ratio before applying the exponent, which produces a completely different and incorrect figure. A CAGR calculator handles the exponentiation automatically, eliminating this risk.

How to Calculate CAGR Manually

Manual calculation is useful when you want to verify a calculator's output or work through a problem on paper. The process breaks into four steps.

  1. Divide the ending value by the beginning value. This gives the total growth factor.
  2. Apply the exponent — raise that factor to the power of one divided by the number of years.
  3. Subtract one from the result. This converts the growth factor into a growth rate.
  4. Multiply by 100 to express the figure as a percentage.

Suppose ₹10,000 grows to ₹15,000 over three years. The total growth factor is 1.5. Raising 1.5 to the power of 1/3 gives approximately 1.1447. Subtract 1 and you get 0.1447, or 14.47% CAGR.

StepActionResult
115,000 ÷ 10,0001.5
21.5(1/3)1.1447
31.1447 − 10.1447
40.1447 × 10014.47%

The manual method works for any period, but the exponentiation step becomes cumbersome for long durations or fractional years. A calculator eliminates that friction.

Calculating CAGR in Excel and Google Sheets

Spreadsheets offer two approaches. One is quick but imprecise. The other is accurate and should be used for anything that matters.

The rough method divides the difference in values by the beginning value and then annualises it, but this does not account for compounding correctly:

=((Ending Value / Beginning Value) ^ (1 / Years)) - 1

This is the direct translation of the CAGR formula and works accurately. Enter the values in cells and reference them:

=((B2 / A2) ^ (1 / C2)) - 1

Where A2 is the beginning value, B2 is the ending value, and C2 is the number of years. Format the result as a percentage.

Excel's RRI function offers a cleaner alternative. It calculates the equivalent interest rate for an investment's growth:

=RRI(C2, A2, B2)

This returns the same result. The RATE function is another option, though it requires a slightly different argument structure.

A common mistake is to use (B2-A2)/A2/C2, which calculates simple average annual return, not CAGR. Simple average return ignores compounding and will produce a different, usually higher, figure. For any period longer than two years, the difference becomes material.

CAGR vs Absolute Return: Which Should You Use?

Absolute return and CAGR both describe investment performance, but they answer different questions. Absolute return tells you the total percentage change between the beginning and ending values. CAGR tells you the annualised compounded rate that produced that change.

If ₹5,00,000 grows to ₹9,21,400 over five years, the absolute return is 84.28%. The CAGR is approximately 13.00%. Both figures are correct. The absolute return shows the cumulative gain. The CAGR shows the annual pace at which that gain was achieved.

MetricAbsolute ReturnCAGR
What it measuresTotal percentage changeAnnualised compounded rate
Accounts for timeNoYes
Best forShort-term or single-period returnsMulti-year comparisons
Shows volatilityNoNo
Formula(Final − Initial) ÷ Initial(Final ÷ Initial)1/n − 1

The choice depends on the question you are asking. If you want to know how much an investment has grown in total, absolute return is sufficient. If you want to compare that investment against another held for a different period, CAGR is the appropriate metric because it normalises for time.

CAGR vs XIRR: When Multiple Cash Flows Are Involved

CAGR assumes a single lump-sum investment at the start and a single exit at the end. Many real-world investments do not work that way. SIPs, additional purchases, and partial withdrawals create multiple cash flows at irregular intervals. For these, CAGR is the wrong tool. XIRR — the Extended Internal Rate of Return — is the correct metric.

XIRR accounts for both the amount and the timing of each transaction. Money invested earlier has more time to compound than money invested later, and XIRR captures that distinction. A SIP of ₹1,000 per month for five years that grows to ₹85,000 will have a CAGR that looks misleadingly low if calculated on the total contributed amount. XIRR, by contrast, correctly reflects the staggered nature of the investments.

A simple rule: use CAGR for lump-sum investments with a fixed holding period. Use XIRR for SIPs, systematic withdrawals, and any investment with multiple cash flows. A XIRR calculator handles the latter case with precision.

Applying CAGR to Mutual Funds

Mutual fund performance is commonly reported as CAGR over one, three, five, and ten-year periods. These figures provide a standardised way to compare funds within the same category and against their benchmarks.

Equity mutual funds in India have historically delivered a CAGR in the range of 12% to 15% over ten-year periods, though this varies considerably by fund category, market cycle, and the specific period chosen. Debt funds typically range between 6% and 8%. These are historical ranges, not projections. A fund that delivered 18% CAGR over one five-year window may deliver 8% over the next.

When comparing mutual fund CAGRs, three principles apply. First, compare identical periods — a three-year CAGR should not be weighed against a five-year CAGR. Second, review the benchmark. A fund that returned 14% CAGR while its benchmark returned 15% has underperformed despite the impressive absolute number. Third, consider volatility. Two funds with similar CAGRs may have very different risk profiles. Standard deviation and maximum drawdown reveal what CAGR conceals.

For SIP investors, the picture changes entirely. A SIP calculator projects future value based on monthly contributions and an assumed rate of return. The actual return on a completed SIP is best measured by XIRR, not CAGR, because each instalment has a different holding period.

CAGR for Business Revenue and Growth Metrics

CAGR is not limited to investments. Businesses use it to measure revenue growth, profit expansion, user base increases, and market share gains over multiple years. A company whose revenue grew from ₹50 crore to ₹120 crore over five years has a CAGR of approximately 19.1%. That figure can be compared against industry averages, competitor performance, and internal targets.

The advantage of CAGR in a business context is its ability to smooth erratic year-to-year performance. Revenue might have grown 35% in one year, 5% in another, and 20% in a third. The CAGR condenses those fluctuations into a single annualised rate that reflects the overall trajectory. This makes it easier for analysts, investors, and management to assess sustained growth rather than reacting to short-term noise.

The limitation is the same as in investing: CAGR hides the path. A company that grew revenue through aggressive discounting or one-off contract wins may show the same CAGR as a company that grew through sustainable pricing power. The metric measures the outcome, not the quality of the growth.

How to Use a CAGR Calculator for Goal Planning

A CAGR calculator is not only a backward-looking tool. It can also help with forward planning by answering a related question: what annual growth rate do I need to reach a specific target?

Suppose you have ₹5,00,000 today and want to accumulate ₹15,00,000 in ten years. The required CAGR is the rate that solves the equation. Enter ₹5,00,000 as the beginning value, ₹15,00,000 as the ending value, and 10 as the number of years. The calculator returns approximately 11.6%. That figure tells you the annual return you need to achieve the goal, assuming no additional contributions.

This is useful for setting realistic expectations. If the required CAGR is 18%, and equity funds in your chosen category have historically delivered 12% to 14%, the goal may require either a longer horizon, additional contributions, or a larger initial investment. The calculator turns an aspiration into a testable assumption.

For systematic contributions, a compound interest calculator is more appropriate because it accounts for recurring deposits and the compounding of each contribution over different periods.

Limitations of CAGR You Should Know

CAGR is a useful metric, but it is not a complete picture of investment performance. Several limitations deserve attention.

These limitations do not diminish the usefulness of CAGR. They simply mean it should be used alongside other metrics — XIRR for cash-flow investments, standard deviation for risk, and after-tax return for real-world outcomes.

Frequently Asked Questions

What is CAGR and how is it different from absolute return?

CAGR measures the annualised compounded growth rate of an investment over a period. Absolute return shows the total percentage change without considering the time taken. For example, a 50% absolute return over five years translates to a CAGR of roughly 8.45% per year. CAGR is useful when comparing investments held for different durations because it standardises growth on an annual basis.

How do I calculate CAGR manually?

Divide the ending value by the beginning value. Raise that result to the power of one divided by the number of years. Subtract one from the result. Multiply by 100 to express it as a percentage. For example, ₹1,00,000 growing to ₹1,50,000 over three years gives (1.5)(1/3) − 1 ≈ 14.47% CAGR.

Can I use CAGR for SIP returns?

No. CAGR is designed for a single lump-sum investment with one entry and one exit. SIPs involve multiple investments at different dates and amounts. XIRR is the correct metric for SIP returns because it accounts for the timing and size of each instalment. Using CAGR for a SIP would produce a misleading figure.

What is a good CAGR for mutual funds in India?

Equity mutual funds in India have historically delivered a CAGR in the range of 12% to 15% over ten-year periods, though this varies significantly by fund category and market cycle. Debt funds typically range between 6% and 8%. These are historical ranges, not guarantees. Always compare a fund's CAGR against its benchmark and category average.

Does CAGR account for volatility or risk?

No. CAGR is a smoothed figure that hides year-to-year fluctuations. Two investments can have identical CAGRs but very different risk profiles. A fund that returned 30%, −10%, and 25% over three years has a CAGR of about 13.6%, but the journey was far from smooth. Always review standard deviation, maximum drawdown, and Sharpe ratio alongside CAGR.

How is CAGR used for business revenue growth?

Businesses use CAGR to measure revenue, profit, or user base growth over multiple years. If a company's revenue grew from ₹50 crore to ₹120 crore over five years, the CAGR is approximately 19.1%. This provides a standardised growth figure that can be compared against industry benchmarks, competitor performance, and internal targets.

What is the difference between CAGR and XIRR?

CAGR assumes a single investment at the start and no additional cash flows. XIRR handles multiple investments and withdrawals at irregular intervals. For a lump-sum mutual fund investment, CAGR is appropriate. For SIPs, systematic withdrawals, or any investment with multiple transactions, XIRR gives a more accurate picture of returns.

Can CAGR be negative?

Yes. If the ending value is less than the beginning value, the CAGR is negative. For example, an investment that drops from ₹1,00,000 to ₹80,000 over four years has a CAGR of approximately −5.4% per year. A negative CAGR indicates a decline in value over the period, though it does not reveal the path the investment took to get there.

In summary, a CAGR calculator transforms a simple set of inputs — beginning value, ending value, and time — into a powerful measure of annualised growth. It enables fair comparison between investments held for different durations, reveals the compound effect that simple averages obscure, and provides a standardised figure for mutual fund analysis, business performance, and goal planning. Its limitations are real: it hides volatility, assumes reinvestment, and cannot handle multiple cash flows. Used alongside XIRR for cash-flow investments and risk metrics for context, CAGR remains one of the most versatile tools in the investor's toolkit. Whether you are evaluating a lump-sum mutual fund investment, assessing a company's revenue trajectory, or calculating the return needed to reach a financial goal, the compound annual growth rate calculator delivers the clarity that raw percentages cannot.