2 Ways to Calculate Future Value When CAGR is Known in Excel

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.

Dataset for future value estimation

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.

Future value estimation using the general formula

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.

Future value estimation using the FV function


📄 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.

(Visited 51 times, 1 visits today)
Md. Ahaduzzaman

Md. Ahaduzzaman

Hello everyone i'm Md.Ahaduzzaman.I am a civil engineering graduate from BUET.I am enthusiastic and highly motivated to always learn something new to broaden my horizon and find my lacking. Hopefully my Articles will benefit you to understand and overcome your problem.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo