## CAGR formula Excel download

CAGR stands for Compound Annual Growth Rate. Here are some exercises to help you practice calculating CAGR: You can practice all the formulas and functions needed to find CAGR in Excel. You can also practice calculating future value using CAGR. Answers are also attached for your practice.

### Download the CAGR practice file

We have prepared a file that allows you to practice calculating CAGR in Excel.

You can practice with samples and on your own.

### Practice to calculate CAGR

#### Practice using basic formulas

Let’s calculate the CAGR from 2016 to 2019 using a basic formula.

Basic formula of CAGR is =(Ending value/Beginning value)^(1/Periods)-1

The answer is presented in the following article.

#### Practice using RRI function

Use RRI function to find the CAGR from 2016 to 2019.

The arguments to the RRI function are =RRI(nper,pv,fv).

For the answer, please browse the “Use RRI Function” section of the following article.

#### Practice using POWER function

Use the POWER function to find the CAGR from 2016 to 2019.

The arguments to the POWER function are =POWER(number,power)

For the answer, please browse the “Use POWER Function” section of the following article.

#### Practice using GEOMEAN function

Use the GEOMEAN function to find the CAGR from 2016 to 2019.

The arguments to the GEOMEAN function are =GEOMEAN(number1,[number2],…)

For the answer, please browse the “Use GEOMEAN Function” section of the following article.

#### Practice using IRR function

Use IRR function to find the CAGR from 2016 to 2019.

The arguments to the IRR function are =IRR(values,[guess])

For the answer, please browse the “Use IRR function” section of the following article.

#### Practice using XIRR function

Use the XIRR function to find the CAGR from 2016 to 2019.

The arguments to the XIRR function are =XIRR(values,dates,[guess]).

For the answer, please browse the “Use XIRR function” section of the following article.

### Practice using CAGR to calculate future value

#### Practice using basic formula

Calculate the future value based on the starting value, CAGR, and number of years by basic formula.

Basic formula of future value is FV=PV *(CAGR+1)^n

For the answer, please browse the “Use basic formula” section of the following article.

#### Practice using FV function

Calculate the future value based on the starting value, CAGR, and number of years by FV function.

The arguments to the FV function are =FV(rate,nper,pmt,[pv],[type]).

For the answer, please browse the “Use FV function” section of the following article.

### Comments

Please send us your comments on this article.