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