compound annual growth rate

[MATT67]

Hi,

I need to work out a compund annual growth rate over a number of years.

Eg Year 1 is $100, Yr 2 is $200, Yr3 is $800 - what is the CAGR for the 3 years.

I urgently need an answer to this if possible.

 

[Andrew Poulsom]

Use the RATE function:

=RATE(2,,-100,800) = 182.8%

or

=(800/100)^(1/2)-1 = 182.8%

The years are one less than in the series.

 

[sen_edp]

hello Matt67

try this link

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q123198&


hth