Skip to main content

Online Calculator Lab

💰 Finance

How to Read an Amortization Schedule — A Plain-Language Guide

⏱ 7 min read ✍️ Online Calculator Lab
⚠️ Financial Disclaimer: All figures in this article are for informational purposes only. Consult a qualified financial advisor before making any loan or mortgage decisions.

An amortization schedule is one of the most useful documents a borrower can have — and one of the most ignored. Most people sign a loan, note the monthly payment, and never look at the schedule again. That is a mistake, because the schedule tells you things the payment alone does not: how much of each payment actually reduces your debt, when you will cross the halfway point, and exactly how much your loan costs in total.

This guide explains what every column in an amortization schedule means, how to use the schedule to make smarter decisions about your loan, and how to generate a complete schedule for any loan in seconds.

📌 Quick Definition — Amortization Schedule

An amortization schedule is a complete table of every loan payment, showing the payment number, total payment, interest paid, principal paid, and remaining balance for each period. It reveals the true cost of the loan and the pace at which the balance falls over time.

What Each Column in the Schedule Means

A standard amortization schedule has five columns. Here is what each one tells you:

Payment Number
The sequential number of the payment, starting at 1. For a 30-year monthly loan, this runs from 1 to 360. Lets you quickly find any point in the loan timeline.
Total Payment
The fixed amount due each period. For a standard fixed-rate loan this never changes. What changes is the split between interest and principal within that amount.
Interest Paid
The interest charged for that period, calculated as: remaining balance × monthly rate. This column starts high and falls with every payment as the balance shrinks.
Principal Paid
The amount that actually reduces your debt. Total payment minus interest. Starts small and grows with every payment as interest charges fall.
Remaining Balance
What you still owe after this payment. This is the column that matters most for understanding equity, refinancing decisions, and the true payoff progress of your loan.
Cumulative Interest
Some schedules include this — the running total of all interest paid to date. Seeing this grow month by month is clarifying: by mid-loan on most 30-year mortgages, cumulative interest already exceeds the original loan amount.

Verified Example — $200,000, 6%, 30 Years

Here is the amortization schedule for a $200,000 loan at 6% annual rate over 30 years, showing key rows from start to finish:

PaymentTotal PaymentInterestPrincipalBalance
1$1,199.10$1,000.00$199.10$199,800.90
2$1,199.10$999.00$200.10$199,600.80
3$1,199.10$998.00$201.10$199,399.71
12$1,199.10$988.77$210.33$197,543.98
60 (yr 5)$1,199.10$938.30$260.80$187,401.61
120 (yr 10)$1,199.10$862.34$336.76$172,231.62
180 (yr 15)$1,199.10$712.92$486.18$142,097.69
240 (yr 20)$1,199.10$551.32$647.78$109,616.58
300 (yr 25)$1,199.10$331.81$867.29$65,694.65
360 (final)$1,199.10$5.97$1,193.14$0.00
How Each Row Is Calculated
Monthly rate: 6% ÷ 12 = 0.5% = 0.005

Payment 1:
Interest = $200,000 × 0.005 = $1,000.00
Principal = $1,199.10 − $1,000.00 = $199.10
New balance = $200,000 − $199.10 = $199,800.90

Payment 2:
Interest = $199,800.90 × 0.005 = $999.00
Principal = $1,199.10 − $999.00 = $200.10
New balance = $199,800.90 − $200.10 = $199,600.80

Each month: interest falls by ~$1, principal grows by ~$1
By month 360: interest = $5.97 | principal = $1,193.14

What the Schedule Reveals That the Payment Does Not

The monthly payment figure tells you what you owe each month. The amortization schedule tells you four things the payment alone cannot:

  • Your equity at any point. The balance column shows exactly what you owe at every payment. Your equity is your property value minus that balance. On a $200,000 loan at year 5, the balance is roughly $187,000 — meaning you have built about $13,000 in principal equity from payments (plus any property value change).
  • The true cost of the loan. Adding all interest column values gives the total interest cost: $231,676.38 for this example. The payment alone ($1,199.10) does not reveal this.
  • When you cross the halfway point on interest. You do not pay half the interest at the halfway point of the loan. On a 30-year loan, most of the interest is paid in the first 15–20 years due to front-loading. The schedule shows you exactly when cumulative interest paid exceeds cumulative principal paid.
  • The impact of refinancing or extra payments. If you refinance at year 10, you start a new schedule from a $172,000 balance. The schedule shows you exactly what balance you carry into a refinance — which determines whether the refinance makes financial sense.
💡 Expert Insight

