See exactly how a loan is repaid. Enter the loan amount, the annual interest rate and the term to build a monthly repayment schedule with principal, interest and balance for every period, and export it as a CSV file. These results are estimates for general information only and are not financial, investment or tax advice. Actual figures depend on the terms of your lender or provider and your local tax rules.
100% Local
How to Use the Loan Amortization Calculator
Enter the loan amount, the annual interest rate and the term in years, then press Calculate. The tool builds a monthly repayment schedule and lets you export it as CSV.
Reading the schedule
Payment is the amount paid each month.
Principal is the part of the payment that reduces the balance.
Interest is the cost of borrowing for that month.
Balance is what is still owed; it reaches zero at the end of the term.
Exporting
Use Export CSV to download the full schedule and open it in a spreadsheet.
Features
Full monthly repayment schedule with period, payment, principal, interest and balance
Export the whole schedule as a CSV file
Monthly payment, total interest and total paid
Choose your currency and copy the result
All processing runs locally in your browser. Your data is not uploaded to any server.
These results are estimates for general information only and are not financial, investment or tax advice. Actual figures depend on the terms of your lender or provider and your local tax rules.