The CAGR formula
CAGR answers: what single steady yearly growth rate would take me from the starting value to the ending value over this many years? The formula is:
CAGR = (Ending value ÷ Starting value)^(1 ÷ years) − 1
Example: ₹1,00,000 grows to ₹2,00,000 in 5 years. The ratio is 2. The fifth root of 2 is about 1.1487, so CAGR is about 14.87% a year. Check it: 1,00,000 × 1.1487⁵ ≈ 2,00,000.
Why a simple average fails
Imagine an investment of ₹100 that rises 50% in year one and falls 50% in year two. The simple average of +50% and −50% is 0%, which sounds like break-even. But ₹100 rises to ₹150, then falls by half to ₹75. You lost 25%.
The problem is that percentage changes apply to different bases. A fall from a larger number takes away more than the same percentage gain added. Compounding makes returns multiply, not add, so the right average of growth rates is a geometric one, which is exactly what CAGR is.
Volatility drags on returns. For the same simple average, the more an investment swings, the lower its CAGR.
A year-by-year example
An investment goes 100 → 150 → 120 → 180 over three years. The yearly changes are +50%, −20% and +50%, and the simple average is 26.7%. The CAGR over the three years is (180 ÷ 100)^(1/3) − 1 ≈ 21.64%.
The 21.64% figure is the honest one: growing at a steady 21.64% a year for three years takes 100 to 180. The simple average of 26.7% would overstate the outcome, because 100 growing at 26.7% for three years would reach about 203.
When to use which
| Question | Best measure |
|---|---|
| How fast did my money actually grow over a long period? | CAGR |
| How did one specific year perform? | That year's return |
| Which of two funds did better over 5 years? | CAGR over the same period |
| I added money at different times (SIPs, withdrawals) | XIRR, which accounts for the timing of each cash flow |
Limits of CAGR
- It hides the path. Two investments can have the same CAGR but very different bumps along the way. Look at the worst year as well.
- It depends on the start and end dates. Choosing a start just after a crash or an end just after a peak flatters the number. Compare several periods.
- It works for a single starting amount. If you invested monthly, use XIRR, because CAGR assumes all the money was in from day one.
- It is backward-looking. A past CAGR does not predict a future one.
When you see "average annual return" in an advertisement, check whether it is a simple average or CAGR. The difference can be several percentage points.
Comparing two investments fairly
Fund A grows from 100 to 160 in four years. Fund B grows from 100 to 170 in five years. B ended higher, but it also took longer. CAGR puts them on the same footing: A is (160 ÷ 100)^(1/4) − 1 ≈ 12.47% a year, while B is (170 ÷ 100)^(1/5) − 1 ≈ 11.20% a year. Fund A grew faster per year even though its final number is lower.
Always compare CAGR over the same period for a fair result. A fund that did well over five years may look different over ten, so look at several time frames.
Calculating CAGR in a spreadsheet
- Formula for the rate: =(End/Start)^(1/Years)-1, then format the cell as a percentage.
- Excel and Google Sheets also have RRI: =RRI(Years, Start, End), which returns the same rate.
- For uneven cash flows, such as a SIP, use XIRR with the dates and amounts instead.
- Years need not be whole. For 30 months, use 2.5 years, and for a precise number use the actual number of days divided by 365.
Frequently asked questions
Can CAGR be negative?
Yes. If the ending value is lower than the starting value, the ratio is below 1 and the CAGR is negative, showing the steady yearly loss that would produce the same result.
What is a good CAGR?
It depends on the asset, the period and the risk. Compare with a relevant benchmark and with inflation instead of looking for a universal "good" number.
Is CAGR the same as XIRR?
No. CAGR assumes one starting amount and one ending value. XIRR handles multiple investments and withdrawals at different dates, which suits SIPs.
Try these tools
CAGR Calculator
Calculate CAGR from a beginning value, ending value and years, or solve the ending value from a CAGR. Includes the formula and a worked example.
Open toolXIRR Calculator
Calculate XIRR for irregular investments and withdrawals. Paste dated cash flows from a spreadsheet, get the annual rate and absolute gain instantly.
Open toolROI Calculator
Calculate return on investment from cost and final value, include fees, and see annualised ROI for a holding period. Shows the formula and an example.
Open toolSIP Calculator
Estimate the future value of a monthly SIP from your amount, expected return and years. Compare invested money with estimated returns, with optional step-up.
Open toolKeep reading
How to make a shopping list that saves time and money
A better shopping list means fewer forgotten items, less impulse buying and a faster shop. Learn how to organise, share and reuse your grocery list, with a simple routine.
Read guideHow to cut your grocery bill: 10 practical habits
Cut your food shopping costs with a plan, a list, unit prices and less waste. Ten practical habits that work in any supermarket, plus how to track them.
Read guideHow EMI is calculated: the formula, a worked example and why early EMIs are mostly interest
Understand the EMI formula step by step with a verified 10 lakh loan example, an amortisation table, and the effect of tenure and prepayment on interest.
Read guide