hello bernie,
i would like to know if i have all the arguments except the rate, how can i
calculate it on paper
if
pmt= pv * i / 1 - (1/(1+i)^n)
where i=rate, n=period, pmt=annuity, pv=present value
i=?



"Bernie Deitrick" wrote:

From Help:

Microsoft Excel solves for one financial argument in terms of the others. If rate is not 0, then:



HTH,
Bernie
MS Excel MVP


"mich" wrote in message
...
what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess); how can
we calculated on paper?