Calculating CAGR


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:


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?



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:


Looking forward to doing a lot more with Airtable!