I Ici Joined Mar 27, 2010 Messages 5 Reaction score 0 Mar 27, 2010 #1 Does somebody know the formula for PMT WITH !!!!!!!!!!!!!!!!FV!!!!!!!!!!!!!!!!!! ?? Last edited: Mar 27, 2010
V_R ¯\_(ツ)_/¯ Moderator Joined Jan 31, 2005 Messages 13,573 Reaction score 1,888 Mar 27, 2010 #3 What?
I Ici Joined Mar 27, 2010 Messages 5 Reaction score 0 Mar 27, 2010 #4 PMT(rate,nper,pv,fv,type) ... ....and I wnat to know algorithm, matematic formula...
I Ici Joined Mar 27, 2010 Messages 5 Reaction score 0 Mar 27, 2010 #5 for example> pmt:=pv*rate/(1-exp(-nper*ln(1+rate))); - but here are only rate, nper and pv BUT I NEED FORMULA WITH FV
for example> pmt:=pv*rate/(1-exp(-nper*ln(1+rate))); - but here are only rate, nper and pv BUT I NEED FORMULA WITH FV
I Ici Joined Mar 27, 2010 Messages 5 Reaction score 0 Mar 27, 2010 #6 I found it. pmt = (-pv * pvif - fv ) / ((1.0 + rate * type) * fvifa) where: pvif = (pow(1 + rate, nper)) fvifa = (pow(1 + rate, nper) - 1) / rate Last edited: Mar 27, 2010
I found it. pmt = (-pv * pvif - fv ) / ((1.0 + rate * type) * fvifa) where: pvif = (pow(1 + rate, nper)) fvifa = (pow(1 + rate, nper) - 1) / rate
A Anon_F Joined Jan 14, 2006 Messages 12,268 Reaction score 283 Mar 27, 2010 #7 Thats great you found the answer to your problem. Hope we can help again sometime.