Free Amortization Table Generator — Full Loan Repayment Schedule
Enter any loan and get a full month-by-month amortization schedule with principal, interest, and balance columns — exportable as Excel.
Last updated: January 2026
Amortization Table Generator
What is a loan amortization table?
An amortization table breaks every loan payment into its two components: the portion that reduces your principal balance and the portion that pays interest to the lender. In the early months of a loan, the majority of each payment is interest. Over time, as the principal decreases, more of each payment goes toward the balance. This shift is called amortization.
Understanding your amortization schedule matters because it shows you exactly how much of your money is actually reducing debt versus going to the lender as profit. A 30-year mortgage at 7% means your first payment is roughly 80% interest — a fact that changes how you evaluate refinancing, early repayment, and extra payments.
How extra monthly payments affect your loan
Adding even a small extra payment each month has a dramatic effect on the total interest you pay over the life of a loan. On a $300,000 30-year mortgage at 6.5%, adding $200 per month to your payment cuts approximately 5 years from the loan term and saves over $80,000 in interest. This tool lets you model that scenario directly — enter your extra payment amount and see the new payoff date and total interest savings.
The key insight is that extra payments applied to principal are most valuable early in the loan, when the outstanding balance is highest and interest accrues fastest.
Mortgage vs auto loan vs business loan amortization
All three loan types use the same amortization math, but the terms differ significantly. Mortgages run 15-30 years with relatively low rates (currently 6-8% in the US). Auto loans run 36-84 months at 5-12%. Business term loans typically run 3-10 years at 6-15%. Enter the specific parameters for your loan type and the table adjusts automatically — there is no separate mode for each loan type.
How to export your amortization schedule to Excel
Click Export as Excel after generating your table. The download includes every month in the schedule as a row with five columns: payment number, date, payment amount, principal paid, interest paid, and remaining balance. The final row shows totals. You can use this file for further analysis, share it with a lender, or import it into accounting software.
Frequently asked questions
How accurate is the amortization calculation?
The calculation uses the standard amortization formula used by banks and mortgage lenders. Results match what you would get from Excel's PMT function or a bank's official schedule.
Can I model a loan with a balloon payment?
This tool models fully amortizing loans — loans where the balance reaches zero at the end of the term. Balloon payment structures are not currently supported.
What does extra monthly payment mean?
It is an additional amount you pay each month on top of your regular payment. The extra amount is applied entirely to principal, reducing your balance faster and cutting total interest.
Can I use this for an adjustable-rate mortgage?
This tool models fixed-rate loans only. For an ARM, use the initial fixed rate to see the schedule for the fixed period.
Why does my first payment have so much interest?
Interest accrues on the full outstanding balance. At the start of the loan, the balance is highest, so the interest charge is largest. As you pay down the principal, the interest portion of each payment gradually decreases.