//*******************************************
//DO NOT REMOVE THIS COPYWRITE INFO!
//Mortgage Payment Calculator w/Amortization V1.1
//2003 Daniel C. Peterson ALL RIGHTS RESERVED
//Created: 08/28/2003
//Last Modified: 08/28/2003
//This script may not be copied, edited, distributed or reproduced
//without express written permission from
//Daniel C. Peterson of Web Winder Website Services
//For commercial use rates, contact:
//Dan Peterson:
//Web Winder Website Services
//P.O. Box 11
//Bemidji, MN 56619
//dan@webwinder.com
//http://www.webwinder.com
//Commercial User Licence #:3506-816-107-791
//Commercial Licence Date:2006-03-25
//*******************************************
function stripNum(num) {
var iPercent
var iDollar
var iSpace
var iComma
var numLength = num.length
//lalalla Line #114
if(numLength > 0) {
num=num.toString();
iPercent = num.indexOf("%");
if(iPercent >= 0) {
num=num.substring(0,iPercent) + "" + num.substring(iPercent + 1,numLength);
numLength=num.length;
}
iDollar = num.indexOf("$");
if(iDollar >= 0) {
num=num.substring(0,iDollar) + "" + num.substring(iDollar + 1,numLength);
numLength=num.length;
}
iSpace = num.indexOf(" ");
if(iSpace >= 0) {
num=num.substring(0,iSpace) + "" + num.substring(iSpace + 1,numLength);
numLength=num.length;
}
iComma = num.indexOf(",");
if(iComma >= 0) {
while(iComma >=1) {
num=num.substring(0,iComma) + "" + num.substring(iComma + 1,numLength);
numLength=num.length;
iComma = num.indexOf(",");
}
}
num = eval(num);
} else {
num = 0;
}
return num;
}
function formatCurrency(num) {
var isNeg=0;
if(num < 0) {
num=num*-1;
isNeg=1;
}
onum=Math.round(num*100)/100;
integer=Math.floor(onum);
if (Math.ceil(onum) == integer) {
decimal="00";
} else{
decimal=Math.round((onum-integer)*100)
}
decimal=decimal.toString();
if (decimal.length<2) decimal="0"+decimal;
integer=integer.toString();
var tmpnum="";
var tmpinteger="";
var y=0;
for (x=integer.length;x>0;x--) {
tmpnum=tmpnum+integer.charAt(x-1);
y=y+1;
if (y==3 & x>1) {
tmpnum=tmpnum+",";
y=0;
}
}
for (x=tmpnum.length;x>0;x--) {
tmpinteger=tmpinteger+tmpnum.charAt(x-1);
}
finNum="$"+tmpinteger+"."+decimal;
if(isNeg == 1) {
finNum = "-" + finNum;
}
return finNum;
}
function computeMonthlyPayment(prin, numPmts, intRate) {
var pmtAmt = 0;
if(intRate == 0) {
pmtAmt = prin / numPmts;
} else {
if (intRate >= 1.0) {
intRate = intRate / 100.0;
}
intRate /= 12;
var pow = 1;
for (var j = 0; j < numPmts; j++)
pow = pow * (1 + intRate);
pmtAmt = (prin * pow * intRate) / (pow - 1);
}
return pmtAmt;
}
function formatNumber(num) {
var isNeg=0;
if(num < 0) {
num=num*-1;
isNeg=1;
}
onum=Math.round(num*100)/100;
integer=Math.floor(onum);
if (Math.ceil(onum) == integer) {
decimal="00";
} else{
decimal=Math.round((onum-integer)*100)
}
decimal=decimal.toString();
if (decimal.length<2) decimal="0"+decimal;
integer=integer.toString();
var tmpnum="";
var tmpinteger="";
var y=0;
for (x=integer.length;x>0;x--) {
tmpnum=tmpnum+integer.charAt(x-1);
y=y+1;
if (y==3 & x>1) {
tmpnum=tmpnum+",";
y=0;
}
}
for (x=tmpnum.length;x>0;x--) {
tmpinteger=tmpinteger+tmpnum.charAt(x-1);
}
finNum=tmpinteger+"."+decimal;
if(isNeg == 1) {
finNum = "-" + finNum;
}
return finNum;
}
function computeForm(form) {
if(document.mortgagePayment.principal.value == 0 || document.mortgagePayment.principal.value == "") {
alert("Please enter the mortgage's principal amount.");
document.mortgagePayment.principal.focus();
} else
if(document.mortgagePayment.intRate.value == 0 || document.mortgagePayment.intRate.value == "") {
alert("Please enter the mortgage's annual interest rate.");
document.mortgagePayment.intRate.focus();
} else
if(document.mortgagePayment.numYears.value == 0 || document.mortgagePayment.numYears.value == "") {
alert("Please enter the mortgage's term in number of years.");
document.mortgagePayment.numYears.focus();
} else {
var Vprincipal = stripNum(document.mortgagePayment.principal.value);
var VintRate = stripNum(document.mortgagePayment.intRate.value);
var VnumYears = stripNum(document.mortgagePayment.numYears.value);
var VannualTax = document.mortgagePayment.annualTax.value;
var VmonthlyTax =0;
if(VannualTax == 0 || VannualTax == "") {
VannualTax = 0;
VmonthlyTax =0;
} else {
VannualTax = stripNum(VannualTax);
VmonthlyTax = VannualTax / 12;
VmonthlyTax *= 100;
VmonthlyTax = Math.round(VmonthlyTax);
VmonthlyTax /= 100;
}
var VannualInsurance = document.mortgagePayment.annualInsurance.value;
var VmonthlyInsurance = 0;
if(VannualInsurance == 0 || VannualInsurance == "") {
VannualInsurance = 0;
VmonthlyInsurance = 0;
} else {
VannualInsurance = stripNum(VannualInsurance);
VmonthlyInsurance = VannualInsurance / 12;
VmonthlyInsurance *= 100;
VmonthlyInsurance = Math.round(VmonthlyInsurance);
VmonthlyInsurance /= 100;
}
var VmonthlyPMI = document.mortgagePayment.monthlyPMI.value;
if(VmonthlyPMI == 0 || VmonthlyPMI == "") {
VmonthlyPMI = 0;
} else {
VmonthlyPMI = stripNum(VmonthlyPMI);
}
var VotherPmts = eval(VmonthlyTax) + eval(VmonthlyInsurance) + eval(VmonthlyPMI);
var VnumPmts = VnumYears * 12;
var VpmtAmt = computeMonthlyPayment(Vprincipal, VnumPmts, VintRate);
var VtotalMtgPmt = eval(VpmtAmt) + eval(VotherPmts);
document.mortgagePayment.monthlyPI.value = formatCurrency(VpmtAmt);
document.mortgagePayment.otherPmts.value = formatCurrency(VotherPmts);
document.mortgagePayment.monthlyPmt.value = formatCurrency(VtotalMtgPmt);
}
}
function monthlyAmortSched(form) {
if(document.mortgagePayment.principal.value == 0 || document.mortgagePayment.principal.value == "") {
alert("Please enter the mortgage's principal amount.");
document.mortgagePayment.principal.focus();
} else
if(document.mortgagePayment.intRate.value == 0 || document.mortgagePayment.intRate.value == "") {
alert("Please enter the mortgage's annual interest rate.");
document.mortgagePayment.intRate.focus();
} else
if(document.mortgagePayment.numYears.value == 0 || document.mortgagePayment.numYears.value == "") {
alert("Please enter the mortgage's term in number of years.");
document.mortgagePayment.numYears.focus();
} else {
var Vprincipal = stripNum(document.mortgagePayment.principal.value);
var VintRate = stripNum(document.mortgagePayment.intRate.value);
var VnumYears = stripNum(document.mortgagePayment.numYears.value);
var VannualTax = document.mortgagePayment.annualTax.value;
var VmonthlyTax =0;
if(VannualTax == 0 || VannualTax == "") {
VannualTax = 0;
VmonthlyTax =0;
} else {
VannualTax = stripNum(VannualTax);
VmonthlyTax = VannualTax / 12;
VmonthlyTax *= 100;
VmonthlyTax = Math.round(VmonthlyTax);
VmonthlyTax /= 100;
}
var VannualInsurance = document.mortgagePayment.annualInsurance.value;
var VmonthlyInsurance = 0;
if(VannualInsurance == 0 || VannualInsurance == "") {
VannualInsurance = 0;
VmonthlyInsurance = 0;
} else {
VannualInsurance = stripNum(VannualInsurance);
VmonthlyInsurance = VannualInsurance / 12;
VmonthlyInsurance *= 100;
VmonthlyInsurance = Math.round(VmonthlyInsurance);
VmonthlyInsurance /= 100;
}
var VmonthlyPMI = document.mortgagePayment.monthlyPMI.value;
if(VmonthlyPMI == 0 || VmonthlyPMI == "") {
VmonthlyPMI = 0;
} else {
VmonthlyPMI = stripNum(VmonthlyPMI);
}
var VotherPmts = eval(VmonthlyTax) + eval(VmonthlyInsurance) + eval(VmonthlyPMI);
var VnumPmts = VnumYears * 12;
var pmtAmt = computeMonthlyPayment(Vprincipal, VnumPmts, VintRate);
var VtotalMtgPmt = eval(pmtAmt) + eval(VotherPmts);
var prin = Vprincipal;
var Vint = VintRate;
if(Vint >= 1) {
Vint /= 100;
}
Vint /= 12;
var nPer = VnumPmts;
var intPort = 0;
var accumInt = 0;
var prinPort = 0;
var accumPrin = 0;
var count = 0;
var pmtRow = "";
var pmtNum = 0;
var today = new Date();
var dayFactor = today.getTime();
var pmtDay = today.getDate();
var loanMM = today.getMonth() + 1;
var loanYY = today.getYear();
if(loanYY < 1900) {
loanYY += 1900;
}
var loanDate = (loanMM + "/" + pmtDay + "/" + loanYY);
var monthMS = 86400000 * 30.4;
var pmtDate = 0;
var displayPmtAmt = 0;
var accumYearPrin = 0;
var accumYearInt = 0;
while(count < nPer) {
if(count < (nPer - 1)) {
intPort = prin * Vint;
intPort *= 100;
intPort = Math.round(intPort);
intPort /= 100;
accumInt = eval(accumInt) + eval(intPort);
accumYearInt = eval(accumYearInt) + eval(intPort);
prinPort = eval(pmtAmt) - eval(intPort);
prinPort *= 100;
prinPort = Math.round(prinPort);
prinPort /= 100;
accumPrin = eval(accumPrin) + eval(prinPort);
accumYearPrin = eval(accumYearPrin) + eval(prinPort);
prin = eval(prin) - eval(prinPort);
displayPmtAmt = eval(prinPort) + eval(intPort);
} else {
intPort = prin * Vint;
intPort *= 100;
intPort = Math.round(intPort);
intPort /= 100;
accumInt = eval(accumInt) + eval(intPort);
accumYearInt = eval(accumYearInt) + eval(intPort);
prinPort = prin;
accumPrin = eval(accumPrin) + eval(prinPort);
accumYearPrin = eval(accumYearPrin) + eval(prinPort);
prin = 0;
//pmtAmt = eval(intPort) + eval(prinPort);
displayPmtAmt = eval(prinPort) + eval(intPort);
}
count = eval(count) + eval(1);
pmtNum = eval(pmtNum) + eval(1);
dayFactor = eval(dayFactor) + eval(monthMS);
pmtDate = new Date(dayFactor);
pmtMonth = pmtDate.getMonth();
pmtMonth = pmtMonth + 1;
pmtYear = pmtDate.getYear();
if(pmtYear < 1900) {
pmtYear += 1900;
}
pmtString = (pmtMonth + "/" + pmtDay + "/" + pmtYear);
pmtRow = ("" + pmtRow + "| " + pmtNum + " | " + pmtString + " | " + formatCurrency(prinPort) + " | " + formatCurrency(intPort) + " | " + formatCurrency(displayPmtAmt) + " | " + formatCurrency(prin) + " |
");
if(pmtMonth == 12 || count == nPer) {
pmtRow = ("" + pmtRow + "| Total | " + pmtYear + " | " + formatCurrency(accumYearPrin) + " | " + formatCurrency(accumYearInt) + " | | |
");
accumYearPrin = 0;
accumYearInt = 0;
}
if(count > 600) {
alert("Using your current entries you will never pay off this loan.");
break;
} else {
continue;
}
}
var part1 = ("Amortization Schedule" + "
Amortization Schedule");
var part2 = ("Loan Date: " + loanDate + "
Principal: $" + formatNumber(Vprincipal) + "
# of Payments: " + nPer + "
Interest Rate: " + formatNumber(VintRate) + "%
Payment: $" + formatNumber(pmtAmt) + " |
Schedule of Payments
Please allow for slight rounding differences. |
| Pmt # | Date | Principal | Interest | Payment | Balance |
");
var part3 = ("" + pmtRow + "");
var totalPmts = eval(accumPrin) + eval(accumInt);
var part4 = ("| Grand Total | " + formatCurrency(accumPrin) + " | " + formatCurrency(accumInt) + " | " + formatCurrency(totalPmts,2,1) + " | |