CAGR from a series of annual growth rates

[mgranalyst]

Hi all. Can someone please tell me whether an excel formula exists to calculate a compound annual growth rate from a series of annual growth rates. For example, I have annual growth rates for ten years of the following:

3.0% 2.9% 2.7% 2.7% 2.7%2.6% 2.4% 2.5% 2.7% 2.8%

If I calculate this long-handed the CAGR would be 2.7%.

Please assist.

 

[JLeno]

One way to do this:

1. Add helper row with

=1 + A1

2. Use formula

 =PRODUCT(A2:J2) ^ (1 / COUNT(A2:J2))

Another way (enter as array):

 =PRODUCT(1+A1:J1) ^ (1 / COUNT(A1:J1))

And there's probably plenty more

Cheers!