Free EMI calculator template for Excel
An EMI calculator in Excel for home, car or personal loans: monthly EMI, total interest and a month-by-month repayment schedule.
What's in this template
Schedule sheet
2,525 formulas.
- EMI calculator and repayment schedule
- Loan amount
- Annual interest rate
- Term in years
- Payments per year
- First payment date
- Extra payment each period
- EMI (monthly payment)
- Number of payments
- Total interest
- Total paid
- Last payment
- No.
- Date
- Opening balance
- Payment
- Interest
- Principal
- Closing balance
Find it in: Loan amortization schedule and EMI calculator