CAGR (Compound Annual Growth Rate)
Cagr
CAGR (Compound Annual Growth Rate)
This is an Excel custom function (like a macro) that you can use to calculate Compound Annual Growth Rate, aka CAGR). Download is an Excel Workbook with an example of the use of this function.
Free Download
I used to use goal seek to calculate these in the past. This required several clicks and the creation of formulas.
Now I just type =cagr( and enter my range.
Thanks North Park Solutions.
Feedback
Product Details
North Park Solutions
Tools for Excel
