Calculating CAGR


#1

Hi all,

I’m working on figuring out how to accurately show a compound annual growth rate. Using the power function gets me close but I can’t seem to reflect a full percentage. Here’s an example:

POWER(TTM/2014,1/5)-1

That works for raising calculating 1/100th of the accurate annual percentage growth over 5 years. Any thoughts on how to raise it to be a fully accurate percentage?

Thanks!


#2

Turns out I was able to answer my own question with some experimenting. To get CAGR, use this formula:

POWER(End Period/{Start Period},1/Time)*100-100

For me it looked like this:

POWER(TTM/{2014},1/5)*100-100

Looking forward to doing a lot more with Airtable!

Tim