CAGR Calculator – Average Annual Return
This CAGR calculator gives the average annual return as a single rate: $12,000 growing to $18,500 in 6 years is a CAGR of 7.48% per year. Enter a beginning value, ending value and number of years, or type the individual yearly returns of a fund or portfolio to get the geometric average, the total return and the doubling time.
Example: Calculate from: beginning value, ending value and years · Beginning value 10,000 · Ending value 20,000 · Number of years 10 → Average annual return (CAGR, geometric): +7.18% per year. Source: Wolfram MathWorld – Compound interest, doubling time and rule of 72. Updated: .
How it is calculated
The compound annual growth rate (CAGR) is (ending value ÷ beginning value)^(1 ÷ years) − 1. If $10,000 grows to $20,000 in 10 years, the CAGR is 2^(1/10) − 1 ≈ 7.18% per year, not the 10% that dividing 100% by 10 would suggest. The U.S. Bureau of Labor Statistics uses the same formula and calls the result the constant rate that gives the same overall outcome when applied to each year (BLS glossary, “Annual percent change”, read November 2, 2026).
How to calculate CAGR step by step
- Divide the ending value by the beginning value: $18,500 ÷ $12,000 = 1.5417, a total return of 54.17%.
- Take the root for the number of years: 1.5417^(1/6) = 1.0748.
- Subtract 1: 1.0748 − 1 = 0.0748, so 7.48% per year.
- Check it: $12,000 × 1.0748^6 returns $18,500. The calculator prints this check in its working.
| Beginning value | Ending value | Years | Total return | CAGR |
|---|---|---|---|---|
| $10,000 | $20,000 | 10 | 100% | 7.18% |
| $5,000 | $8,000 | 8 | 60% | 6.05% |
| $1,000 | $1,500 | 5 | 50% | 8.45% |
| $2,500 | $4,000 | 3.5 | 60% | 14.37% |
| $80,000 | $50,000 | 4 | −37.5% | −11.09% |
Fractions of a year are allowed, so 3.5 years works as in the table. The method fits anything that compounds: portfolio value, revenue, users or population.
Why not just average the returns?
Returns compound, they don’t add. After +50% and −50% the arithmetic average is 0%, yet $100 has become $75. The right average is the geometric mean: √(1.5 × 0.5) − 1 ≈ −13.40% per year. It is never above the arithmetic mean, and the gap widens with volatility (very roughly half the variance). U.S. fund ads that quote performance must show average annual total return for one, five and ten years (17 CFR § 230.482, read November 2, 2026).
| Yearly returns | Arithmetic mean | CAGR (geometric) | $100 becomes |
|---|---|---|---|
| +6, +6, +6, +6, +6 | 6.00% | 6.00% | $133.82 |
| +12, −4, +8.5, +15, −10 | 4.30% | 3.84% | $120.74 |
| +20, −10, +20, −10 | 5.00% | 3.92% | $116.64 |
| +40, −30, +40, −30 | 5.00% | −1.01% | $96.04 |
| +50, −50 | 0.00% | −13.40% | $75.00 |
The last two rows show the trap: an average of +5% can still lose money. The calculator displays both figures and tells you how many percentage points separate them.
Doubling time and the rule of 72
At a return r, money doubles after ln 2 ÷ ln(1 + r) years. The rule of 72 divides 72 by the rate and lands close: at 7% it gives 10.29 years against the exact 10.24, at 12% it gives 6 against 6.12. For regular contributions use the investment calculator or the compound interest calculator, for a one-off gain the ROI calculator, and to adjust past amounts for prices the inflation calculator.
Common CAGR mistakes
- Counting data points instead of periods: from 2020 to 2026 is 6 years, not 7.
- Using it with deposits or withdrawals: CAGR compares two values only. Money added along the way looks like growth, so for savings plans the money-weighted return (internal rate of return) is the better measure. This calculator does not compute it.
- Reading it as a forecast: it describes a past period and says nothing about the next one.
- Ignoring risk: two investments with the same CAGR may have swung very differently. Enter the yearly returns to see the path.
- Picking flattering dates: a start at a market low raises the figure. Compare CAGRs over the same dates.
- Starting from zero: a beginning value of 0 has no CAGR, because you cannot divide by 0. A yearly return of −100% or worse is rejected as a total loss.
Frequently asked questions
How do you calculate CAGR?
CAGR = (ending value ÷ beginning value)^(1 ÷ years) − 1. $5,000 growing to $8,000 in 8 years: 1.6^(1/8) − 1 ≈ 6.05% per year.
What is the difference between CAGR and average annual return?
CAGR is the geometric mean and reflects actual growth, while the simple average adds the yearly returns and divides. With +40%, −30%, +40%, −30% the simple average is +5% but the CAGR is −1.01%.
How do I calculate CAGR in Excel?
Use =(End/Start)^(1/Years)-1 or =RRI(Years, Start, End). From yearly returns: =GEOMEAN(1+range)-1 entered as an array formula.
Can CAGR be negative?
Yes, when the ending value is below the beginning value: 100 falling to 81 over 2 years is −10% per year.
What is a good CAGR?
No single number is good; it depends on the asset and the period. Compare CAGRs over the same time span and alongside risk, since a steady 6% can be preferable to a volatile 8%.
How many years does it take to double at a given CAGR?
At 7% it takes 10.24 years, from ln 2 ÷ ln 1.07. The rule of 72 estimates 10.29 years, and the calculator shows both figures next to the result.
Sources and legal basis
- Wolfram MathWorld – Compound interest, doubling time and rule of 72
- Wolfram MathWorld – Geometric mean
- U.S. SEC, Investor.gov – Compound interest calculator and explanation
As of: · Editorial policy
Related tools
- Compound interest calculatorCompound interest calculator with monthly contributions: final balance, interest earned, inflation-adjusted value, time to reach a goal, chart and yearly table.
- ROI calculatorROI calculator: return on investment, profit and annualized ROI for any holding period, plus a DuPont mode splitting ROI into profit margin and asset turnover.
- Savings goal calculatorSavings goal calculator: find out how much to save each month to reach your target, or how long it takes at your monthly amount – with interest.
- Inflation calculator – value of a dollar over timeInflation calculator with official BLS CPI annual averages 1913–2025: what a dollar amount is worth in another year, plus total and average inflation per year.
- P-Value CalculatorP-value calculator from a z-score, t-score or chi-square, or straight from a t-test with means, SDs and n – plus critical value and confidence interval.
- Mortgage calculatorMortgage calculator: monthly payment with taxes, insurance, PMI and HOA from home price, down payment and rate – extra payments, 15 vs 30 years, amortization.
- LBTT calculator for ScotlandLBTT calculator for Scotland: Land and Buildings Transaction Tax on a home, first-time buyer relief and the 8% Additional Dwelling Supplement, band by band.
- VA Disability Calculator (Combined Rating)VA disability calculator: enter your individual ratings to get the combined rating under 38 CFR 4.25 with the bilateral factor, every step and the monthly rate.
- HELOC CalculatorHELOC calculator: enter home value, mortgage balance and the lender’s CLTV limit to get your available credit line and the payments in draw and repayment.