a function giving the interest rate for inv x for period y & bal z
 

Is there a function that returns the interest rate for a given investment "x"
that grows to balance "y" over period "z". No money is taken out until the
end. I use Excel 2003.
Thanks,
Cal

Cal,

For your period Z, you need to use start and end dates: for this example, it is 3 years, 1000 at the
start, 1200 at the end:

=INTRATE(DATEVALUE("1/1/5"),DATEVALUE("1/1/8"),1000,1200)

You can also specify a basis, which would be a fifth argument.

HTH,
Bernie
MS Excel MVP


"cal777" wrote in message
...
Is there a function that returns the interest rate for a given investment "x"
that grows to balance "y" over period "z". No money is taken out until the
end. I use Excel 2003.
Thanks,
Cal