Loan Amortization Explained: How to Read

Introduction

You sign for a 30-year mortgage, and the lender hands you a sheet showing 360 rows of numbers. Each row is a month, and the columns show something like “payment,” “principal,” “interest,” and “balance.” If you have never seen an amortization schedule before, the whole thing looks like a wall of noise.

It is not. Once you understand the logic behind loan amortization, every single row on that schedule makes complete sense — and more importantly, you can use that understanding to make smarter decisions about extra payments, refinancing, and total interest costs.

This guide explains what amortization is, shows you the formula behind every payment, walks through a full worked example with real numbers, and covers the mistakes most borrowers make when they misread their schedule.

What Is Loan Amortization?

Amortization is the process of paying off a debt through regular, equal payments over time. The word comes from the Old French amortir, meaning “to kill off” — and that is exactly what happens: each payment chips away at the debt until it reaches zero at the end of the loan term.

What makes amortization interesting — and what trips most people up — is that even though your monthly payment stays the same for the entire loan, the split between principal and interest changes with every single payment.

Early in the loan, most of your payment goes to interest. Late in the loan, most of it goes to principal. This is not a trick or a penalty. It is a direct mathematical consequence of how interest is calculated on a declining balance.

The Amortization Formula

The fixed monthly payment on a fully amortizing loan is calculated with this formula:

M = P × [r(1 + r)^n] / [(1 + r)^n − 1]

Where:

M = Monthly payment
P = Principal loan amount (the amount you are borrowing)
r = Monthly interest rate (annual rate ÷ 12)
n = Total number of payments (loan term in years × 12)

This formula produces the one fixed payment that, when applied every month, will reduce the balance from P to exactly zero after n payments — accounting for the interest that accrues each month.

Breaking Down Each Payment

Once you know M, you can calculate exactly how any given payment splits into interest and principal:

Interest portion of payment k:

Interest_k = Balance_(k−1) × r

Principal portion of payment k:

Principal_k = M − Interest_k

Remaining balance after payment k:

Balance_k = Balance_(k−1) − Principal_k

These three lines are all you need to build an entire amortization table from scratch.

Step-by-Step Worked Example

Let us use a real loan so the numbers are concrete.

Loan details:

Principal (P): $200,000
Annual interest rate: 6%
Loan term: 30 years (360 monthly payments)

Step 1: Convert the Annual Rate to a Monthly Rate

r = 6% ÷ 12 = 0.5% = 0.005

Step 2: Calculate the Fixed Monthly Payment

M = 200,000 × [0.005 × (1.005)^360] / [(1.005)^360 − 1]

First, calculate (1.005)^360:

(1.005)^360 ≈ 6.0226

Now plug that in:

M = 200,000 × [0.005 × 6.0226] / [6.0226 − 1]
M = 200,000 × [0.030113] / [5.0226]
M = 200,000 × 0.005996
M ≈ $1,199.10

Your fixed monthly payment is $1,199.10.

Step 3: Build the First Few Rows of the Schedule

Payment 1:

Interest: $200,000 × 0.005 = $1,000.00
Principal: $1,199.10 − $1,000.00 = $199.10
Remaining 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
Remaining balance: $199,800.90 − $200.10 = $199,600.80

Payment 3:

Interest: $199,600.80 × 0.005 = $998.00
Principal: $1,199.10 − $998.00 = $201.10
Remaining balance: $199,600.80 − $201.10 = $199,399.70

Notice what is happening: the interest portion drops by roughly $1 each month, and the principal portion rises by roughly $1. The changes are small at first, but they compound. By payment 180 (year 15), the split looks like this:

Payment 180 (approximate):

Interest: ~$578
Principal: ~$621
Remaining balance: ~$115,600

And by payment 359 (the second-to-last payment):

Interest: ~$12
Principal: ~$1,187
Remaining balance: ~$1,187

At that point, nearly every dollar goes to principal.

Step 4: Calculate Total Interest Paid

Over 360 payments at $1,199.10 each:

Total paid = $1,199.10 × 360 = $431,676
Total interest = $431,676 − $200,000 = $231,676

You pay $231,676 in interest over the life of a $200,000 loan at 6%. That is more than the original loan itself. This is not a mistake or a gotcha — it is the cost of borrowing money over 30 years, and seeing it clearly on an amortization schedule is one of the most powerful reasons to understand how these tables work.

What Happens With One Extra Payment Per Year

If you make one extra principal-only payment of $1,199.10 per year (13 payments instead of 12), you would:

Pay off the loan roughly 4.5 years early
Save approximately $40,000–$45,000 in total interest

The early extra payments matter most because they reduce a large balance, which reduces the interest that compounds on top of it. A $1,200 extra payment in year 1 saves far more interest than the same payment in year 25.

How to Read Your Amortization Table

Most lenders provide an amortization schedule either at closing or through your online account portal. Here is what each column means:

Column	What It Shows
Payment #	Which payment in the sequence (1 through 360 for a 30-year loan)
Payment Date	The calendar date the payment is due
Payment Amount	Your fixed monthly payment (M from the formula)
Principal	How much of this payment reduces your loan balance
Interest	How much of this payment is interest cost for the month
Remaining Balance	The loan balance after this payment is applied

