Mortgage Amortization Schedule Calculator: How to Read (and Use) Your Loan Table

Most buyers look at one number: the monthly payment. The amortization schedule shows you what's hiding behind it — and it changes everything about how you think about your mortgage.

An amortization schedule is a complete month-by-month table showing exactly how each payment splits between interest and principal, how much you owe after each payment, and how much cumulative interest you've paid. Understanding it isn't optional; it's the foundation of every smart mortgage decision.

The Math Behind Every Mortgage Payment

Your monthly principal and interest payment is calculated using this formula:

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

Where P is your loan amount, r is the monthly interest rate (annual rate ÷ 12), and n is the total number of payments.

For a $300,000 loan at 7.0% for 30 years: monthly rate = 0.005833, n = 360.

That produces a payment of $1,995.93 — fixed for the entire life of the loan. The payment never changes on a fixed-rate mortgage. But what that payment does changes dramatically month to month.

Why Early Payments Are Almost Entirely Interest

Here's the part that shocks most buyers. On that same $300,000, 7% loan:

• Month 1: $1,750 goes to interest. Only $245.93 reduces your balance.
• Month 60 (Year 5): $1,644 goes to interest. $351 reduces your balance.
• Month 120 (Year 10): $1,495 goes to interest. $500 reduces your balance.
• Month 240 (Year 20): $970 goes to interest. $1,025 reduces your balance.

After five years of payments — 60 payments totaling roughly $119,755 in cash — you've only paid down the principal balance by about $18,000. The other $101,000 went to the lender as interest.

This isn't a scam. It's just compound math working in the lender's favor. Every month, interest is calculated on whatever balance remains. Because the balance is highest at the start, so is the interest portion.

How to Read a Loan Amortization Table

A standard table has six columns:

Work through a few rows and patterns emerge quickly:

• The Interest column shrinks every single month (because the balance shrinks)
• The Principal column grows every single month
• They cross somewhere around month 200–230 on a 30-year loan — that's when you're finally paying more principal than interest
• The Balance column is what you actually owe if you sold or paid off the loan that day

For UK buyers: the same math applies to repayment mortgages, though your initial fixed-rate term typically ends at 2, 3, or 5 years — your payment resets when you remortgage.

For Australian and New Zealand buyers: your amortization works the same way, but interest is often calculated daily rather than monthly. Offset account balances reduce the principal before interest calculates each day, which accelerates your schedule compared to what any monthly table shows.

For Canadian buyers: fixed-rate mortgages compound semi-annually rather than monthly. A standard US amortization formula will overstate your interest. The effective monthly rate must be derived from the semi-annual rate, making Canadian mortgage math genuinely different.

The Total Interest Number

On a 30-year, $300,000 loan at common rates, the cumulative interest is staggering:

• At 6.0%: $347,514 in total interest
• At 6.5%: $382,633 in total interest
• At 7.0%: $418,526 in total interest
• At 7.5%: $455,144 in total interest

A 1% rate difference costs you roughly $72,500 over the life of the loan. That's why shopping for the best rate isn't just about saving $66 a month — it's about a potential $72,000 difference in total wealth.

The total interest formula is simple: multiply your monthly payment by total months, then subtract the original loan amount. The remainder is what you paid the lender for the privilege of borrowing.

How Extra Payments Collapse the Schedule

The most powerful use of an amortization table is modeling what happens when you make extra principal payments. Because interest calculates on remaining balance, any extra payment permanently reduces every future interest charge.

On a $300,000 loan at 7.0%:

• Adding $200/month extra cuts roughly 5 years off the loan and saves over $60,000 in interest
• Adding one extra full payment per year (biweekly payment strategy) cuts approximately 5.5 years and saves $65,000–$70,000

The biweekly strategy works because 52 weeks ÷ 2 = 26 half-payments per year, which equals 13 full payments instead of 12. That one extra annual payment attacks principal faster than the schedule expects.

One critical caveat: verify that your loan servicer credits biweekly payments immediately on receipt. Some hold the mid-month half-payment in a suspense account until the second half arrives, which eliminates the intra-month interest benefit entirely.

The 15-Year vs. 30-Year Comparison

A shorter term radically changes your amortization. On a $300,000 loan at 6.0%:

• 30-year: $1,798/month, $347,514 total interest
• 20-year: $2,149/month, $215,838 total interest
• 15-year: $2,531/month, $155,683 total interest

Moving from 30 to 15 years costs you $733 more per month but saves $191,831 in interest. Whether that's worth it depends entirely on your income stability, other investment options, and how much that $733 would earn if invested instead.

When Amortization Math Really Matters

Three situations where knowing your schedule changes your decision:

Before refinancing: Check your current balance against your original balance. If you're 8 years into a 30-year loan, you still owe roughly 87% of your original balance. Refinancing into a new 30-year loan restarts the front-loaded interest clock.

Before buying discount points: Points reduce your rate permanently. The break-even is simple: cost of points ÷ monthly savings = months to break even. If you're moving in 4 years, there's no point paying $7,000 upfront for savings that require 5+ years to recover.

Before selling: Your equity is your sale price minus your remaining balance. Use the amortization schedule to know exactly what you'll walk away with before signing a listing agreement.

The Mortgage Math & Affordability Calculator Toolkit includes a complete, exportable amortization schedule that lets you model extra payments, compare terms side-by-side, and see the crossover point where principal overtakes interest — all without feeding your financial details into a lead-generation portal.

What the Schedule Doesn't Show

The amortization table covers principal and interest only. It doesn't include property taxes, homeowners insurance, PMI (if applicable), HOA fees, or maintenance costs. Your actual monthly cash outflow is higher — often by $400–$800 depending on location and property type. That gap between the P&I payment and the true monthly cost is where most buyer budgets break down.

Understanding your amortization schedule gives you the foundation. Building the full cost picture on top of it is what turns that foundation into a financially sound home purchase.