View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Assad Assad is offline
external usenet poster
 
Posts: 6
Default Finding Annual Growth Rate

Hi

Could someone advise, on finding annual growth rate equation.

Example is:-

An X items was valued at 13500 and after 24 Years it is
valued at 180000.

The equation shall forecast, Annual Growth Rate in %.
( which means, value X grown over by Y % ( which shall be static value )
and another addition of Y for next year and so on till 24th year.

And shall not forecast % to its base value ( 13500 ), which I had figured
out to be at 51.38% for 24 years.

Hope someone really understands,

Bye.

Assad