PayoffTable

Amortization Schedule Calculator

Some people want the headline numbers. You want the table — every row, every month, principal and interest to the cent. This calculator is built for the schedule itself, with print and CSV built in.

Reviewed by the PayoffTable editorial team · Updated 2026-10-24

Your numbers

Enter the amount borrowed here
Usually 0 — or credits applied at closing
Annual rate on the loan
In years

Runs entirely in your browser. Nothing is uploaded.

The amortization schedule is a document, not just a calculation. People print it to compare against servicer statements, tape it inside a budget binder, or bring it to a refinance consultation. That is the use case this page is optimized for: the table is the product.

Enter the amount borrowed (use the loan amount field — if you are starting from a home price, put the price in the first field and your down payment or credits in the second), the rate, the term, and your first payment month. The schedule fills in instantly, with a running balance column that reconciles against real statements.

The print view strips everything except the inputs you used and the full table — no navigation, no buttons — so a printed schedule is one page of numbers you can audit. The CSV export opens directly in Excel, Numbers, or Google Sheets if you want to run your own scenarios on top.

How to read the amortization schedule table

Each row is one month. The payment column is constant (except the last, which is adjusted to the remaining balance). The interest column is balance × monthly rate. The principal column is payment minus interest. The balance column carries forward.

Two numbers worth finding in every schedule: the crossover month — where the principal column first exceeds the interest column — and the cumulative interest paid by any given date. On a $250,000 loan at 6.5% for 30 years, the crossover does not happen until month 233. More than nineteen years of payments where the interest share is bigger than the principal share.

interest_m = balance_m × (APR ÷ 12) principal_m = payment − interest_m balance_m+1 = balance_m − principal_m

The balance-over-time chart above the table shows the same data geometrically: a slow, convex decline for most of the term, then a steep drop in the final years as principal finally dominates.

Worked example. $250,000 at 6.5% for 30 years, first payment Jan 2027: payment $1,580.17. Row 1: Jan 2027 — interest $1,354.17, principal $226.00, balance $249,774.00. Row 233 (May 2046) — principal first exceeds interest, at $791.42 vs $788.75. Row 360 (Dec 2056) — balance $0.00. Total interest $318,861.22. After 5 years (row 60, balance $234,027.44) you have paid $94,810.20 but retired less than a seventh of the principal.

Terms & definitions

Amortization
The process of paying off a loan with scheduled payments that cover both interest and principal. Early payments are mostly interest; later payments are mostly principal.
Principal
The amount you borrowed and still owe. Extra payments reduce principal directly, which shrinks every future interest charge.
APR
Annual Percentage Rate — the yearly cost of the loan including fees. Your monthly interest charge uses the note rate, which is usually a touch lower.
Term
The number of years the loan is scheduled to last. A 30-year term has lower payments but roughly double the total interest of a 15-year term at the same rate.

Frequently asked questions

How do I print the full schedule?
Use the Print button above the table. The print stylesheet removes navigation and buttons and expands the table, so the schedule prints cleanly. For very long schedules your browser will paginate — each page repeats the header row.
Can I open the schedule in Excel?
Yes — Download CSV produces a plain-text file with columns for payment number, date, payment, principal, interest, and balance. It opens directly in Excel, Numbers, and Google Sheets, and imports cleanly into budgeting tools.
What is the "crossover month"?
The first month where more of your payment goes to principal than to interest. Before it, you are paying more interest than principal every month. On a $250,000 loan at 6.5% for 30 years it lands in month 233. Finding yours in the table is one of the most persuasive arguments for even small extra payments, because every extra dollar moves the crossover earlier.
Does the schedule match my servicer's statement?
It should match to within a few cents per row if your rate and first payment month are right. Differences come from daily interest accrual around closing, payment posting dates, and any fees. A persistent gap larger than a dollar usually means the rate or start month is off.

References

  1. Consumer Financial Protection Bureau — Loan Estimate explainer (how principal, interest, and amortization appear on your closing documents)
  2. CFPB — What is an amortization schedule?
  3. Federal Reserve — Mortgage origination resources (APR vs note rate)
Educational content only — not financial, tax, or legal advice. Your loan terms govern; confirm details with your servicer.

Related calculators

Mortgage Amortization

Full mortgage schedule from the loan amount — principal, interest, and balance every month.

Mortgage Payoff

The flagship: extra monthly payments plus yearly lump sums, with your new payoff date and interest saved.

Amortization Calculator

See every payment, split into principal and interest, from first payment to payoff.