Help

Re: Calculating CAGR

1041 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tim_Beyers
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1
Tim_Beyers
5 - Automation Enthusiast
5 - Automation Enthusiast

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