financial functions

financial functions - HELP!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Birks - 18 Apr 2007 22:20 GMT

I cannot find the right function to solve for the number of years it takes
for money to double given interest as a variable. It's a simple calculation,
but there does not seem to be a function for it. Input terms:

Amount of money
Interest rate

Ideas anyone?

Signature

Peace

Reply to this Message

JE McGimpsey - 19 Apr 2007 03:24 GMT

One way:

=NPER(x%, 0, 1, -2)

Note that amount of money is irrelevant to the calculation.

> I cannot find the right function to solve for the number of years it takes
> for money to double given interest as a variable. It's a simple calculation,
[quoted text clipped - 4 lines]
>
> Ideas anyone?

Reply to this Message

Birks - 19 Apr 2007 14:06 GMT

JE, I don't know why I couldn't figure it out; can' thank you enough!

Signature

Peace

> One way:
>
[quoted text clipped - 10 lines]
> >
> > Ideas anyone?

Reply to this Message