*35*

The acronym **CAGR** stands for **compound annual growth rate**, which is the average annualized revenue growth rate during a certain time period.

The formula to calculate CAGR is as follows:

CAGR = (future value / present value)^{1/periods} â€“ 1

The following examples show two equivalent ways to calculate CAGR in Google Sheets.

**Method 1: Calculate CAGR Manually**

We can use the following formula to calculate CAGR manually in Google Sheets:

=(ENDING_VALUE/STARTING_VALUE)^(1/PERIODS)-1

The following screenshot shows how to use this formula to calculate CAGR for an investment that started at $1,000 and ended at $5,000 after 9 investment periods:

The CAGR is **19.58%**. This represents the compound annual growth rate of the investment during these 9 investment periods.

We can confirm this answer is correct by calculating the growth of an initial $1,000 investment if it grew consistently at 19.58% each year for 9 years:

**Method 2: Calculate CAGR Using RRI Function**

Another way to calculate CAGR in Google Sheets is by using the **RRI** function, which uses the following syntax:

**RRI(number of periods, starting value, ending value)**

The following screenshot shows how to use this function in practice:

The CAGR is **19.58%**.

This matches the value that we calculated manually using the previous method.

**Additional Resources**

How to Calculate Exponential Moving Average in Google Sheets

How to Create a Correlation Matrix in Google Sheets

How to Find A Line of Best Fit in Google Sheets