Code Breakdown
This application used the following functions:
Build Payment Schedule
Calculate the payment
Build the amoritization schedule
Display Data
Display Stats
//Build Payment Schedule
function buildSchedule() {
let loanAmount = Number(document.getElementById("lamount").value);
let rate = parseFloat(document.getElementById("lrate").value);
//convert rate to a monthly interest rate
rate = rate / 1200;
//Assume monthly input
let term = parseInt(document.getElementById("lterm").value);
let payment = calcPayment(loanAmount, rate, term);
let payments = getPayments(loanAmount, rate, term, payment);
//pass the array to the display function
displayData(payments);
}
//Calculate the payment for the loan
function calcPayment(amount, rate, term) {
return (amount * rate) / (1 - Math.pow(1 + rate, -term));
}
//Build the amoritization schedule
function getPayments(amount, rate, term, payment) {
//setup an array to hold payments;
//this will hold an array of objects
let payments = [];
//setup some variables to hold the value in the schedule
let balance = amount;
let totalInterest = 0;
let monthlyPrincipal = 0;
let monthlyInterest = 0;
let monthlyTotalInterest = 0;
//create a loop for each month of the loan term
for (month = 1; month <= term; month++) {
//Calculate the payment and interest
monthlyInterest = calcInterest(balance, rate);
totalInterest += monthlyInterest;
monthlyPrincipal = payment - monthlyInterest;
balance = balance - monthlyPrincipal;
//add the details to an object
let curPayment = {
month: month,
payment: payment,
principal: monthlyPrincipal,
interest: monthlyInterest,
totalInterest: totalInterest,
balance: balance
}
payments.push(curPayment);
}
let summary = {
payment: payment,
totalPrincipal: amount,
totalInterest: totalInterest,
totalCost: (amount + totalInterest)
}
payments.push(summary);
return payments;
}
//Build the amoritization schedule
function getPayments(amount, rate, term, payment) {
//setup an array to hold payments;
//this will hold an array of objects
let payments = [];
//setup some variables to hold the value in the schedule
let balance = amount;
let totalInterest = 0;
let monthlyPrincipal = 0;
let monthlyInterest = 0;
let monthlyTotalInterest = 0;
//create a loop for each month of the loan term
for (month = 1; month <= term; month++) {
//Calculate the payment and interest
monthlyInterest = calcInterest(balance, rate);
totalInterest += monthlyInterest;
monthlyPrincipal = payment - monthlyInterest;
balance = balance - monthlyPrincipal;
//add the details to an object
let curPayment = {
month: month,
payment: payment,
principal: monthlyPrincipal,
interest: monthlyInterest,
totalInterest: totalInterest,
balance: balance
}
payments.push(curPayment);
}
let summary = {
payment: payment,
totalPrincipal: amount,
totalInterest: totalInterest,
totalCost: (amount + totalInterest)
}
payments.push(summary);
return payments;
}
function displayData(payments) {
//get the table we are going to add to.
let tableBody = document.getElementById("scheduleBody");
let template = document.getElementById("scheduleTemplate");
//clear the table for previous calculations
tableBody.innerHTML = "";
for (let i = 0; i < payments.length - 1; i++) {
//get a clone row template
payRow = template.content.cloneNode(true);
//grab only the columns in the template
paycols = payRow.querySelectorAll("td");
//build the row
//we know that there are six columns in our template
paycols[0].textContent = payments[i].month;
paycols[1].textContent = payments[i].payment.toFixed(2);
paycols[2].textContent = payments[i].principal.toFixed(2);
paycols[3].textContent = payments[i].interest.toFixed(2);
paycols[4].textContent = payments[i].totalInterest.toFixed(2);
paycols[5].textContent = payments[i].balance.toFixed(2);
//append to the table
tableBody.appendChild(payRow);
}
let totalInterest = payments[payments.length - 1].totalInterest;
//calculate total cost
// payment: payment,
// totalPrincipal: amount,
// totalInterest: totalInterest,
// totalCost: (amount + totalInterest)
let payment = payments[payments.length - 1].payment;
let loanAmount = payments[payments.length - 1].loanAmount;
let totalCost = payments[payments.length - 1].totalCost;
//Build out the summary area
let labelPrincipal = document.getElementById("totalPrincipal");
labelPrincipal.innerHTML = Number(loanAmount).toLocaleString("en-US", {
style: "currency",
currency: "USD",
});
let labelInterest = document.getElementById("totalInterest");
labelInterest.innerHTML = Number(totalInterest).toLocaleString("en-US", {
style: "currency",
currency: "USD",
});
let paymentdiv = document.getElementById("payment");
paymentdiv.innerHTML = Number(payment).toLocaleString("en-US", {
style: "currency",
currency: "USD",
});
let totalCostDiv = document.getElementById("totalCost");
totalCostDiv.innerHTML = Number(totalCost).toLocaleString("en-US", {
style: "currency",
currency: "USD",
});
}