Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

Finding Annual Growth Rate

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Assad - 04 Jan 2007 06:51 GMT
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
Niek Otten - 04 Jan 2007 07:01 GMT
Hi Assad,

=RATE(24,,-13500,180000)

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
|
[quoted text clipped - 17 lines]
|
| Assad
joeu2004@hotmail.com - 04 Jan 2007 07:17 GMT
> 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.)
Assad - 04 Jan 2007 07:57 GMT
Hi

Thanks " NIEK OTTEN  &  JOEU2004@HOTMIAL.COM "

Problem solved,

Again thanks to you both guys for helping me, I really really
appreciate yours quick answers................

Regards.

Assad

> > Could someone advise, on finding annual growth rate equation.
> > Example is:-
[quoted text clipped - 17 lines]
>
> (6.84% per year.)
Thomas Hastings - 08 Jun 2007 16:47 GMT
Thanks - this was helpful to me too, five months later.

Can you explain to me, however, why the third argument in this function has
to be entered as a negative number?

There must be a finance-related reason, but I'm using this formula to
calculate an average GDP growth rate over a period of time, and it's highly
counter-intuitive (and therefore hard to teach) that one needs to make the
GDP in the base year negative.

thanks, -

Thomas Hastings
thomasrhastings@hotmail.com

> > Could someone advise, on finding annual growth rate equation.
> > Example is:-
[quoted text clipped - 17 lines]
>
> (6.84% per year.)
Bernard Liengme - 08 Jun 2007 17:02 GMT
Money has a sign because it can flow in one of two ways. Generally we use +
for money coming at us (a loan from the bank, interested received on a
saving account, etc) and a negative sign (-) for money leaving us (payment
made on a loan, taxes paid (you do pay taxes, I hope), deposits to a savings
account, etc)
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Thanks - this was helpful to me too, five months later.
>
[quoted text clipped - 37 lines]
>>
>> (6.84% per year.)
joeu2004 - 08 Jun 2007 18:36 GMT
On Jun 8, 8:47 am, Thomas Hastings <Thomas
Hasti...@discussions.microsoft.com> wrote:
> Can you explain to me, however, why the third argument
> in this function has to be entered as a negative number?

Inflows and outflows must have opposite signs.  But whether you use
plus for in and minus for out, or vice versa, is a matter of taste and
sometimes context.

Most people use plus for inflows and minus for outflows.  Hopefully
that does not seem "highly counter-intuitive" to you.  But note that
in that case, lenders and borrowers, for example, would choose
different signs.

I usually assign plus and minus so that the Excel function returns a
non-negative value.  (Except when my spreadsheet design reflects
positive and negative values.)  So I would write the functions the
same way whether I am a lender or borrower.  But I still must be
consistent with respect to the sign of inflows and outflows.

> There must be a finance-related reason

It is really more of an algebraic reason, and now a computer
programming reason.  I have never heard a financial person speak of a
loan as -$100,000 ;->.

(A bookkeeper might.  But again, whether it is a negative or positive
value depends on the type of the account.)

> but I'm using this formula to
> calculate an average GDP growth rate over a period of time, and it's highly
> counter-intuitive (and therefore hard to teach) that one needs to make the
> GDP in the base year negative.

Think of it this way:  you are "paying" (investing) the present value
and "receiving" (growing to) the future value.  Thus, PV can be
thought of as an outflow, and FV can be thought of as an inflow.
Thomas Hastings - 08 Jun 2007 19:43 GMT
> Think of it this way:  you are "paying" (investing) the present value
> and "receiving" (growing to) the future value.  Thus, PV can be
> thought of as an outflow, and FV can be thought of as an inflow.

thanks - helpful again, especially this last bit here.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.