CAGR measures the mean annual growth rate of an investment over a specified period of time longer than one year.
Сделать с помощью ИИPrepare your data
Enter your beginning value, ending value, and the total number of years in separate cells.
Use the RRI function
In a new cell, type '=RRI(years, beginning_value, ending_value)' and press Enter.
Format as percentage
Select the result cell, go to the 'Home' tab, and click the '%' icon in the Number group.
=(Ending_Value/Beginning_Value)^(1/Years)-1They provide the same result, but RRI is a built-in financial function that is cleaner and easier to read.