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..
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..
A mighty flame followeth a tiny sparkle!!
=((FV/PV)^(1/N))-1
PV=present value
FV=future value
N=years
formula yields effective annual interest rate
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
Thanks, I think i have forgotten basic maths need to go back to school.
A mighty flame followeth a tiny sparkle!!