View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beauwebber
 
Posts: n/a
Default Calculating Compounded Growth Rates


Greetings:

Is it possible to calculate a compounded growth rate using a begining
value, ending value, and number of intervals?

For example,

2005 Population = 24635
2010 Population = 30159

Inverals = 5

The annual rate (5 intervals) = 4.11%

Is there a function that can calucate the 4.11 % ?

Best regards,
Beau


--
Beauwebber
------------------------------------------------------------------------
Beauwebber's Profile: http://www.excelforum.com/member.php...o&userid=35349
View this thread: http://www.excelforum.com/showthread...hreadid=551232