Sometimes we have to estimate the forecast value of something based on some currently available data. In the planning stage of a city, we have to estimate the future population beforehand to design the necessary facilities for a certain amount of time like 50 or 100 years. In the economy, we know the current devaluation of money we can estimate the updated value of an asset after some certain period. So forecasting the future value based on the **CAGR** is very useful. In this article, we are going to discuss 2 easy and user-friendly ways to calculate the future value when the cagr value is known in Excel.

## 📁 **Download Excel File**

Download the practice file from here.

**What is CAGR?**

The mean annual growth rate of a deposit over a defined time period longer than one year is the compound annual growth rate or **CAGR**. It stands for one of the most precise techniques to figure out returns for specific assets, investment portfolios, and anything else whose value can change over time.

**CAGR=(FV/PV)^n -1**

Here,

**FV** is the Updated Value after a certain period.

**PV** is the present worth value.

**CAGR** is the Compound Annual Growth Rate %.

and **n** is the period number.

**Learn to Calculate Future Value When We Know CAGR Value in Excel with These 2 Methods**

In this article, we will use the general formula and the excel function to calculate future value when cagr is known. Let’s assume we have a dataset of the present population of a certain city. We have the present **CAGR** available in our hands. Now we will forecast what will be the population after **5** years. For our demonstration purpose, a snapshot of the sample dataset is as follows.

**method**

### 1. **Using Reverse CAGR Calculator in Excel Formula to Approximate Future Value **

In this section, we will discuss how to calculate future value when we know the CAGR value using the general formula. Therefore the step-by-step procedures are as follows.

**⬇️⬇️**** STEPS ****⬇️⬇️**

- Firstly we go to the formula box of cell
**C9**and write this formula.

**=C5*(1+C6)^C7**

- Here
**C5**is the current value of the population. **C6**is the**CAGR**and**C7**is the number of years.- We hit the
**Enter**button. - Finally, we get the estimated future population in cell
**C9**.

**method**

**2. Employing FV Function with CAGR Value to Forecast**

In this section, we will use the **FV** function to calculate future value when CAGR is known. So the breakdown steps are as follows.

**⬇️⬇️**** STEPS ****⬇️⬇️**

- Firstly we go to cell
**C9**and write this formula.

**=FV(C6,C7,,-C5)**

**🔨**** Formula Breakdown**

👉 Here, **C6 **is the **CAGR**.

👉 **C7** denotes the number of years.

👉 **C5** means the current population.

- After that, we hit the
**Enter**button. - Finally, we get the result of future population estimation in cell
**C9**.

**📄**** Important Notes**

🖊️ When we use the Excel function we have to be careful about the function argument.

🖊️ We have to put a minus sign before fourth argument in the second method otherwise the result will be faulty.

**📝**** Takeaways from This Article**

📌 We can use the available general formula to calculate future value when cagr is available.

📌 We can also use the **FV** function from Excel to calculate future value when cagr is known.

**Conclusion**

In this article, we have learned two simple ways to calculate future value when cagr is available. We can use the general formula or the **FV** function from Excel. Users can use whichever method they like. If you have any inquiries regarding this article please leave a comment in our comment section. The writer will try to answer them. If you want to explore further excel related problems you can visit our website **www.Excelden.com**.