One thing to watch for: Some lenders show cumulative totals in additional columns — “total interest paid to date” and “total principal paid to date.” These are useful for tracking your progress but can cause confusion if you assume they are per-payment figures rather than running totals.

Common Mistakes When Reading an Amortization Schedule

Mistake 1: Assuming Extra Payments Automatically Reduce Future Monthly Payments

When you make an extra payment, the lender typically applies it to principal — which reduces your balance and therefore the total interest you will pay. But your required monthly payment does not change. You will simply pay the loan off earlier. If you want your monthly payment to change, you need to ask the lender to recast the loan, which is a formal process that not all lenders offer.

Mistake 2: Confusing Interest Rate With APR

Your amortization schedule uses the stated interest rate (also called the note rate). The APR (Annual Percentage Rate) is higher because it includes fees amortized over the loan term. The schedule itself does not use APR — so if you are trying to replicate your lender’s numbers, always use the stated rate, not APR.

Mistake 3: Thinking You Build Equity Quickly in the Early Years

On a 30-year mortgage, you pay off roughly only 10% of the original principal in the first 10 years. This catches many homeowners off guard, especially those who expect significant equity after a decade of payments. The amortization schedule makes this visible: look at the “Remaining Balance” column at year 10 and compare it to your starting balance.

Mistake 4: Ignoring How Loan Term Affects Total Cost

Shorter loan terms mean higher monthly payments but dramatically less total interest. A $200,000 loan at 6% over 15 years has a monthly payment of about $1,688, but total interest of only around $103,000 — compared to $231,000 over 30 years. The amortization formula makes this comparison easy to run before you commit to a term.

Mistake 5: Applying Extra Payments Without Specifying “Principal Only”

If you send extra money with your payment without instructions, many lenders apply it as an early payment on the next scheduled payment — which does not reduce your balance in the same way as a direct principal reduction. Always designate extra payments as “principal only” in writing, and verify on your next statement that the balance dropped accordingly.

Frequently Asked Questions

Q1: Why do I pay so much more interest at the start of my loan?

Because interest is calculated on your outstanding balance, and that balance is at its highest right when the loan begins. The formula ensures each payment covers the interest that accrued that month first, with the remainder reducing principal. As the balance falls, so does the monthly interest charge — freeing up more of your fixed payment to attack the principal.

Q2: Can I build my own amortization table in a spreadsheet?

Yes, and it is a useful exercise. Set up columns for Payment #, Beginning Balance, Monthly Payment, Interest (= Beginning Balance × monthly rate), Principal (= Monthly Payment − Interest), and Ending Balance (= Beginning Balance − Principal). Row 1 starts with your full loan amount. Each subsequent row references the Ending Balance from the row above. The table fills itself out automatically from there.

Q3: What happens to my amortization schedule if I refinance?

Refinancing creates a brand new amortization schedule starting at payment 1. This means you restart the interest-heavy early phase of the loan. If you refinance a 30-year mortgage after 5 years into another 30-year loan, you are extending your total repayment horizon by 5 years — even if the new rate is lower. Always compare total interest paid under both scenarios, not just monthly payment amounts.

Q4: Does an amortization schedule work the same way for all loan types?

The standard amortization formula applies to fully amortizing, fixed-rate loans (mortgages, auto loans, personal loans). Adjustable-rate mortgages (ARMs) use the same formula but recalculate when the rate adjusts, creating a new payment for the remaining term. Interest-only loans and balloon loans follow different structures and do not produce the standard declining-balance schedule described here.

Q5: How much interest can I save by making biweekly payments instead of monthly?

With biweekly payments, you make 26 half-payments per year, which is equivalent to 13 full monthly payments rather than 12. On the $200,000 example above, biweekly payments would save roughly $35,000–$40,000 in total interest and cut about 4–5 years off a 30-year loan. The savings come from both the extra annual payment and the fact that principal reduces slightly faster, lowering the base on which interest compounds.

Conclusion

Loan amortization is one of those concepts that looks complicated until you see the mechanics. Every payment follows the same three steps: calculate interest on the current balance, subtract it from your fixed payment, and apply the rest to principal. Repeat 359 more times, and the loan is gone.

What makes amortization tables genuinely useful is not the mechanics themselves — it is what they reveal. You can see exactly how much of your money goes to the lender versus how much you keep as equity. You can calculate the precise savings from an extra payment. You can compare the true cost of a 15-year versus a 30-year term. You can decide whether refinancing actually helps you, or just resets your interest clock.

If you want to run these calculations instantly for your own loan — including monthly payment, total interest, full amortization schedule, and the impact of extra payments — use the loan and mortgage calculators at NovaCalculator.com. Every figure in this article can be verified and customized there in seconds.

Frequently Asked Questions

Why do I pay so much more interest at the start of my loan? +

Can I build my own amortization table in a spreadsheet? +

What happens to my amortization schedule if I refinance? +

Does an amortization schedule work the same way for all loan types? +

How much interest can I save by making biweekly payments instead of monthly? +

With biweekly payments, you make 26 half-payments per year, which is equivalent to 13 full monthly payments rather than 12. On a $200,000 loan at 6%, biweekly payments would save roughly $35,000–$40,000 in total interest and cut about 4–5 years off a 30-year loan.