Compound Annual Growth Rate

If by "compound interest" you mean x = (1+r)^n (where x is the result, r is

the annual growth rate, and n is the number of years), then you simply need

r = (1+x)^(1/n) to retrieve r.

Keith

Quote:

> Hi Bryan,

> I'm not sure what you try to calculate. Most financial functions exist in

> all directions. Use Help on the function you know and then click " See

> Also".

> You can make life easy by using the function or formula you know and use

> Goalseek to apply it "backwards".

> Groeten,

> Niek Otten

> > I'm trying to determine how to calculate compound annual growth rates

> > in Excel. Its basically the compound interest rate formula backwards,

> > but I'm still a little lost on how to enter the formula to get the

> > interest rate.

> > Any help at all would be very appreciated.

> > Thanks,

> > Bryan

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.