Home Loan Amortization Calculator (Excel Version)
Use this calculator to determine your home loan amortization schedule based on loan amount, interest rate, and loan term.
Amortization Schedule
| Payment Number |
Payment Amount ($) |
Principal ($) |
Interest ($) |
Remaining Balance ($) |
document.getElementById(‘home-loan-amortization-form’).addEventListener(‘submit’, function(event) {
event.preventDefault();
let loanAmount = parseFloat(document.getElementById(‘loanAmount’).value);
let interestRate = parseFloat(document.getElementById(‘interestRate’).value) / 100 / 12;
let loanTerm = parseInt(document.getElementById(‘loanTerm’).value) * 12;
let monthlyPayment = (loanAmount * interestRate) / (1 – Math.pow(1 + interestRate, -loanTerm));
let tableBody = document.querySelector(‘#amortizationTable tbody’);
tableBody.innerHTML = ”;
let balance = loanAmount;
let totalInterest = 0;
for (let i = 1; i <= loanTerm; i++) {
let interestPayment = balance * interestRate;
let principalPayment = monthlyPayment – interestPayment;
balance -= principalPayment;
totalInterest += interestPayment;
let row = document.createElement('tr');
row.innerHTML = `
${i} |
${monthlyPayment.toFixed(2)} |
${principalPayment.toFixed(2)} |
${interestPayment.toFixed(2)} |
${Math.max(0, balance).toFixed(2)} |
`;
tableBody.appendChild(row);
}
document.getElementById(‘amortizationResults’).style.display = ‘block’;
});
