Excel Hack

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

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.

Download the CAGR practice file

Practice to calculate CAGR

Practice using basic formulas

Practice to calculate CAGR

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.

How to find CAGR in Excel

Practice using RRI function

Practice using RRI functions

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.

CAGR function in Excel

Practice using POWER function

Practice to calculate CAGR

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.

CAGR function in Excel

Practice using GEOMEAN function

Practice to calculate CAGR

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.

CAGR function in Excel

Practice using IRR function

Practice to calculate CAGR

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.

CAGR formula in Excel

Practice using XIRR function

Practice to calculate CAGR with 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.

CAGR formula in Excel

Practice using CAGR to calculate future value

Practice using basic formula

Calculate future value

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.

Calculate future value when CAGR is known in Excel

Practice using FV function

Calculate future value

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.

Calculate future value when CAGR is known in Excel

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments