How to read an amortization schedule, row by row

The first time you open an amortization schedule, it looks like a spreadsheet someone forgot to finish: 360 rows of numbers that barely change from one line to the next. Most people glance at the first row, scroll to the last, and close it. That is a shame, because the rows in the middle answer the questions borrowers actually lose sleep over: how much of my payment is really mine, when does that change, and what happens if I pay a little extra?

This guide walks through a real 30-year schedule line by line, using a $250,000 mortgage at 6.75%. Every figure below comes from that one loan, so you can check it against our amortization calculator as you read.

What each column on an amortization schedule means

Lenders format schedules differently, but nearly all of them carry the same five pieces of information. Once you know what each column is telling you, the whole table becomes readable.

Two things are deliberately missing. Property tax and homeowners insurance are usually collected with your mortgage payment through an escrow account, but they never appear on the schedule because they do not reduce the loan. And the schedule assumes you pay exactly on time, every time; a late or early payment shifts the numbers slightly.

Reading the first year of a real schedule

On $250,000 at 6.75% for 30 years, the monthly payment is $1,621.50. Here is how the first year breaks down:

Look at the interest column first. In month one, $1,406.25 of a $1,621.50 payment goes to the lender. That is 87%. After a full year of payments totalling about $19,458, the balance has fallen by only $2,664. Nothing is wrong with the loan; this is simply how amortization works when the balance is at its largest.

Now look at the principal column. It grows by roughly a dollar a month. That tiny creep is the whole story of a mortgage: each payment shaves a little off the balance, so next month's interest is a little smaller, so a little more of the fixed payment is left for principal.

The one calculation behind every row

Every row of the schedule is produced by the same three steps. You can rebuild any line with a phone calculator:

Repeat with the new balance and you have month two. Do it 360 times and you have the whole schedule. The fixed payment itself comes from the standard loan formula, which we break down in how mortgage calculations work.

When does more of the payment go to principal than interest?

Somewhere in every schedule there is a row where the principal figure finally overtakes the interest figure. On our example loan it arrives in payment 238, almost 20 years in. The higher the rate, the later it comes:

This is why the first ten years of a mortgage feel so slow and why refinancing into a fresh 30-year loan resets the clock. You go back to the top of a new schedule, where interest dominates again.

How much of the house do you own after 5, 10 or 20 years?

The remaining-balance column doubles as an equity tracker. Subtract it from your original loan and you have the amount you have paid off, before any change in the home's value:

After ten years of payments you have repaid about 15% of the loan. After twenty, it is still under half. If you might sell within five to seven years, this column is the honest answer to how much cash you will take out of the sale from paying the mortgage alone.

What extra payments do to the schedule

Any money you pay above the scheduled amount goes straight to principal, which removes rows from the end of the schedule. Two common approaches, compared with paying exactly what the schedule says:

Notice that neither option lowers your monthly payment. Extra principal shortens the loan; it does not shrink the required payment unless you ask the lender to recast the mortgage, which some lenders allow for a fee after a large lump sum.

Car and personal loan schedules work the same way, just faster

A five-year car loan uses exactly the same three-step calculation, but because the term is short the balance falls quickly and interest is a much smaller share from the start. On a $30,000 auto loan at 7.5% over 60 months, the first payment of $601.14 includes $187.50 of interest, about 31%, and the split flips in favor of principal from the very first month. Many auto and personal loans also calculate interest daily rather than monthly, so paying a few days early or late moves each row by a few cents. See how to calculate a loan payment for the shorter-loan version of the math.

Four mistakes people make reading a schedule

• Reading total interest as the cost of the loan. The schedule's total interest assumes you keep the loan for its full term. Most mortgages are refinanced or paid off early, so your real interest cost is usually the sum of the rows you actually make.
• Expecting tax and insurance to appear. If your monthly bill is higher than the schedule's payment, the difference is escrow, not a mistake.
• Assuming extra payments are applied automatically to principal. Most servicers do, but some hold extra money as an advance on next month's payment. Mark it as "principal only" and check the next statement.
• Comparing schedules with different start dates. Interest accrues from the closing date, so a first payment that comes after a longer gap can carry slightly more interest than the schedule template shows.

How to get a schedule for your own loan

Your lender or servicer can provide one, and many show it in the online account. If you only have the loan amount, rate and term, the amortization calculator builds the same table in seconds, and you can test extra payments without phoning anyone. For the bigger decision of how long a term to choose in the first place, our 15 vs. 30-year mortgage calculator compares both schedules side by side.