Amortization Schedule Calculator — Chart, Table, Extra Payments & Export
An amortization schedule lists every loan payment in chronological order, splitting each between interest and principal until the loan balance reaches zero. On a $250,000 loan at 6.5% for 30 years, the monthly payment is about $1,580; adding just $100/month in extra principal can save tens of thousands in interest and shorten your payoff date by several years. This free online calculator builds the full amortization table and chart, allowing you to instantly visualize your loan repayment. You can also export the schedule to a CSV for Excel or Google Sheets, or generate a printable PDF for your personal records.
Loan Details
Build a fixed-rate amortization schedule, table, and chart with optional extra principal.
Used to label the schedule and estimate the payoff date.
Optional extra monthly principal payment.
Formula: Payment = P x r(1 + r)^n / ((1 + r)^n - 1)
Amortization Schedule Results
Monthly payment, principal, interest, balance, payoff date, and interest saved.
Monthly Payment
$1,580.17
$318,861 total interest · paid off in 30 years
Annual Summary
Principal vs. Interest Chart
Annual bars show how each year shifts from interest-heavy payments toward principal payoff.
Monthly Amortization Schedule Table
Each row shows the payment date, scheduled payment, principal, interest, extra principal, and remaining balance.
| Month | Payment Date | Payment | Principal | Extra Principal | Interest | Balance |
|---|---|---|---|---|---|---|
| 1 | May 1, 2026 | $1,580.17 | $226.00 | $0.00 | $1,354.17 | $249,774.00 |
| 2 | Jun 1, 2026 | $1,580.17 | $227.23 | $0.00 | $1,352.94 | $249,546.77 |
| 3 | Jul 1, 2026 | $1,580.17 | $228.46 | $0.00 | $1,351.71 | $249,318.31 |
| 4 | Aug 1, 2026 | $1,580.17 | $229.70 | $0.00 | $1,350.47 | $249,088.61 |
| 5 | Sep 1, 2026 | $1,580.17 | $230.94 | $0.00 | $1,349.23 | $248,857.67 |
| 6 | Oct 1, 2026 | $1,580.17 | $232.19 | $0.00 | $1,347.98 | $248,625.48 |
| 7 | Nov 1, 2026 | $1,580.17 | $233.45 | $0.00 | $1,346.72 | $248,392.04 |
| 8 | Dec 1, 2026 | $1,580.17 | $234.71 | $0.00 | $1,345.46 | $248,157.32 |
| 9 | Jan 1, 2027 | $1,580.17 | $235.98 | $0.00 | $1,344.19 | $247,921.34 |
| 10 | Feb 1, 2027 | $1,580.17 | $237.26 | $0.00 | $1,342.91 | $247,684.07 |
| 11 | Mar 1, 2027 | $1,580.17 | $238.55 | $0.00 | $1,341.62 | $247,445.53 |
| 12 | Apr 1, 2027 | $1,580.17 | $239.84 | $0.00 | $1,340.33 | $247,205.69 |
Methodology and limitations
Last reviewed:
Methodology
Uses the standard fixed-payment amortization formula, converts annual rate to a monthly rate, and applies optional extra principal payments after each scheduled payment.
Limitations
Covers fixed-rate principal-and-interest schedules. It does not include taxes, insurance, PMI, HOA dues, lender fees, variable rates, or legal payoff rules.
Official sources
How to use the amortization calculator
Enter the loan amount, annual rate, term, and start date to generate a monthly amortization schedule, table, and chart. Whether you need an amortization table, amortization chart, loan amortization formula breakdown, or car loan amortization schedule view, this page shows how much of each payment goes to interest, how much reduces principal, and what balance remains.
Which amortization calculator should I use?
If you search for an amortization table, amortization chart, loan amortization formula, or car loan amortization schedule, start here for generic fixed-rate loans. Use a specialized calculator when your loan type needs different inputs:
Define amortization in a loan
Amortization is the process of paying down a loan through scheduled payments. Each payment covers the interest due for that period, then the remaining amount reduces principal. Over time, the balance falls and the loan reaches a payoff date.
Amortization schedule terms
These are the core fields in an amortization schedule, table, or chart.
| Payment date | The estimated date for each scheduled monthly payment. |
|---|---|
| Payment | The scheduled amount for the month, plus any extra payment applied. |
| Principal | The part of the payment that reduces the loan balance. |
| Interest | The borrowing cost charged for that monthly period. |
| Balance | The amount still owed after the payment is applied. |
| Payoff date | The estimated month when the loan balance reaches zero. |
How to read the amortization table
The amortization table turns one monthly payment into a full view of the loan. Use it to see the interest cost for each month, the principal reduction, and the remaining balance after each payment date.
- Payment: the scheduled amount due for that month before extra payments.
- Principal: the part of the payment that directly reduces the loan balance.
- Interest: the borrowing cost charged for that monthly period.
- Balance: the amount still owed after the payment is applied.
Sample amortization table
This example uses a $250,000 loan at 6.5% for 30 years with no extra payment. The live table above updates with your own loan values.
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $1,580.17 | $226.00 | $1,354.17 | $249,774.00 |
| 2 | $1,580.17 | $227.23 | $1,352.94 | $249,546.77 |
| 12 | $1,580.17 | $239.84 | $1,340.33 | $247,205.69 |
What the amortization chart shows
An amortization chart helps you see the shift from interest-heavy payments to principal-heavy payments. On a long fixed-rate loan, the first payments often go mostly toward interest; later payments reduce principal faster.
How the amortization formula works
For fixed-rate loans, the base payment uses the standard fixed-payment formula:
Payment = P x r(1 + r)^n / ((1 + r)^n - 1)
P is the loan amount, r is the monthly interest rate, and n is the total number of payments. If you add extra payments, the calculator applies them to principal after the scheduled payment.
Example: $250,000 loan at 6.5% for 30 years
With the default values, the estimated monthly principal-and-interest payment is about $1,580.17. In the early months, most of the payment covers interest; over time, more of each payment reduces the principal balance.
Amortization vs. amortisation
In U.S. English, the standard spelling is amortization. In British and international English, you may see amortisation. Both terms describe the same loan payment schedule with principal, interest, and remaining balance.
What this calculator includes and excludes
- Includes monthly principal and interest for fixed-rate loans.
- Includes a monthly table, payoff summary, remaining balance, and optional extra principal payments.
- Does not include property tax, home insurance, PMI, HOA dues, or closing costs.
- For a mortgage with full housing costs, use the mortgage calculator.
Extra payments and payoff date
An extra monthly payment reduces the balance faster. Because future interest is calculated on a smaller balance, you can lower total interest and pay the loan off earlier than the original schedule.
Does my amortization schedule change with extra payments?
Yes. The amortization schedule changes because the balance falls sooner. The scheduled monthly payment may stay the same, but each extra payment is applied to principal; after that, future monthly interest is calculated on a smaller remaining balance.
Example with an extra payment
If you add $100 per month to the default $250,000 loan at 6.5% for 30 years, the table recalculates the balance, total interest, and payoff date. Use the interest-saved row to compare the schedule with and without the extra principal payment.
Printable amortization schedule
To create a printable amortization schedule, enter the loan amount, rate, term, start date, and any extra payment. The PDF includes payment date, payment, principal, interest, and remaining balance for the full table.
Download a PDF or export the schedule
Use Download CSV to save the full table for Excel, Google Sheets, Numbers, or another spreadsheet app. Use Download PDF to generate a branded printable schedule with loan details, amortization summary, and every month in the amortization schedule.
Related calculators for comparison
Use the mortgage calculator when you need taxes, insurance, and PMI. Use the loan repayment schedule calculator for plain repayment language, or the auto loan calculator when the loan includes vehicle price, down payment, and trade-in value. mortgage calculator , loan repayment schedule calculator , auto loan amortization calculator .
Frequently Asked Questions
What is an amortization schedule?
An amortization schedule is a table that lists every loan payment in order, showing how much of each payment goes to interest, how much reduces principal, and the remaining balance after each month. Lenders use the same fixed-payment math for mortgages, auto loans, and personal loans, so early payments are mostly interest and later payments apply more to principal. This calculator builds a full amortization table and chart you can review online, export to CSV, or print as a PDF.
What is an amortization chart?
An amortization chart is a graph of your loan repayment schedule showing how each payment splits between interest and principal over time. Early months show a larger interest slice; later months apply more to principal as the balance falls. This calculator renders an interactive amortization chart alongside the full payment table so you can spot the crossover point where principal exceeds interest and compare base versus extra-payment scenarios visually.
Can I print an amortization schedule?
Yes. Click Download PDF to generate a printable amortization schedule with the complete payment table, including payment date, principal, interest, and remaining balance for every month. You can print the PDF from any viewer or save it for your records. The table matches the interactive chart on the page, so you can verify payoff date and total interest before printing.
How do you define amortization?
Amortization is the process of paying down a loan with a fixed schedule of payments until the balance reaches zero. Each payment covers interest on the remaining balance first, then applies the rest to principal. Monthly amortization is the standard for most U.S. mortgages and installment loans. An amortization chart visualizes the same data, showing how the interest portion shrinks and the principal portion grows over time.
How is the monthly loan payment calculated?
The calculator uses the standard fixed-payment amortization formula: Payment = P * r(1 + r)^n / ((1 + r)^n - 1), where P is the loan amount, r is the monthly interest rate (APR ÷ 12), and n is the total number of payments. This is the same loan payment formula banks use for fixed-rate loans. Enter principal, annual rate, and term to see the monthly payment and full amortization table.
Do extra payments reduce loan interest?
Yes. Extra principal payments reduce the remaining balance faster, so future interest is calculated on a smaller amount. That can cut thousands in total interest and move your payoff date earlier, even if your required monthly payment stays the same. Use the extra-payment field to model a monthly principal add-on and compare interest saved and months shaved off the schedule.
Does my amortization schedule change with extra payments?
Yes. When you add extra principal, the balance drops sooner, so less interest accrues in later months. The scheduled payment amount usually stays fixed, but more of each payment can go to principal after the extra amount is applied. The calculator shows a revised payoff date, total interest saved, and time saved compared with the base schedule without extras.
Can I export the amortization schedule to Excel or Google Sheets?
Yes. Use Download CSV to export the full amortization table with columns for payment number, date, payment amount, principal, interest, extra payment, and remaining balance. Open the file in Excel, Google Sheets, or Numbers to sort, filter, or build your own charts. This is useful for comparing scenarios or sharing a loan repayment schedule with a co-borrower or advisor.
Can this calculator be used for mortgages, auto loans, and personal loans?
Yes. It works for any fixed-rate loan with regular monthly payments and a known principal, APR, and term. Use it as a mortgage amortization table, car loan schedule, or personal loan repayment plan. Property taxes, insurance, PMI, and lender fees are not included here; use the mortgage calculator when you need those housing costs in the payment.
Why is the interest portion of my payment so high initially?
Because interest is calculated on the remaining loan balance each month, the interest charge is highest at the beginning of the loan when the balance is at its maximum. As you make payments and the balance decreases, the monthly interest charge shrinks, allowing a larger portion of your fixed monthly payment to go toward paying down the principal.
What happens to amortization if I make a large lump-sum payment?
A large lump-sum payment applied directly to the principal will immediately reduce your loan balance, which in turn reduces the amount of interest that accrues in all future months. While your required monthly payment typically remains the same (unless you recast the loan), you will pay off the loan much faster and save a significant amount of interest.