TheCalculatorVault

CAGR Calculator

Find the compound annual growth rate (CAGR) — the single constant yearly rate that grows a beginning value into an ending value over a number of years — along with the total return, growth multiple and total gain, updated live as you type. Fractional years and declines are fully supported.

Currency

The starting / initial value at the beginning of the period.

The final value at the end of the period. Can be lower than the start (a decline) or 0 (total loss).

yr

The holding period over which growth is measured. Fractional values are allowed (e.g. 2.5).

Results update live as you type

Loading your first calculation…
Like this? Share: Email
CAGR is a smoothed, point-to-point growth rate. It assumes one beginning value and one ending value with no money added or withdrawn in between, and compresses every up and down into a single constant annual rate. Figures are nominal (not inflation-adjusted) and pre-tax. This is an educational tool, not financial advice.

What is CAGR?

CAGR — the compound annual growth rate — answers a simple question: if an investment grew from one value to another over a number of years, what single constant yearly rate would have produced exactly that result, assuming it compounded smoothly each year? It is the most widely used way to express investment growth as one comparable per-year number, used by Wikipedia, the Corporate Finance Institute, Investopedia and most financial calculators.

Crucially, CAGR is a representative rate, not a description of the actual path. A fund that returned +40%, −10% and +25% in three years has a real, bumpy journey; CAGR replaces that with the one smooth rate that lands on the same ending value.

How the CAGR formula works

The formula divides the ending value by the beginning value, takes the year-root, then converts to a percentage:

CAGR = ( (E ÷ B)1 ÷ t − 1 ) × 100

  • B — the beginning value (the starting / initial value at the start of the period); must be greater than 0.
  • E — the ending value at the end of the period; may be below B (a decline) or 0 (total loss).
  • t — the number of years over which growth is measured; fractional values such as 2.5 are allowed.

Two related figures fall straight out of the same numbers. The total (absolute) return is ((E − B) ÷ B) × 100 — the whole-period gain, not annualised. The growth multiple is simply E ÷ B (so 2.5× means the value grew two-and-a-half times), and it always equals 1 + absolute return ÷ 100. Note that year 0, the starting point, is not counted — only the t compounding years are.

The equation rearranges two useful ways: to project an ending value at a rate, E = B × (1 + CAGR)t; to find how long a target takes, t = ln(E ÷ B) ÷ ln(1 + CAGR).

Calculating CAGR in Excel. Three equivalent formulas work if your beginning value is in A1, ending value in A2, and number of years in A3. The direct form is =(A2/A1)^(1/A3)-1; the POWER function form is =POWER(A2/A1,1/A3)-1; and the purpose-built RRI function is the most concise: =RRI(A3,A1,A2) (nper, pv, fv). All three return a decimal — format the cell as a percentage or multiply by 100 to display it as a rate.

Example: ₹10,000 growing to ₹25,000 over 5 years

With E ÷ B = 2.5 and t = 5, the formula gives a CAGR of 20.11% a year — even though the total return is 150% over the whole period (2.5× the original, a gain of ₹15,000.00). The table below is generated by the same engine that powers the calculator above, so it can never drift from the math. It shows the implied value at the end of each year as it compounds smoothly from the beginning value up to the ending value.

YearImplied valueTotal growth so far
1₹12,011.24+20.1%
2₹14,427.00+44.3%
3₹17,328.62+73.3%
4₹20,813.83+108.1%
5₹25,000.00+150.0%

A decline works identically and is perfectly valid: ₹50,000.00 falling to ₹30,000.00 over 4 years is a CAGR of -11.99% a year — a negative rate, reported as such rather than clamped to zero. At an ending value of 0 (a total loss), the CAGR is exactly −100%.

CAGR vs absolute return — why the period matters

The single most important thing CAGR adds over a raw “total return” figure is that it accounts for how long the growth took. The same 150% total gain looks very different annualised over different holding periods:

Holding periodTotal (absolute) returnCAGR (per year)
1 year150.00%150.00%
3 years150.00%35.72%
5 years150.00%20.11%
10 years150.00%9.60%
20 years150.00%4.69%

A 150% total return is an impressive 20%+ a year if it happened in 5 years, but a much more ordinary single-digit rate if it took 20 years. That is exactly why you should compare investments on CAGR, not on headline total return.

CAGR vs IRR vs average return

CAGR is one of several return measures, and using the wrong one is a common mistake. The table below shows what each handles and when to reach for it:

