In this lesson you can learn how to calculate CAGR in Excel.
CAGR (Compound Annual Growth Rate) is year-of-year average growth rate over a period of time. Calculating CAGR you can check how much do you earn annualy with your investments.
To calculate CAGR you can use that formula:
= ((FV/PV)^(1/n)) - 1
Picture show the example of formula. I think everything is clear.
- Calculating percent change
- How to calculate ROI?
- If function
- Sum function
- How to Calculate Yield in Excel?