After one full year (12 payments) of a $200,000 mortgage at 6%, you have paid $14,389.20 in total. But your balance has only fallen from $200,000 to $197,543.98 — a reduction of $2,456.02. Of every dollar paid in year 1, only 17 cents reduced the loan balance. The other 83 cents paid interest. This ratio gradually improves each year — but it takes until roughly year 22 before more than half of each payment goes to principal on a standard 30-year amortizing loan.

3 Practical Ways to Use Your Amortization Schedule

  • Find your break-even point for refinancing. Refinancing resets your amortization — you start paying mostly interest again on the new loan. Use the schedule to find your current balance, then calculate the new schedule after refinancing. If the interest savings on the new rate exceed the closing costs before you plan to sell or pay off the loan, refinancing makes sense. If not, you may end up paying more over the combined term.
  • Plan extra payments strategically. The schedule shows which months have the highest interest charges — the early months. A single extra payment applied in month 6 eliminates one entire row from the end of the schedule, saving that row's interest charge. Extra payments applied early have maximum impact; the same amount applied in year 25 saves far less.
  • Verify your lender's calculations. Generate your own amortization schedule from the free amortization calculator and compare it against your loan statement. The balance column should match your lender's balance figures. If there is a consistent discrepancy, it may indicate that extra charges, insurance, or escrow items are being included in your payment — worth understanding clearly.

How the Rate Changes the Schedule — $250,000 Loan, 20 Years

The interest rate is the biggest variable in any amortization schedule. Here is how different rates change the monthly payment and total interest on a $250,000 loan over 20 years:

RateMonthly PaymentTotal InterestTotal Paid
5.0%$1,649.89$145,973.44$395,973.44
6.0%$1,791.08$179,858.64$429,858.64
6.5%$1,863.93$197,343.88$447,343.88
7.0%$1,938.25$215,179.36$465,179.36
8.0%$2,091.10$251,864.04$501,864.04

The difference between 5% and 8% on a $250,000 loan over 20 years is $105,890.60 in additional interest — paid on the same borrowed amount. This is why rate negotiations and credit score improvements before taking a loan have such high financial returns. For a full guide to how loan rates work, the CFPB's mortgage rate explorer is a useful reference. Investopedia's explanation of how mortgage rates work covers the mechanics behind rate setting.

Generate your own amortization schedule for any rate and loan amount using the free amortization calculator. You can also use the mortgage calculator and loan calculator for related calculations.

Generate Your Amortization Schedule Free

Enter any loan amount, rate, and term. Get the complete payment-by-payment schedule showing interest, principal, and balance for every month — instantly.

Free Amortization Calculator →

Frequently Asked Questions

What is an amortization schedule?

An amortization schedule is a complete table showing every payment in a loan — the payment number, total payment, interest portion, principal portion, and remaining balance after each payment. It reveals the true cost of the loan and the exact pace at which the balance falls. Generate yours instantly with the free amortization calculator.

How do I read an amortization schedule?

Each row represents one payment. The interest column = remaining balance × monthly rate. The principal column = total payment − interest. The balance column = previous balance − principal paid. Early rows have high interest and low principal; later rows have high principal and low interest. The pattern shifts gradually across the loan term — not at the midpoint.

Why does the principal portion increase over time?

Because interest is calculated on the remaining balance, which falls each month as you repay principal. With less balance, less interest is charged. Since the total payment stays fixed, the portion that goes to principal grows as interest shrinks. This creates a gradual shift — by the final payment on a 30-year loan, nearly 100% of the payment goes to principal.

How do I find how much equity I have using an amortization schedule?

Find your current payment number in the schedule and read the remaining balance. Your equity from loan repayment is your original purchase price minus that balance. If the property has appreciated, your total equity is current market value minus remaining balance. The amortization calculator generates the full schedule — find your current payment number to read your balance.

How much interest is paid in the first year of a $200,000 mortgage at 6%?

In the first 12 payments: total paid = $14,389.20, total interest = $11,933.18, total principal = $2,456.02. The balance falls from $200,000 to $197,543.98. So 83% of year 1 payments go to interest and only 17% reduce the balance. This ratio improves each year but it takes until roughly year 22 before the principal portion exceeds the interest portion in each payment.

What is the difference between amortizing and simple interest loan schedules?

An amortizing (reducing balance) schedule recalculates interest each month on the current balance — interest charges fall as you repay principal. A simple (flat rate) interest schedule charges the same interest amount every month based on the original loan balance, regardless of how much you have repaid. Reducing balance loans are cheaper for the same rate because interest charges decrease over time.

Reviewed by: Online Calculator Lab Editorial Team
This content has been reviewed for accuracy and follows accepted calculation methods where applicable. All figures are verified using Python amortization logic. The rate comparison table uses the standard fixed-rate loan formula. These examples are for illustration only — consult a qualified financial professional before making loan decisions.