How to Read a Mortgage Amortization Schedule (Line by Line)

A mortgage amortization schedule is a table that shows, for every payment, how much goes to interest, how much goes to principal, and what balance remains. On a $400,000 mortgage at 6.5% over 30 years, the schedule has 360 rows — and after 10 years of payments, you still owe $339,104.51, or 84.8% of what you borrowed.

Lenders must provide this schedule, but few borrowers ever read it. That is a missed opportunity: the table answers the questions that matter most — how fast your equity is really growing, when principal finally overtakes interest, and whether extra payments are worth it. This guide reads a real schedule line by line, explains every column, and shows the year-by-year milestones for a $400,000 loan at 6.5%.

What Is an Amortization Schedule?

An amortization schedule is the full repayment plan for a fixed-rate mortgage, laid out month by month. Each row is one monthly payment, and the rows run from payment 1 to the final payment — 360 rows on a 30-year loan. The schedule is generated by the amortization formula M = P × r(1 + r)^n ÷ ((1 + r)^n − 1), where P is the loan amount, r the monthly rate, and n the payment count. For our example, the payment is $2,528.27 a month.

You can generate the same table for your own loan with a free mortgage amortization calculator, and compare it against the schedule your lender provides. Our guide to how does mortgage amortization work explains the mechanics behind the table if you want the full background first.

What Does Each Column Mean?

A standard schedule has six columns. Here is what each one tells you, using payment 1 of our example loan:

Column Payment 1 What it means
Payment number 1 Which monthly payment this row is — 1 to 360.
Payment amount $2,528.27 The fixed monthly payment, the same on every row.
Interest $2,166.67 The lender’s charge for this month: balance × monthly rate.
Principal $361.61 What is left of the payment after interest: $2,528.27 − $2,166.67.
Total interest paid $2,166.67 All interest paid so far, added up.
Remaining balance $399,638.39 What you still owe after this payment.

Three relationships hold on every row, and checking them is how you spot errors:

  1. Interest + principal = payment. On payment 1: $2,166.67 + $361.61 = $2,528.27. If a row does not add up, something is wrong.
  2. Interest = previous balance × monthly rate. The monthly rate is 0.065 ÷ 12 = 0.0054167. On payment 1: $400,000 × 0.0054167 = $2,166.67.
  3. New balance = old balance − principal. On payment 1: $400,000 − $361.61 = $399,638.39.

The last row is the proof that the schedule works: on payment 360, the interest is only $13.62, the principal is $2,514.65, and the remaining balance is exactly $0.00. If the final balance is not zero, the schedule was built with the wrong payment.

How Do You Read a Single Row, Step by Step?

Take payment 120 — the last payment of year 10 — and read it left to right:

  1. Payment number 120. You are ten years into the loan, with 240 payments left.
  2. Payment amount $2,528.27. Unchanged since payment 1, as it will be until the end.
  3. Interest $1,840.54. The balance before this payment was $339,792.24; multiply by 0.0054167 and you get $1,840.54. Still the bigger half of the payment, even after a decade.
  4. Principal $687.73. That is $2,528.27 − $1,840.54 — nearly double the $361.61 of principal in payment 1, but still less than the interest.
  5. Total interest paid $242,497.16. You have now paid almost half of all the interest the loan will ever cost.
  6. Remaining balance $339,104.51. Ten years of payments have removed only $60,895.49 from the loan.

Now compare that with payment 240, the last payment of year 20: interest $1,213.20, principal $1,315.07, balance $222,661.13. By then the split has flipped — principal is finally the bigger half — and the balance is falling by more than $1,300 a month. Reading two rows ten years apart shows the whole story of amortization in miniature.

What Do the Year-by-Year Balances Look Like?

Most people do not read all 360 rows. They read the yearly checkpoints. Here they are for the $400,000 loan at 6.5%:

After Balance Paid off Interest paid so far
Year 1 $395,529.10 1.1% $25,868.36
Year 5 $374,443.91 6.4% $126,140.24
Year 10 $339,104.51 15.2% $242,497.16
Year 15 $290,236.56 27.4% $345,325.54
Year 20 $222,661.13 44.3% $429,446.43
Year 25 $129,216.65 67.7% $487,698.28
Year 30 $0.00 100% $510,177.95

The pattern to notice is the acceleration. In the first five years the balance falls by only $25,556.09. In the five years from year 20 to year 25, it falls by $93,444.48 — nearly four times as much — even though the payment never changes. That is amortization working in your favor at last: by year 20, most of each payment is principal, so the balance drops fast.

When Does Principal Overtake Interest?

The crossover row is the most searched-for line in any schedule. On this loan it is payment 233, in year 20: interest $1,262.00, principal $1,266.27, balance after the payment $231,719.15. Before that row, interest is bigger; after it, principal is bigger, and the gap widens every month.

