LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
growth rate but not average kotlon Excel Discussion (Misc queries) 1 June 19th 06 11:09 AM
annual growth rate from monthly data kotlon Excel Discussion (Misc queries) 4 June 16th 06 08:56 PM
Compound Annual Growth Rate Stash Excel Discussion (Misc queries) 2 March 30th 05 07:49 PM
What formula do I use to calculate compound annual growth rate (C. pjbrien Excel Discussion (Misc queries) 0 March 23rd 05 08:39 PM
Compound annual growth rate [CAGR] Paul Excel Discussion (Misc queries) 2 March 17th 05 11:17 PM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"