The Excel formula for CAGR is =(Ending Value/Beginning Value)^(1/Number of Years)-1. Format the result as a percentage to display the annualized growth rate.
Enter the beginning value, ending value, and number of years into the calculator. The tool applies the CAGR formula automatically and returns the compound annual growth rate as a percentage.
Yes. Google Sheets uses the same formula: =(Ending Value/Beginning Value)^(1/Number of Years)-1. You can also use this online calculator if you want a quick result without setting up a spreadsheet.
