Loan Repayment Schedule

An Excel file that teaches how to perform Loan Repayment Schedule operation.

Excel Format: Loan Repayment Schedule

The amount, maturity and interest rate are entered into the entry fields. The difference between interest and principal is calculated for each period. The remaining debt column clearly shows the decrease over time.

Hope it is useful.