**Compound Annual Growth Rate** (**CAGR**) is a well-known term in financial sectors. The compound growth rate is calculated based on the investment. In this article, we will calculate the end value using **CAGR **in Excel with 6 easy methods.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

## What is Compound Annual Growth Rate (CAGR)?

The compound annual growth rate is the rate of interest of investment comparing the end value and initial value with the number of years passed.

**Mathematical Formula of CAGR:**

**CAGR=(EV/IV)^(1/n)-1*100**Where,

* EV=*End value

* IV=* Initial value

* n=* Number of Years

So, our desired end value,

**EV=IV(CAGR/100+1)^n**We will calculate the **CAGR **first and then find the end value using that **CAGR**.

**6 Methods to Calculate End Value from CAGR in Excel**

We will show some methods to calculate the end value of **CAGR **in Excel.

The dataset below will be considered for calculation.

We will calculate the **CAGR **from this dataset, then calculate the end value.

**1. Use Simple Formula to Calculate End Value from CAGR**

We will create a formula for **CAGR **calculation.

Now, add new cells for **CAGR **and **End Value**. We will calculate the end value for the year 2020 based on the previous data.

**Step 1:**

- Go to
**Cell C11**. - Write the following formula.

`=(C10/C5)^(1/5)-1`

**Step 2:**

- Now, press
**Enter**.

Now, convert the growth rate into percentage form.

**Step 3:**

- Press
**Ctrl+1**. - Choose the
**Percentage**option from the**Number**tab. - Then press
**OK**.

Look at **Cell C11** now.

The **CAGR **is presented in the proper form.

**Step 4:**

- Move to
**Cell C14**. - Input the formula below.

`=C5*((C11+1)^10)`

**Step 5:**

- Now, press the
**Enter**button.

Here, we get the end value for the year **2020** based on the previous values.

**Read More: Excel Formula to Calculate Average Annual Compound Growth Rate**

**2. Excel RATE Function to Calculate CAGR and End Value**

**The RATE function** is used to get the interest of investment annually.

**Step 1:**

- Go to
**Cell C11**. - Put the formula below.

`=RATE(5,0,-C5,C10)`

**Step 2:**

- Press the
**Enter**button.

**Step 3:**

- Now, we will calculate the end value on
**Cell C14**. **Copy**and**Paste**the following formula.

`=C5*((C11+1)^10)`

**Step 4:**

- Again, press the
**Enter**button.

We get the end value of the year **2020**.

**Read More: CAGR Formula in Excel: With Calculator and 7 Examples**

**3. Apply POWER Function to Determine the End Value from CAGR**

**The POWER function** calculates the output of a number based on the given power.

We will use this power function to calculate the end value of **CAGR**.

**Step 1:**

- Go to
**Cell C11**. - Write the formula below.

`=POWER(C10/C5,1/5)-1`

**Step 2:**

- Click the
**Enter**button.

**Step 3:**

- Now, go to
**Cell C14**to calculate the end value. - Put the formula on that cell.

`=C5*POWER(C11+1,10)`

**Step 4:**

- Now, press the
**Enter**button.

**Read More: Compound interest excel formula with regular deposits**

**4. Combine RRI and ROW Functions to Measure End Value**

**The RRI function** provides an interest rate for the invested money.

**The ROW function** is the reference of a row number.

We will combine the **RRI **and **ROW **functions to get **CAGR** first.

**Step 1:**

- Write the formula based on the
**RRI**and**ROW**function on**Cell C11**.

`=RRI(ROW(C10)-ROW(C5),C5,C10)`

**Step 2:**

- Press the
**Enter**button.

**Step 3:**

- Go to
**Cell C14**and put the following formula.

`=C5*((C11+1)^10)`

**Step 4:**

- Again, press the
**Enter**button.

**Read More: Compound Interest Formula in Excel: Calculator with All Criteria**

**5. Use of GEOMEAN Function to Find the End Value from CAGR**

**The GEOMEAN function **provides the geometric mean from a given range of data.

**The PRODUCT function** returns the multiplication of multiple numbers.

We add a column named **Factor **for this method.

**Step 1:**

- Go to
**Cell C6**. Put the following formula in that cell.

`=C6/C5`

**Step 2:**

- Press
**Enter**and pull the**Fill Handle**icon.

**Step 3:**

- Go to
**Cell C11**. Put the formula below.

`=GEOMEAN(D6:D10)-1`

**Step 4:**

- Click the
**Enter**button.

**Step 5:**

- Now, go to
**Cell C14**. - Insert the formula based on the
**PRODUCT**function.

`=PRODUCT(C5,((C11+1)^10))`

**Step 6:**

- Finally, press the
**Enter**button.

**Read More: How to Use Compound Interest Formula in Excel**

**6. Apply Excel FV Function to Calculate the End Value from CAGR**

**The FV function** calculates the future value of any investment.

We will calculate the future value from the dataset below.

We will calculate the end value after **10 **years of the initial investment with the given **CAGR**.

**Step 1:**

- Go to
**Cell C10**. - Write the following formula.

`=FV(C6,C7,,-C5,C9)`

**Step 2:**

- Now, press
**Enter**.

**Read More: How to Calculate Future Value When CAGR Is Known in Excel (2 Methods)**

**Things to Remember**

In the case of the **FV **and **RATE **function, the initial value must be negative in the formula.

**Conclusion**

In this article, we’ve explained how to calculate the **CAGR **and the end value of the **CAGR **in Excel. I hope this will satisfy your needs. Please have a look at our website **Exceldemy.com** and give your suggestions in the comment box.

**Related Articles**

**How to Create Quarterly Compound Interest Calculator in Excel****Reverse Compound Interest Calculator in Excel (Download for Free)****Methods to Apply Continuous Compound Interest Formula in Excel****Formula for Monthly Compound Interest in Excel (With 3 Examples)****A Daily Compound Interest Calculator in Excel (Template Attached)****How to calculate compound interest for recurring deposit in Excel!**