Here is the split at the yearly checkpoints so you can see the crossover approaching:

Payment Interest Principal Balance
1 $2,166.67 $361.61 $399,638.39
60 $2,030.93 $497.34 $374,443.91
120 $1,840.54 $687.73 $339,104.51
180 $1,577.27 $951.01 $290,236.56
233 $1,262.00 $1,266.27 $231,719.15
240 $1,213.20 $1,315.07 $222,661.13
300 $709.77 $1,818.50 $129,216.65
360 $13.62 $2,514.65 $0.00

If your schedule’s crossover comes much earlier or later than you expect, check the rate and term first — a lower rate or a shorter term moves the crossover years earlier. A 15-year loan at the same rate crosses over far sooner, which is one reason its total interest is so much lower: $227,197.30 versus $510,177.95.

How Do You Spot Errors in a Schedule?

Schedules are generated by software, so errors are rare — but the numbers you type into a calculator can be wrong, and a lender’s schedule can use different assumptions than you expected. Check these five things:

  1. The payment is identical on every row. A fixed-rate schedule has one payment, $2,528.27 here. A varying payment means the schedule is for an adjustable-rate loan, or it is wrong.
  2. Interest plus principal equals the payment on every row you check. Pick three rows — the first, one in the middle, and the last — and add them up.
  3. The final balance is exactly zero. After payment 360 the balance must be $0.00. A leftover balance means the payment was rounded or the term is wrong.
  4. The interest falls every month. Each row’s interest must be slightly smaller than the row above it, because the balance is shrinking. Any increase is a red flag.
  5. The totals match your loan estimate. Total interest here is $510,177.95 and total paid is $910,177.95. If your lender’s schedule shows a different total, ask which rate, term, or starting balance they used — the formula is standard, so a mismatch always has a specific cause.

Also watch for rows that include escrow, PMI, or taxes. Those are real monthly costs, but they are not part of amortization: they do not reduce the balance and they do not appear in the interest column. A schedule that mixes them in will overstate both your interest and your progress. Our explainer on what PMI is covers the most common extra charge.

Frequently Asked Questions

How do I read a mortgage amortization schedule?
Read each row left to right: the payment number, the fixed payment amount, the interest charged that month, the principal portion, the running total of interest paid, and the balance that remains. Interest plus principal always equals the payment, and the balance after the last payment is zero.

Why is the balance still so high after 10 years?
Because interest is front-loaded. On a $400,000 loan at 6.5%, after 10 years you have paid $242,497.16 in interest but only $60,895.49 of principal, leaving a balance of $339,104.51.

What is the interest portion in the first payment?
On a $400,000 loan at 6.5% over 30 years, month 1 interest is $2,166.67 out of a $2,528.27 payment, with only $361.61 going to principal.

When does principal overtake interest on a 30-year mortgage?
On a $400,000 loan at 6.5%, principal first exceeds interest at payment 233, in year 20 — $1,266.27 of principal versus $1,262.00 of interest that month.

How do I check if my amortization schedule is correct?
Verify that interest plus principal equals the payment on several rows, that interest falls every month, and that the final balance is exactly zero. You can also generate the expected table with a free amortization calculator and compare it row by row. If the totals differ from your loan estimate, ask the lender which rate, term, or starting balance they used.

Does my schedule include taxes and insurance?
Usually not. A pure amortization schedule covers principal and interest only. Taxes, insurance, and PMI are escrow items that appear on your monthly statement but do not reduce the loan balance.

Word count: ~1,657
Numbers verified: python3 amortization run — payment $2,528.27; month 1 interest $2,166.67 / principal $361.61 / balance $399,638.39; payment 60 interest $2,030.93 / principal $497.34 / balance $374,443.91; payment 120 interest $1,840.54 / principal $687.73 / balance $339,104.51; payment 180 interest $1,577.27 / principal $951.01 / balance $290,236.56; payment 233 interest $1,262.00 / principal $1,266.27 / balance $231,719.15; payment 240 interest $1,213.20 / principal $1,315.07 / balance $222,661.13; payment 300 interest $709.77 / principal $1,818.50 / balance $129,216.65; payment 360 interest $13.62 / principal $2,514.65 / balance $0.00; balances after 1/5/10/15/20/25/30 years $395,529.10 / $374,443.91 / $339,104.51 / $290,236.56 / $222,661.13 / $129,216.65 / $0.00; cumulative interest after 120/180/240/300 payments $242,497.16 / $345,325.54 / $429,446.43 / $487,698.28; total interest $510,177.95, total paid $910,177.95; balance below $300,000 at payment 170, below $200,000 at payment 257, below $100,000 at payment 316; 15-year total interest $227,197.30.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top