Hi Assad,

=RATE(24,,-13500,180000)

Kind regards,

Niek Otten
Microsoft MVP - Excel

"Assad" wrote in message ...
| 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
|
|