Solved: Interest Rate

[excelliot]

I i wants to calculate interest rate in execel, when number of year , present value and future value is given, i wants to calucalte % rate of gain.

E.G.

PV=100
FV=150
N=1

so what is % gain..

[matthewspatrick]

=((FV/PV)^(1/N))-1

PV=present value
FV=future value
N=years

formula yields effective annual interest rate

[excelliot]

Thanks, I think i have forgotten basic maths need to go back to school.