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