Free loan amortization schedule template for Excel
A loan amortization schedule in Excel: enter amount, rate and term to get the payment and a full schedule of interest, principal and balance, with extra payments.
What's in this template
Schedule sheet
2,525 formulas.
- Loan amortization schedule
- Loan amount
- Annual interest rate
- Term in years
- Payments per year
- First payment date
- Extra payment each period
- Scheduled 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