Short answer: CAGR is (end ÷ start)^(1 ÷ years) − 1. ₹1,00,000 growing to ₹2,00,000 in five years is 14.87% a year — a 100% absolute return spread over five years.
Why use the annualised figure at all
Comparing a three-year investment that returned 40% with a seven-year one that returned 70% is impossible in your head. CAGR puts both on a per-year basis. It is a smoothing device, not a description: an investment that fell 30% then rose 100% has the same CAGR as one that crept up steadily, and only the steady one felt like that number.
Worked example
A fund goes from ₹2,50,000 to ₹4,00,000 in 6 years. Multiple = 1.6; CAGR = 1.6^(1/6) − 1 = 8.15%. Absolute return is 60%, and the difference between 60% and 8.15% is entirely the effect of compounding over six years.
When CAGR is the wrong tool
If money went in or out during the period, CAGR overstates or understates what you actually earned. Use XIRR for dated cash flows, and the SIP calculator when the investment was a monthly commitment.