CAGR measures the mean annual growth rate of an investment over a specified period of time longer than one year.
Doe het met AIPrepare 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.