MeasureWhat it handlesUse when
CAGRA single beginning value → a single ending value, no cash in or outYou invested once and want one smoothed annual growth rate
Absolute (total) returnThe whole-period gain, not annualisedYou only care how much it grew in total, ignoring time
Simple average returnThe arithmetic mean of yearly returnsAlmost never for compounding — it overstates growth
IRR / XIRRMultiple, irregularly timed cash flows (contributions, withdrawals)You added or withdrew money during the period

The key distinction: CAGR is for a single lump invested once. The moment you add or withdraw money during the period — a monthly SIP, a partial sell-down, reinvested dividends paid as cash — CAGR no longer describes your actual money-weighted return, and you need IRR or XIRR instead. And never use a simple average of yearly returns for anything that compounds: it ignores the order of gains and losses and systematically overstates growth.

The limitations you should keep in mind

CAGR is a clean comparison number, but it deliberately throws information away. Be aware that it:

  • Hides volatility and risk. Two investments with an identical CAGR can have wildly different drawdowns along the way — CAGR says nothing about how bumpy the ride was.
  • Ignores interim cash flows. It assumes nothing went in or out between the two endpoints, so it is not a substitute for IRR/XIRR when money is added or withdrawn.
  • Is highly sensitive to the chosen endpoints. A cherry-picked start or end date can make growth look far better — or worse — than the typical experience over the period.
  • Is not a forecast. It measures a realised or assumed past growth rate; it is not a prediction of future performance.
  • Is undefined for a non-positive beginning value. Dividing by — or rooting — a zero or negative base is not real, so the calculator requires a beginning value of at least 0.01 and a period of at least 0.1 years.

Frequently asked questions

What is CAGR and how is it calculated?+

CAGR (compound annual growth rate) is the constant yearly rate that would grow a starting value into an ending value over a number of years, as if it compounded smoothly each year. The formula is CAGR = ((ending value ÷ beginning value)^(1 ÷ years) − 1) × 100. For example, ₹10,000 growing to ₹25,000 over 5 years is (2.5^(1/5) − 1) × 100 ≈ 20.11% a year.

What is the difference between CAGR and absolute (total) return?+

Absolute return is the whole-period gain as a percentage — ₹10,000 to ₹25,000 is a 150% total return regardless of how long it took. CAGR converts that into a per-year rate, so the same 150% gain is about 20.11% a year over 5 years but about 9.86% a year over 10 years. Use CAGR to compare investments held for different lengths of time; use absolute return for the headline “how much did it grow in total”.

Is CAGR the same as average annual return?+

No. A simple average annual return just adds up the yearly returns and divides by the number of years, which overstates growth because it ignores compounding and the order of gains and losses. CAGR is a geometric (compounded) average, so it reflects what you actually ended up with. A portfolio that gains 50% then loses 50% has a 0% simple average but a negative CAGR — and the negative figure is the truthful one.

What is the difference between CAGR and IRR?+

CAGR measures growth between a single starting value and a single ending value, with no money added or taken out in between. IRR (internal rate of return) handles multiple, irregularly timed cash flows — contributions, withdrawals, dividends — and finds the rate that makes them all balance. If you invested once and checked the value years later, use CAGR; if you added or withdrew money along the way, use IRR or XIRR instead.

Can CAGR be negative?+

Yes. If the ending value is lower than the beginning value, the investment declined and CAGR is negative — this calculator reports it as a negative percentage rather than clamping it to zero. For example ₹50,000 falling to ₹30,000 over 4 years is a CAGR of about −11.99% a year. At an ending value of 0 (a total loss), CAGR is exactly −100%.

What does the growth multiple mean?+

The growth multiple is ending value ÷ beginning value — how many times the value grew in total. A 1.0× result is breakeven, 2.5× means it grew two-and-a-half times, and 0.6× means it shrank to 60% of the starting value. It is just another reading of the same result: growth multiple = 1 + absolute return ÷ 100.

Can I use CAGR for a period that is not a whole number of years?+

Yes. Enter the period as a decimal — 2.5 for two and a half years, or 0.5 for six months. The formula applies the fractional exponent (1 ÷ years) directly, exactly the way professional calculators handle part-year periods. For ₹1,000 growing to ₹1,500 over 2.5 years the CAGR is about 17.61% a year.

What are the main limitations of CAGR?+

