Templates › Loan EMI Calculator
Loan EMI Calculator Excel Template
Type the loan amount, interest rate and years. See the monthly EMI, the total you pay and the total interest.
⬇ Download free (.xlsx)Free · No sign-up · 7 KB · Works in Excel and Google Sheets
See it filled with data
The file has two sheets: a blank one for your own data, and this filled Example so you can see how it works.
What is inside
- Monthly EMI with the PMT function
- Total payment over the full loan
- Total interest you pay the bank
How to use it
- Type the loan amount.
- Type the yearly interest rate and the number of years.
- Read the EMI and total interest.
- Change the years to compare a short and a long loan.
Formulas used: PMT
⬇ Download the Loan EMI Calculator template
More free templates
InvoiceQuotationPayment TrackerExpense TrackerMonthly BudgetSales TrackerStock InventorySalary SheetAttendance SheetTask TrackerLead Tracker
