Home Loan Calculator Excel Sheet

let calculationSteps = “”; const currencySymbol = “$”, fixedCurrency = “USD”; function calculateHomeLoan(){ calculationSteps = “”; const loanAmount = parseFloat(document.getElementById(“loanAmount”).value); const interestRate = parseFloat(document.getElementById(“interestRate”).value) / 100; const loanTerm = parseFloat(document.getElementById(“loanTerm”).value) * 12; // convert years to months if(isNaN(loanAmount) || isNaN(interestRate) || isNaN(loanTerm) || loanAmount <= 0 || interestRate <= 0 || loanTerm <= 0){ alert("Please enter valid positive values for all fields."); return; } const monthlyRate = interestRate / 12; const monthlyRepayment = loanAmount * monthlyRate / (1 – Math.pow(1 + monthlyRate, -loanTerm)); const totalRepayment = monthlyRepayment * loanTerm; document.getElementById("monthlyRepayment").value = formatCurrency(monthlyRepayment); document.getElementById("totalRepayment").value = formatCurrency(totalRepayment); calculationSteps += `Inputs:
Loan Amount: ${formatCurrency(loanAmount)}
Interest Rate: ${(interestRate * 100).toFixed(1)}%
Loan Term: ${loanTerm / 12} years

`; calculationSteps += `Formulas:
Monthly Repayment = Loan Amount × Monthly Interest Rate / (1 – (1 + Monthly Interest Rate)^(-Loan Term))
Total Repayment = Monthly Repayment × Loan Term

`; calculationSteps += `Results:
Monthly Repayment: ${formatCurrency(monthlyRepayment)}
Total Repayment: ${formatCurrency(totalRepayment)}
`; if(document.getElementById(“calculationSteps”).style.display === “block”){ document.getElementById(“calculationSteps”).innerHTML = calculationSteps; } } function resetHomeLoan(){ document.querySelectorAll(“#calculator input”).forEach(el => el.value = “”); calculationSteps = “”; document.getElementById(“calculationSteps”).innerHTML = “

Not calculated yet.

“; } function toggleCalculationSteps(){ const steps = document.getElementById(“calculationSteps”); const arrow = document.getElementById(“toggleArrow”); if(steps.style.display === “none” || steps.style.display === “”){ steps.style.display = “block”; arrow.style.transform = “rotate(180deg)”; steps.innerHTML = calculationSteps || “

Not calculated yet.

“; } else { steps.style.display = “none”; arrow.style.transform = “rotate(0deg)”; } } function formatCurrency(n) { return currencySymbol + n.toFixed(2) + ” ” + fixedCurrency; }