The following function is what I use to calculate mortgage amounts. I don't know if this will help you though. Oh, and it's in Javascript :(
function CalculateIt(LoanAmount, InterestRate,Years) { MonthlyInterestRate = (InterestRate / 100) /12; var Multiplier = 1 + MonthlyInterestRate; var TermRate = 1; for (var x=0;x<(Years*12);x++) { TermRate = TermRate * Multiplier; } var PrincipalInterest = (LoanAmount * MonthlyInterestRate) / (1 - (1/TermRate)); PrincipalInterest = Math.floor(PrincipalInterest * 100) / 100; return PrincipalInterest; } Marlon Les Mizzell wrote: > Does anybody have a formula to calculate Mortgage APR written in Cold Fusion > that I could have a look at? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm