PMT function

  • Thread starter Thread starter Bruce Baker
  • Start date Start date
B

Bruce Baker

Hi

I need to port this to a sql server script.

Is there anyplace I can get the source for this ?

Thanks
Bruce
 
Hi Bruce!

Help for PV gives the formula used for PV, FV, PMT, RATE and NPER

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Thanks - if only my schoolboy maths could work out to get PMT to the left
hand side of the equation...
 
Hi Bruce!

Re-expressed for PMT the formula is:

PMT = =-(PV*(1+RATE)^NPER+FV)/((1+RATE*TYPE)*(((1+RATE)^NPER-1)/RATE))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Back
Top