A little help goes a long way. Find a tool/

Finance FIELD NOTES · 3 MIN READ

How to Read an Amortization Schedule, Month by Month

The level-payment formula, how each payment splits into interest and principal, and what the full month-by-month table reveals about a loan.

An amortization schedule is your loan's complete ledger: every payment from the first to the last, each split into the part that pays interest and the part that actually retires debt. Reading it explains why early extra payments feel so powerful — and why the lender's share of your check starts so high.

The level payment

A fixed-rate loan is engineered so the payment never changes: it is set so that payment minus each month's interest exactly eats the principal down to zero on schedule. The standard formula (the full derivation lives in how loan interest works) is:

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

with P the principal, r the monthly rate (annual ÷ 12) and n the number of payments. On a $300,000 loan at 6% for 30 years — r = 0.005, n = 360 — that gives $1,798.65 per month. Over the term the schedule totals $647,514 of payments, of which $347,514.57 is interest.

One month's mechanics

Each month the lender charges interest on the current balance at the monthly rate, then applies the payment: interest first, the remainder to principal.

month 1:  interest  = 300,000 × 0.005 = $1,500.00
          principal = 1,798.65 − 1,500.00 = $298.65
          balance   = 299,701.35
month 2:  interest  = 299,701.35 × 0.005 = $1,498.51
          principal = $300.14,  balance = 299,401.20

The principal portion grows by a factor of (1 + r) every month — 0.5% here — because the interest it displaces keeps shrinking. By the final row the split has fully inverted: month 360 is $8.95 of interest and $1,789.70 of principal, closing the balance to zero.

Reading the crossover

Because the split shifts one row at a time, there is a definite month where principal finally overtakes interest. On this loan it is month 223 of 360 — about 62% of the way through the term — where the payment divides into $903.71 of principal and $894.94 of interest. On a 15-year loan the crossover arrives far sooner, which is the same arithmetic that makes short terms cheaper: you never spend decades paying mostly interest.

What an extra payment changes

An extra amount applied monthly goes entirely to principal, and every dollar removed stops accruing interest for the rest of the term. Add $100 a month to this loan and the schedule ends at month 313 instead of 360 — 47 payments early — with total interest of $294,168.16 instead of $347,514.57: a saving of $53,346.41. From a January 2026 start the payoff date moves from January 2056 to February 2052. The same acceleration logic across many debts is the territory of mortgage payoff strategies and snowball versus avalanche; the schedule's job is to show it row by row on one loan.

Reading the whole table at a glance

Three columns repay attention. Balance shows how slowly the principal moves at first — five years in, more than half your payments have gone to interest, yet the balance has barely begun its slide. Interest is the running cost of the loan, and its early steepness is why prepayment math favors the first years. Principal is the equity-building column on a mortgage, the one that tells you how much of the house you actually own as the months pass. Escrowed taxes and insurance never appear here; they live outside the amortization math entirely — see mortgage math explained for how PITI sits on top of this table.

Try it yourself

Generate your own table with the Amortization Schedule Generator — enter principal, rate and term, or your exact monthly payment, with an optional extra amount and start date. For totals-only math the Loan Calculator is faster; to compare payoff strategies side by side, use the Loan Payoff Calculator.

Frequently asked questions

Is an amortization schedule the same thing as a loan payoff calculator?
No. The schedule is descriptive: one loan, every month, with payment, principal, interest and balance. A payoff calculator is prescriptive: it compares acceleration scenarios to answer how to finish sooner. The generator can model one extra amount inside its table; the payoff tool compares many scenarios at once.
Can I enter my exact monthly payment instead of a term?
Yes. Supplying the payment overrides the term-derived figure, which suits real loans whose payment includes rounding or lender adjustments. The schedule then reports the true number of months to payoff rather than the contractual term.
Why is month one's interest exactly rate ÷ 12 times the balance?
Because the schedule uses simple monthly accrual, the standard convention for this kind of table. Some servicers accrue daily on an actual/365 basis, so a real statement can differ by a dollar or two in a month. The structure — front-loaded interest, shrinking balance — is identical either way.
Does the schedule include taxes, insurance, or escrow?
No. It models the loan itself: principal and interest only. Escrowed property taxes and insurance sit outside the amortization math entirely — see mortgage math explained for how the PITI payment sits on top of this table.
What happens if a payment cannot cover the interest?
The balance would grow instead of shrink (negative amortization), so payoff is impossible at that payment and the generator reports it rather than looping. It also caps the table at 1,200 months for loans that only barely amortize.