Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Javascript (http://www.velocityreviews.com/forums/f68-javascript.html)
-   -   Javascript PMT with FV (http://www.velocityreviews.com/forums/t936884-javascript-pmt-with-fv.html)

 degroot.ryan@gmail.com 08-23-2008 08:49 AM

Javascript PMT with FV

Hey,

I'm writing a script that will output a PMT similar to Excel. I've
searched the net and I've found a code that works, except if a
FutureValue is required.

Here's what I found (can't remember where, sorry)

function pmt_calc( intrest_rate , months , principal_value , fv ) {
pmt = Math.round( (principal_value * intrest_rate) / (1 - Math.pow(1
+ intrest_rate, -months))*100) / 100;
return pmt;
}

Excel's format is :
Pmt( interest_rate, number_payments, PV, FV, Type )

Any suggestions on how to locate a possible fix to include
FutureValue? Or ideas on how to fix it?

Thanks,
Ryan

 degroot.ryan@gmail.com 08-23-2008 07:53 PM

Re: Javascript PMT with FV

Oh, some numbers

interest_rate = 0.018125
months = 24
principal_value = 2500
fv = 250

Excel returns 120.98
JS returns 129.39

 degroot.ryan@gmail.com 08-24-2008 02:23 AM

Re: Javascript PMT with FV

Think I found a solution. I'm still going to test it out a bit more,
but for now, it's working perfect.

pmt = Math.round(intrest_rate * -(fv-
Math.pow((1+intrest_rate),months)*principal_value)/
(-1+Math.pow((1+intrest_rate),months))*100) / 100;

 MartinRinehart@gmail.com 08-24-2008 04:28 PM

Re: Javascript PMT with FV

When doing \$ arithmetic, it's best to do your computations in pennies,
then convert to dollars before you display a result.

The discrepancy is probably in nominal/real rate. 1% per month is 12%
per annum, nominal, but it is 12.68% annually real (compounded
monthly).

 All times are GMT. The time now is 04:55 AM.