Introduction: The Table Your Bank Gives You But Rarely Explains
A mortgage amortization schedule looks intimidating because it turns one loan into hundreds of rows. On a 30-year mortgage, the table can run to 360 monthly entries. Many borrowers glance at the first line, check the payment, and ignore the rest. That is a mistake. The amortization schedule is the single most transparent document in the whole mortgage process, because it shows exactly how each payment is split, how slowly or quickly the balance falls, and how much interest you will actually pay if you keep the loan as signed.
Once you know how to read the table, you can spot bad assumptions, compare two mortgages properly, estimate the value of extra payments, and verify whether a lender's quote matches the mechanics of a standard amortizing loan. It also gives you a better feel for why the early years of a mortgage feel interest-heavy and why seemingly small changes in rate or term produce large changes in total cost.
In this guide we will use a concrete example: a €200,000 mortgage over 30 years at 4%. The monthly payment for principal and interest is about €954.83. We will read the table column by column, explain the interest-versus-principal curve, identify the red flags that matter, and show how to use the schedule in actual decisions. If you want to verify the numbers live, open the Mortgage Calculator while you read.
Anatomy of a Row
Every row in an amortization schedule is a snapshot of one payment period. A serious mortgage calculator or bank schedule usually shows at least six columns: payment number or date, beginning balance, payment amount, interest portion, principal portion, and ending balance. Good schedules also show cumulative interest and cumulative principal, which are incredibly useful for understanding how much progress you have really made.
| Payment | Beginning balance | Payment | Interest | Principal | Ending balance | Cumulative interest | Cumulative principal |
|---|---|---|---|---|---|---|---|
| 1 | €200,000.00 | €954.83 | €666.67 | €288.16 | €199,711.84 | €666.67 | €288.16 |
| 12 | €196,776.83 | €954.83 | €655.92 | €298.91 | €196,477.93 | €7,935.89 | €3,522.07 |
| 120 | €157,996.10 | €954.83 | €526.65 | €428.18 | €157,567.92 | €72,147.59 | €42,432.08 |
| 240 | €94,947.12 | €954.83 | €316.49 | €638.34 | €94,308.78 | €123,468.13 | €105,691.22 |
| 360 | €951.66 | €954.83 | €3.17 | €951.66 | €0.00 | €143,739.01 | €200,000.00 |
Payment Number or Date
This tells you where you are in the life of the loan. Payment 1 is the first instalment after closing. Payment 360 is the final one on a 30-year monthly mortgage. When borrowers refinance, overpay, or receive a revised statement, this column is the easiest way to see whether the schedule has actually changed or whether only the presentation changed.
Beginning Balance
The beginning balance is what you owe at the start of the period. It is the number on which the interest for that month is calculated. If the balance is wrong, every downstream number will be wrong too. This is why even a simple typo in the opening balance or the monthly rate creates visible differences down the schedule.
Payment Amount
For a standard fixed-rate mortgage under the French amortization method, the principal-and-interest payment is constant. In our example it is €954.83 every month. If your bank table shows a changing payment on what is supposed to be a fixed-rate standard mortgage, that is the first thing to question. There may be escrow or fee components mixed in, or you may not be looking at a pure principal-and-interest schedule.
Interest Portion
This is the lender's charge for the period, calculated from the beginning balance. In month 1, the interest is €666.67. By month 240, it has dropped to €316.49. By month 360, only €3.17 of the last payment is interest. Watching this column fall over time is the clearest way to understand why early extra payments matter so much.
Principal Portion
The principal portion is simply the payment minus the interest. It tells you how much of the current payment actually reduces the debt. In month 1 only €288.16 goes to principal. In month 240 it is €638.34. In the final month, almost the whole payment wipes out the balance. This shifting relationship is the heart of mortgage amortization.
Ending Balance and Cumulative Columns
The ending balance is the amount you still owe after that payment. The cumulative columns show the running totals of what you have paid in interest and principal. These are extremely useful for real-world decisions because they tell you not just what happens this month, but what the mortgage has already cost you up to a given point.
The Interest-vs-Principal Curve
The first emotional shock for many borrowers is seeing how little of the early payment goes to principal. That is not a trick; it is the direct consequence of interest being calculated on the largest possible balance at the start of the mortgage. In our €200,000 example, month 1 is about 70% interest and 30% principal. Even at month 120, after ten years of payments, the interest portion is still larger than the principal portion.
The crossover point in this specific loan arrives around month 153. That is when the principal portion finally exceeds the interest portion. Until then, the loan feels slow because so much of each payment is servicing the lender's return rather than shrinking the debt.
This is also why extra payments made early save disproportionately more interest than extra payments made late. If you reduce the balance in year two, you prevent decades of future interest from accruing on that amount. If you reduce the balance in year twenty-five, the remaining interest runway is much shorter. Our guide to extra payments explores that dynamic across loans in more detail.
Red Flags to Look For
Negative Amortization
If a schedule ever shows a principal portion below zero, the loan is negatively amortizing: your payment is not even covering the interest due, and the balance is growing. This is unusual in plain residential mortgages but can appear in teaser-rate or special-structure products. It is always worth flagging immediately.
Unexpected Payment Jumps
A fixed-rate amortization schedule should not suddenly jump in the principal-and-interest payment column. If it does, check whether you are actually reading an adjustable-rate schedule, whether taxes and insurance have been blended in, or whether the schedule has been revised after a rate reset or recast.
Mismatch Between Bank Table and Independent Calculation
If the balance path or the interest split differs materially from an independent calculation, do not assume the bank is right. Verify the rate, the payment frequency, the opening balance, and whether the quoted payment includes escrow. Then run the same numbers in the Mortgage Calculator. A good borrower does not need to accuse anyone of wrongdoing; they just need to know enough to ask the right question.
Using Your Schedule for Decisions
A schedule is not just a reporting table. It is a decision tool. If you are wondering whether refinancing makes sense, compare the remaining balance and cumulative interest in your current schedule against the new loan terms. If you are considering an extra annual payment, watch how the ending balance curve changes. If you are deciding between two mortgages, compare total cumulative interest at year five, year ten, and maturity instead of comparing only the monthly payment.
This is also where the schedule becomes useful for behavioral planning. Some borrowers feel discouraged by how slowly principal moves in the early years. But once you can see the curve, you can make better decisions: adjust term, raise the payment, or choose a different product structure. Our related guides on mortgage calculator variables and how mortgage amortization works help frame those choices.
Three Checkpoints Worth Comparing in Any Schedule
If you do not want to study 360 rows, compare three moments: the end of year 1, the end of year 10, and the projected final year. Year 1 tells you how interest-heavy the early schedule is. Year 10 tells you whether the loan is still dominated by interest or whether principal has started to catch up. The final year shows the true total cost and how much of the payment eventually becomes principal.
These checkpoints are especially useful when comparing two offers that look similar on the first screen. Two mortgages may differ by only a fraction of a point in rate, but the year-10 cumulative-interest gap can still be large enough to matter. This is why a good amortization table is not just educational. It is one of the most practical comparison tools a borrower has.
They are also useful if you expect to sell or refinance before maturity. A borrower who plans to move in year 7 should care far more about the balance and cumulative interest at year 7 than about the theoretical last payment in year 30. The schedule lets you compare mortgages over the horizon you are actually likely to live through, not just the horizon printed on the contract.
For many borrowers, that practical horizon is the most relevant one, because real life rarely follows the original 30-year script from closing day to final payment.
Conclusion: Read the Table, Not Just the Headline Payment
The amortization schedule is where the mortgage stops being an abstract promise and becomes a visible sequence of cash flows. Once you understand the columns, you can see how much of your money is still going to interest, when principal finally takes over, and what the total cost of staying in the loan really looks like.
That makes the schedule one of the most useful borrower tools in the whole mortgage journey. Learn to read it line by line, verify it independently with the Mortgage Calculator, and use it to compare scenarios before you sign. The borrowers who understand the table make materially better decisions than the borrowers who stop at the monthly payment.