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.
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.
A standard amortization schedule has five columns. Here is what each one tells you:
Here is the amortization schedule for a $200,000 loan at 6% annual rate over 30 years, showing key rows from start to finish:
| Payment | Total Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 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 |
The monthly payment figure tells you what you owe each month. The amortization schedule tells you four things the payment alone cannot:
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.
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:
| Rate | Monthly Payment | Total Interest | Total 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.
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 →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.
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.
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.
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.
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.
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.