The formula
CAGR = (final / initial)^(1 / years) − 1
Example. You invested ₹1L in 2020 and it's now ₹2.5L in 2025 (5 years). CAGR = (2.5)^(1/5) − 1 = 0.20114 = 20.11% per year. Even though the actual yearly returns were probably +35%, −10%, +25%, +30%, +5% (averaging 17%), the geometric CAGR is 20.11% because compounding lifts the geometric mean above the arithmetic mean whenever returns vary.
Project forward by inverting: future = initial · (1 + CAGR)^years.