Loan Amortization Schedule Calculator
Calculate your loan amortization schedule, model extra principal payments, and export your payoff plan to CSV.
Loan Terms
Accelerate your payoff date and save thousands in compound interest
Base: $1896.20 + Extra: $100.00
| Year | Principal Paid | Interest Paid | Ending Balance |
|---|---|---|---|
| Year 1 | $4,590 | $19,365 | $295,410 |
| Year 2 | $4,897 | $19,057 | $290,513 |
| Year 3 | $5,225 | $18,730 | $285,289 |
| Year 4 | $5,575 | $18,380 | $279,714 |
| Year 5 | $5,948 | $18,006 | $273,766 |
| Year 6 | $6,347 | $17,608 | $267,419 |
| Year 7 | $6,772 | $17,183 | $260,647 |
| Year 8 | $7,225 | $16,729 | $253,422 |
| Year 9 | $7,709 | $16,245 | $245,713 |
| Year 10 | $8,225 | $15,729 | $237,488 |
| Year 11 | $8,776 | $15,178 | $228,712 |
| Year 12 | $9,364 | $14,591 | $219,348 |
| Year 13 | $9,991 | $13,963 | $209,357 |
| Year 14 | $10,660 | $13,294 | $198,697 |
| Year 15 | $11,374 | $12,580 | $187,323 |
| Year 16 | $12,136 | $11,819 | $175,187 |
| Year 17 | $12,949 | $11,006 | $162,239 |
| Year 18 | $13,816 | $10,139 | $148,423 |
| Year 19 | $14,741 | $9,213 | $133,682 |
| Year 20 | $15,728 | $8,226 | $117,954 |
| Year 21 | $16,782 | $7,173 | $101,172 |
| Year 22 | $17,905 | $6,049 | $83,267 |
| Year 23 | $19,105 | $4,850 | $64,162 |
| Year 24 | $20,384 | $3,570 | $43,778 |
| Year 25 | $21,749 | $2,205 | $22,029 |
| Year 26 | $22,029 | $749 | $0 |
How Loan Amortization Works
With standard fixed-rate amortized loans, your total monthly payment remains identical throughout the entire term. However, the internal composition of each payment shifts dramatically over time: early payments are heavily weighted toward interest charges, while later payments consist almost entirely of principal reduction.
The Monthly Payment Formula
Loan Planning Applications
- ✓Mortgage Early Payoff Planning
Model how adding an extra $100 or $250 each month to your mortgage principal dramatically cuts loan duration and saves tens of thousands in interest.
- ✓Commercial & Personal Loan Auditing
Understand exactly what portion of each monthly payment goes towards paying down debt principal versus paying bank finance charges.
- ✓Refinancing Cost-Benefit Comparison
Compare an existing 30-year amortization curve against a new 15-year fixed rate schedule to verify interest savings.
- ✓Tax Deductible Mortgage Interest Estimation
Review the exact dollar amount of mortgage interest paid per year for Schedule A itemized tax deductions.
Why Use This Amortization Calculator
Extra Principal Payment Accelerator
Calculates exact years and months shaved off your loan term alongside cumulative interest saved.
Complete Annual Schedule Table
Detailed yearly breakdown showing beginning balance, principal paid, interest paid, and year-end remaining principal balance.
Instant CSV Spreadsheet Export
Download your full custom amortization schedule into a CSV file compatible with Microsoft Excel, Google Sheets, and Apple Numbers.
Flexible Multi-Year Terms
One-click switching between standard 15, 20, 25, and 30-year mortgage and commercial loan horizons.
Frequently Asked Questions
What is an amortization schedule?
An amortization schedule is a complete table of periodic loan payments that shows the exact amount of principal and interest comprising each payment until the loan is paid off at maturity.
Why is early mortgage payment mostly interest?
Because interest is calculated as a percentage of your remaining outstanding balance. In early years, when the principal balance is at its highest, interest charges consume the majority of your monthly payment. As the principal diminishes, less interest accrues, and a larger portion goes toward paying off the loan balance.
How do extra principal payments save money?
Extra payments reduce your principal balance directly. Since interest in subsequent months is calculated on a smaller balance, your future interest charges shrink permanently, shortening the life of the loan.
Can I download this schedule for Excel or Google Sheets?
Yes! Click the 'CSV' button at the top right of the calculator to download your customized amortization table directly to your computer.
More Mortgage Tools
Need a Brain Break? ☕
Done working on your task? Take a quick 60-second break, test your reflexes, and flap through infinite pixel obstacles in Sky Flap!