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.
> 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
> You can make life easy by using the function or formula you know and use
> Goalseek to apply it "backwards".
> 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.