Mortgage Amortization Schedule: How to Calculate Your Payment and Payoff

When you sign a mortgage, you commit to a fixed monthly payment for decades — but that single number hides a story that changes with every payment you make. In the early years, most of what you send to the lender is interest, with only a sliver chipping away at what you actually owe. By the final years, the proportions have flipped. An amortization schedule is the month-by-month map of this transformation, showing exactly how each payment splits between principal and interest and how your balance falls to zero. This guide explains how the monthly payment is calculated, how the schedule is built, and how to use it to make smarter borrowing decisions.

What an Amortization Schedule Is and Why It Matters

A mortgage amortization schedule is a complete table of every payment over the life of the loan. For each month it shows the payment amount, how much goes to interest, how much goes to principal, and the remaining balance afterward. "Amortization" simply means paying off a debt in regular instalments that fully clear it by the end of the term.

It matters because the monthly payment, on its own, tells you almost nothing about the true cost of borrowing. Two loans with identical payments can carry wildly different total interest depending on rate and term. The schedule exposes that cost. It reveals how much of your money goes to the lender as interest versus how much builds your equity in the home.

The schedule also explains a fact that surprises many first-time buyers: for years, your balance barely moves. Because interest is charged on the outstanding balance, early payments are mostly interest and build equity slowly. Understanding this shapes real decisions — whether to make extra payments, how much a lower rate truly saves, and whether refinancing is worth it.

How to Calculate the Monthly Payment

Every amortization schedule starts from one figure: the fixed monthly payment. The standard formula is:

M = P × [ r(1 + r)ⁿ ] ÷ [ (1 + r)ⁿ − 1 ]

Where M is the monthly payment, P is the loan principal, r is the monthly interest rate (the annual rate divided by 12), and n is the total number of payments (years × 12). The formula sizes the payment so that, with interest accruing each month on the remaining balance, the loan reaches exactly zero on the final payment.

Worked example. Suppose you borrow $300,000 at a 6% annual interest rate over 30 years.

1. Find the monthly rate: 6% ÷ 12 = 0.5%, or r = 0.005

2. Find the number of payments: 30 × 12 = 360

3. Compute (1 + r)ⁿ: (1.005)³⁶⁰ ≈ 6.0226

4. Plug into the formula: M = 300,000 × [0.005 × 6.0226] ÷ [6.0226 − 1]

5. Numerator: 300,000 × 0.0301 ≈ 9,033.9; Denominator: 5.0226

6. Monthly payment: 9,033.9 ÷ 5.0226 ≈ $1,799 per month

Over 360 payments, that totals about $647,500 — meaning roughly $347,500 is pure interest on a $300,000 loan. You can generate the full month-by-month table instantly with the Mortgage Amortization Schedule calculator by entering your loan amount, rate, and term.

How the Schedule Splits Each Payment

Once you know the payment, building the schedule is repetitive arithmetic. For each month:

1. Interest for the month = current balance × monthly rate

2. Principal for the month = monthly payment − interest

3. New balance = current balance − principal

Take month one of our example. Interest is $300,000 × 0.005 = $1,500. Principal is $1,799 − $1,500 = $299. The new balance is $299,701. Of your very first payment, more than 83% went to interest and only $299 reduced your debt.

Now jump ahead. As the balance shrinks, the interest portion falls and the principal portion grows, because the payment is fixed. By the loan's final year, nearly all of each payment goes to principal. This crossover — the slow handoff from interest to principal — is the defining shape of every amortization schedule.

Using the Schedule to Make Better Decisions

Extra payments. Because early payments are so interest-heavy, adding even a small amount to principal early on saves a disproportionate amount of interest and shortens the term. The schedule lets you see exactly how much.

Comparing terms. A 15-year loan has a higher monthly payment than a 30-year loan but dramatically less total interest, because the principal is repaid far faster. Running both schedules side by side makes the trade-off concrete.

Evaluating refinancing. A lower rate reduces the interest portion of every payment, but refinancing resets the clock and adds closing costs. Comparing your current schedule against a new one shows the real break-even point. Tools like a monthly payment calculator and the full schedule work together when weighing these options.

Tracking equity. The remaining-balance column is your debt; the difference between your home's value and that balance is your equity. The schedule shows how equity builds over time.

Common Mistakes and How to Avoid Them

Confusing the rate. Use the monthly rate (annual ÷ 12) in the formula, not the annual rate. Plugging in the annual figure produces a wildly wrong payment.

Forgetting taxes and insurance. The amortization payment covers only principal and interest. Your actual monthly housing cost usually also includes property taxes, homeowners insurance, and sometimes mortgage insurance — often bundled into an escrow payment.

Assuming early payments build equity quickly. They do not. Expecting fast balance reduction in the first few years leads to disappointment; the math front-loads interest by design.

Ignoring total interest. Focusing only on the monthly payment hides the total cost. Always look at the lifetime interest figure when comparing loans.

Overlooking extra-payment rules. Some loans apply extra payments to future scheduled payments rather than to principal, or charge prepayment penalties. Confirm how your lender handles them.

Conclusion

A mortgage amortization schedule turns an intimidating, decades-long commitment into a transparent month-by-month plan. The monthly payment comes from a single formula, and the schedule then shows how each payment quietly shifts from mostly interest to mostly principal as your balance falls. Reading it reveals the true cost of borrowing, the power of early extra payments, and the real value of a lower rate or shorter term. Treat the schedule not as a fixed verdict but as a planning tool, and you will borrow — and repay — with far more clarity.

Key Takeaways

• One formula sets the payment: M = P × [r(1+r)ⁿ] ÷ [(1+r)ⁿ−1], using the monthly rate and total number of payments

• Early payments are mostly interest: Interest is charged on the remaining balance, so principal builds slowly at first and accelerates over time

• Extra principal pays off: Adding to principal early saves disproportionate interest — model it with the Mortgage Amortization Schedule calculator

• Look beyond the monthly figure: Compare total lifetime interest across terms and rates, and remember the payment excludes taxes and insurance