mathematical formula of rate

[Guest]

what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess);
i have the pmt, the number of payments, and the present value i need to
calculate the rate on paper

 

[jetted]

use the function RATE to calculate interest rate for constant paymen
loa

 

[robert111]

it is detailed in help, PV worksheet functio

 

[jetted]

Hi Robert

Have a look at this web page for additional info
http://techonthenet.com/excel//formulas/rate.php

 

[Guest]

hello robert111,
thanks for the information it was helpfull, but i need to calculate the rate
in this formula:
pmt= pv * i / 1 - (1/(1+i)^n)
where i=rate, n=period, pmt=annuity, pv=present value
i=?

 

[robert111]

i = (PMT*(1-(1+i)^n))/pv