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/
Before you buy.



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/
> Before you buy.



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/
> > Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Compound Annual Growth Rate

2. Compounded Annual Growth Rate (CAGR)

3. Calculating Compounded annual rate of Growth

4. Calculating Compounded annual rate of Growth

5. Average Annual Compound Growth???

6. Compound Growth Rate

7. Compound Growth Rate Calculation

8. Calculating Compound Growth Rate

9. Calculate Compound Growth Rate

10. unable to calculate compounded growth rate in Excel


 
Powered by phpBB® Forum Software © phpBB Group