CAGR smooths everything into one constant rate, so it hides volatility — two investments with the same CAGR can have wildly different ups and downs. It also ignores any money added or withdrawn during the period, and it is very sensitive to the start and end points you pick: a well-chosen start date can make growth look much better than it really was. Treat CAGR as a clean comparison number, not the whole story.

Why does the calculator need a beginning value above zero?+

CAGR divides the ending value by the beginning value, so a beginning value of zero would divide by zero. A negative beginning value is worse still — raising a negative number to a fractional power gives a non-real (complex) result. The calculator therefore requires a beginning value of at least 0.01, which keeps the math defined for every input.

How do I work backwards from a target CAGR?+

The same equation rearranges two ways. To find the ending value a rate would reach: ending value = beginning value × (1 + CAGR)^years. To find how long it takes to hit a target: years = ln(ending ÷ beginning) ÷ ln(1 + CAGR). For instance, to grow ₹10,000 at 12% a year for 8 years, the ending value is 10,000 × 1.12^8 ≈ ₹24,760.

Does CAGR account for inflation, tax, or fees?+

No. It computes a gross, nominal growth rate from the two values you enter. To get a real (inflation-adjusted) or after-tax figure, adjust the ending value (or beginning value) for those costs before entering them — for example subtract estimated tax and fees from the ending value, then compute CAGR on the net numbers.

Does this CAGR calculator work in any currency?+

Yes. CAGR is a pure ratio of ending value to beginning value, so the percentage is identical no matter the currency, as long as both values use the same one. Use the currency selector to display the beginning value, ending value and total gain in ₹, $, €, £ or ¥ — it changes the labels, not the result.

What is the difference between CAGR and XIRR?+

CAGR is the right measure when you invest a single lump sum once and want to know the annualised growth rate between that starting point and a later ending value — one in, one out, no other cash flows. XIRR (extended internal rate of return) is designed for multiple cash flows at irregular dates: every SIP instalment, every top-up, every partial withdrawal, each with its own date. A mutual fund quoting a "3-year CAGR of 16%" is describing how its NAV has grown from a fixed start — useful for comparing funds to each other or to an index. Your personal return on an SIP in that same fund is lower (say 13%) because your later instalments had less time to compound — and that figure is correctly called XIRR, not CAGR. Rule of thumb: use CAGR to evaluate a fund; use XIRR to evaluate your own investing experience in it.

What is CAGR in mutual funds?+

In mutual fund factsheets, CAGR means the annualised growth rate of the fund's NAV (net asset value) between two fixed dates — for example, from the scheme launch NAV to today's NAV, or from the NAV exactly 3 / 5 / 10 years ago to today's NAV. It is always a lump-sum point-to-point measure. If you have been investing via monthly SIP, your personal return is not the fund's advertised CAGR — it is the XIRR of your specific cash flows, because each instalment went in at a different NAV and has compounded for a different length of time. Enter your lump-sum investment details here to compute CAGR; for an SIP portfolio, use an XIRR calculator instead.

How do I calculate CAGR in Excel?+

Three equivalent formulas work in Excel. If beginning value is in cell A1, ending value in A2, and number of years in A3: (1) Direct formula — =(A2/A1)^(1/A3)-1, then format the cell as a percentage. (2) POWER function — =POWER(A2/A1,1/A3)-1, which is just the caret operator written as a named function. (3) RRI function — =RRI(A3,A1,A2), which is the most concise and returns the rate directly: nper is the number of periods, pv is the present (beginning) value, fv is the future (ending) value. All three return a decimal (e.g. 0.2011); multiply by 100 or format as percentage to get 20.11%. The RRI function is purpose-built for CAGR and is the cleanest option when your data is already in cells.

What is a good CAGR for an investment?+

"Good" depends on the asset class and the time horizon — a 7% CAGR is excellent for a government-backed savings scheme but underwhelming for a high-risk equity fund held for 15 years. As a rough historical reference for Indian markets: the Nifty 50 Total Return Index has delivered approximately 11–14% CAGR over 20-year rolling periods; domestic gold has averaged around 10–14% over 20 years; bank FDs have typically returned 6–7%; and PPF has been in the 7–8% range (rate revised periodically by the government). The key benchmark is whether the CAGR beats your personal hurdle rate — inflation plus a premium for the risk you took. These figures are historical averages, not a guarantee or forecast of future returns.

Sources

Formula and data last reviewed by the TheCalculatorVault team on 26 June 2026. Figures are for general information, not professional advice.