Amortization calculator
Loan Calculator
Highlighted workbook fields are inputs; the schedule and outputs update automatically.
Loan parameters
Enter the values from your Excel sheet.
Your details
Loan
EMI uses the workbook’s monthly PMT calculation.
Tenure (months)
—EMI
—Total interest
—Loan repayment schedule
Total payable: —
| No. | EMI | Interest | Principal | Balance O/S |
|---|
Outstanding loan balance
Balance reduces with every EMI