What Is the Formula in Excel for Calculating CAGR?

The formula for calculating compound annual growth rate (CAGR) in Excel is: = ((FV/PV)^(1/n)) – 1, where "FV" is the ending value, "PV" is the beginning value and "n" is the number of years. CAGR is a measurement of the return on an investment over a defined period of time.

ADVERTISEMENT