Focal Point
Calculate 'Compound Annual Growth Rate'?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3011083381

August 31, 2006, 04:09 PM
margo430
Calculate 'Compound Annual Growth Rate'?
Does any one knows how to calculate 'Compound Annual Growth Rate? In Excel it is this

formula =POWER((E2/B2),(1/(E1-B1)))-1

Thanks.

Margaret
August 31, 2006, 07:01 PM
dhagen
should be:
 COMPUTE VALUE/D12.2 = ((E2/B2) ** (1/(E1-B1))) -1;  
I think.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
August 31, 2006, 07:15 PM
susannah
margo, it may help to think about it this way:
if you have values starting in 2000 and ending in 2005, then you have 6 data points, and 5 time periods.
so the cgr is the 5th root of the simple growth rate between the 2006 ending value and the 2000 starting value, that rate which if applied to the 2000 value for each of 5 years, would give you the exact same 2006 value as you actually have.
In focus , a root, of a number X is X**(1/root)
So a square root would be X**(1/2)
Yes there's a SQRT function, but to continue to other roots, its useful to know that exponentiating by the desired root's inverse is the way to go, as dhagen says




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
September 06, 2006, 07:03 AM
margo430
Thank you for an explanation and such a quick response. Code works like a charm.

Margaret