calculate the interest rate.

I know its present value
I know what it will be worth in the future
I know the number of years.
compounds once a year
how do I calculate the interest rate I am getting?
tried lots of formulas...
thanks all

this formula works for me, it just needs altering to put rate on the left of the =.
final value=todays value*(1+rate%/1)^(1+years)

Re: calculate the interest rate.

Quote from MickG;744926

P = present value
F = Final value
n = Number of years
r = interest rate

F = P*(1+r)^n
r=[(F/P)^(1/n)]-1

I get "that name is not valid" when I try the [
thanks

Re: calculate the interest rate.

here is a sample file
no macros, just simple math
it is from excel 2002? or 3.
thanks

Re: calculate the interest rate.

but as you see in the example, the answer should be 2.2.
I used the line above as a known.
what am I missing?
thanks

Re: calculate the interest rate.

Quote from anon125;745073

but as you see in the example, the answer should be 2.2.
I used the line above as a known.
what am I missing?
thanks

sorry, I made an error in the formula.
your formula works fine when I do it right!
thanks