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.