Loan Amortization Schedule Calculator (Excel Version)
Loan Amortization Schedule Calculator
Calculate your loan amortization schedule, showing monthly payments, principal, interest, and balance over time.
Not calculated yet.
Loan Amount: ${formatCurrency(loanAmount)}
Interest Rate: ${(interestRate * 100).toFixed(1)}%
Loan Term: ${loanTerm} years
`; amortizationSteps += `Formulas:
Monthly Payment = Loan Amount × (Monthly Interest Rate / (1 – (1 + Monthly Interest Rate)^(-Number of Payments)))
Total Paid = Monthly Payment × Number of Payments
`; amortizationSteps += `Results:
Monthly Payment: ${formatCurrency(monthlyPayment)}
Total Paid Over Loan Term: ${formatCurrency(totalPaid)}
`; if(document.getElementById(“calculationStepsAmortization”).style.display===”block”){ document.getElementById(“calculationStepsAmortization”).innerHTML = amortizationSteps; } } function resetAmortization(){ document.querySelectorAll(“#calculator input”).forEach(el=>el.value=””); amortizationSteps=””; document.getElementById(“calculationStepsAmortization”).innerHTML=”
Not calculated yet.
“; } function toggleAmortizationSteps(){ const s=document.getElementById(“calculationStepsAmortization”); const a=document.getElementById(“toggleArrowAmortization”); if(s.style.display===”none”||s.style.display===””){ s.style.display=”block”;a.style.transform=”rotate(180deg)”; s.innerHTML=amortizationSteps||”Not calculated yet.
“; }else{s.style.display=”none”;a.style.transform=”rotate(0deg)”;} } function formatCurrency(n){return currencySymbol+n.toFixed(2)+” “+fixedCurrency;}This loan amortization schedule calculator helps you calculate monthly payments, principal, interest, and total paid over the life of the loan, using Excel format for easy tracking.