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.

You can download that spreadsheet here for free.

Related lessons:

- Calculating percent change
- How to calculate ROI?
- If function
- Sum function
- How to Calculate Yield in Excel?