PMT function

[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

 

[Bruce Baker]

Thanks - if only my schoolboy maths could work out to get PMT to the left
hand side of the equation...

 

[Norman Harker]

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/