Loan Amortization Schedule
Free Excel loan amortization schedule: level payments or equal principal, monthly, quarterly, half-yearly or yearly, interest and principal per payment, total interest.
Your country's version.
Each country has its two files: one fully French, one fully English. Direct download, no sign-up.
Get the template by e-mail, and its updates.
Keep the six files of « Loan Amortization Schedule » in your inbox, to find or share them later. The direct download stays free, no sign-up.
- The France, Québec and Africa versions, in French and English.
- If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
- Your details are never sold, one-click unsubscribe.
What the workbook contains.
Schedule
Up to 360 payments: balance, payment, interest, principal
Summary
Payment, total cost of credit, check
Two methods
Level payments or equal principal
Settings
Amount, rate, term, frequency, method
Instructions
Get started in 3 minutes, cells protected without password
Portrait, repeated headers
Up and running in minutes.
- 01
In the Settings sheet, enter the amount, annual rate, term, frequency and disbursement date.
- 02
Choose the method: level payments or equal principal.
- 03
The schedule builds itself; the last payment clears the balance exactly.
- 04
Compare the total cost of credit across several bank offers.
Your questions, answered.
In the same category.
The same cycle, automated.
Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.