Thread
:
Finding Annual Growth Rate
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Assad
external usenet poster
Posts: 6
Finding Annual Growth Rate
Hi
Thanks " NIEK OTTEN &
"
Problem solved,
Again thanks to you both guys for helping me, I really really
appreciate yours quick answers................
Regards.
Assad
" wrote:
"Assad" wrote:
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 )
=rate(24, 0, -13500, 180000)
(11.4% per year.)
and another addition of Y for next year and so on till 24th year.
This part of your question is unclear. If you are asking for a formula that
will give you "Y", that cannot be done unless you first know the compound
growth rate. But if you are asking how to compute the compound growth rate
given some "Y" -- for example, 2000 -- then:
=rate(24, -2000, -13500, 180000)
(6.84% per year.)
Reply With Quote
Assad
View Public Profile
Find all posts by Assad