Compound Annual Growth Rate
Author Message
Compound Annual Growth Rate

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.*-*-*.com/

Wed, 18 Jun 1902 08:00:00 GMT
Compound Annual Growth Rate
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

Quote:
> 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/

Wed, 18 Jun 1902 08:00:00 GMT
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/