Home Loan EMI Calculator in Excel Download

Home Loan EMI Calculator

Use this calculator to determine your monthly EMI (Equated Monthly Installment) for a home loan.

Loan Amount (₹) Interest Rate (%) Loan Term (Years) Monthly EMI (₹)

This Home Loan EMI Calculator allows you to easily calculate your monthly EMI based on the loan amount, interest rate, and loan tenure. The result helps you plan your finances and budget your monthly expenses.

Formula

EMI = P × r × (1+r)^n / ((1+r)^n-1)

P = Loan Amount, r = Monthly Interest Rate (Annual Interest Rate/12/100), n = Loan Tenure in Months

Example Calculation

Loan Amount: ₹500,000, Interest Rate: 7.5%, Loan Term: 20 Years → EMI = ₹3,873.47

function calculateEMI(){ 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 el.value = “”); document.getElementById(“emiResult”).value = “”; }

Home Loan Emi Calculator in Excel Download

Home Loan EMI Calculator in Excel Download