Loan Amortization Schedule

What is an Amortization Schedule?

An amortization schedule is the month-by-month plan that shows exactly how a fixed-rate loan is paid off: every payment, how much of it goes to interest, how much to principal, and what balance remains. This tool generates the full schedule for any loan you describe, with a balance-over-time chart, sortable columns, year filter, and CSV / Markdown export.

How to Use the Amortization Schedule

1. 1Enter the loan amount, annual interest rate, and term
2. 2Optionally add an extra monthly payment to model accelerated payoff
3. 3Optionally pick a start date so payments map to real calendar months
4. 4Filter the table to a specific year, sort columns, and export
5. 5Use the CSV download for spreadsheets, or Copy as Markdown for docs / GitHub

Key features

Why Use a Dedicated Schedule Generator?

Spreadsheet PMT formulas give you the EMI, but reconstructing the full schedule with cumulative interest, year-aware filtering, and sortable export is fiddly. This tool turns that into a single click and adds CSV / Markdown export, a balance chart, and multi-currency support out of the box.

Common use cases

• Print or PDF a schedule for a personal-finance binder
• Show your accountant exactly how much interest will be paid in the next tax year
• Compare two refinance scenarios by exporting both schedules to a spreadsheet
• Document a loan in a project README with a clean Markdown table
• Plan an extra-payment strategy by sorting by interest and targeting the highest-interest months first
• Visualise the "halfway point": when does the balance hit 50% of the original?

How rounding works

The schedule uses Decimal.js arithmetic and rounds each row to two decimal places. The final period adjusts the principal to settle the remaining balance to exactly zero (this is what banks do: your last payment is sometimes a few cents different from the rest).

Cumulative interest column

• Cumulative interest is the running total of interest paid through that month
• Useful for tax filings (in some jurisdictions, mortgage interest is deductible)
• Also helps you measure progress: when does cumulative interest stop being more than principal?

Tips & best practices

Privacy & security