Excel Excel

[Ici]

Does somebody know the formula for PMT WITH !!!!!!!!!!!!!!!!FV!!!!!!!!!!!!!!!!!! ??

 

[Ici]

Formula

Not Function

 

[V_R]

What?

 

[Ici]

PMT(rate,nper,pv,fv,type) ...

....and I wnat to know algorithm, matematic formula...

 

[Ici]

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

 

[Ici]

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

 

[Anon_F]

Thats great you found the answer to your problem.

Hope we can help again sometime.