Velocity Reviews > Javascript PMT with FV

# Javascript PMT with FV

degroot.ryan@gmail.com
Guest
Posts: n/a

 08-23-2008
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
Guest
Posts: n/a

 08-23-2008
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
Guest
Posts: n/a

 08-24-2008
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
Guest
Posts: n/a

 08-24-2008
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).

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Nathan Sokalski ASP .Net 4 11-08-2007 07:24 AM Mark Rae ASP .Net 36 09-09-2006 01:12 PM CRON HTML 24 06-20-2006 08:05 PM mcdeveloper Java 1 06-13-2006 08:34 AM Justin Martin ASP .Net 3 02-09-2005 06:06 AM