Amortization Calculator
Easily calculate your loan amortization schedule with this free tool. Input the loan details to generate an amortization table.
Loan Amount ($)
Interest Rate (%)
Loan Term (Years)
Calculate
Reset
function calculateAmortization() {
const loanAmount = parseFloat(document.getElementById(“loanAmount”).value);
const interestRate = parseFloat(document.getElementById(“interestRate”).value) / 100 / 12;
const loanTerm = parseInt(document.getElementById(“loanTerm”).value) * 12;
if (isNaN(loanAmount) || isNaN(interestRate) || isNaN(loanTerm) || loanAmount <= 0 || interestRate <= 0 || loanTerm <= 0) {
alert("Please enter valid positive values for all fields.");
return;
}
const monthlyPayment = loanAmount * interestRate / (1 – Math.pow(1 + interestRate, -loanTerm));
let amortizationTable = "
Month Payment Interest Principal Balance ${month} $${monthlyPayment.toFixed(2)} $${interestPayment.toFixed(2)} $${principalPayment.toFixed(2)} $${Math.max(balance, 0).toFixed(2)}
“;
document.getElementById(“amortizationResults”).innerHTML = amortizationTable;
}
function resetAmortization() {
document.querySelectorAll(“#amortization_calculator_form input”).forEach(el => el.value = “”);
document.getElementById(“amortizationResults”).innerHTML = “”;
}
This free amortization calculator for Excel helps you calculate your loan payments over time, with detailed interest and principal breakdowns for each payment.
Example Calculation
A loan of $10,000 at 5% interest for 15 years would result in monthly payments and detailed amortization tables showing principal and interest splits.
Why Use This Calculator?
This tool allows you to quickly visualize your loan payments and plan for your finances, helping you understand the impact of loan terms on your monthly and total payments.
