How to Calculate CAGR (and When to Use XIRR)
Updated
CAGR, the compound annual growth rate, turns a gain over several years into a single yearly figure. It's the fairest way to compare investments held for different lengths of time, as long as the money went in once.
The CAGR formula
CAGR = (final value ÷ starting value)^(1 ÷ years) − 1. Multiply by 100 for a percentage.
A worked example
You invested ₹1,00,000 seven years ago and it's worth ₹2,50,000 today. The final value is 2.5 times the start, so CAGR = 2.5^(1 ÷ 7) − 1, which is about 14.0% a year. The total gain is 150%, but spread over seven years of compounding it is 14% a year, not 150 ÷ 7 = 21.4%.
Why not just divide by the years?
Dividing the total gain by the number of years ignores compounding and overstates the yearly return. CAGR answers a different question: what steady yearly return would have turned the starting amount into the final amount?
CAGR doesn't show the ride
An investment that rose 40% one year and fell 20% the next has a CAGR of about 5.8% over the two years. CAGR smooths out the ups and downs, so it says nothing about how bumpy the journey was.
When to use XIRR instead
CAGR assumes one investment at the start and one value at the end. For SIPs, top-ups or partial withdrawals, money went in and out on different dates, and CAGR gives the wrong answer. XIRR finds the single yearly rate that matches every amount on its actual date. It's the figure fund statements and investment apps show for SIPs.
In Excel
For CAGR: =(end/start)^(1/years)-1, or =RRI(years, start, end). For XIRR: list every investment as a negative amount with its date, add the current value as a positive amount with today's date, and use =XIRR(amounts, dates).
Comparing with other returns
An FD rate is already a yearly rate, so compare it directly with CAGR, keeping in mind that FD interest is taxed at your slab rate each year while equity gains are taxed differently. Compare returns after tax and inflation for a fair picture.
Try it
The CAGR & XIRR Calculator works out both: CAGR from a start and end value, or XIRR from a list of dated amounts. The results match Excel.