My Tools Garage

Mortgage Amortization Schedule

Full payment-by-payment loan amortization table.

in-browser

How to use

  1. 1 Enter the loan amount, annual interest rate and term in years.
  2. 2 Choose how many payments you make per year.
  3. 3 Read the summary: payment, totals and total interest.
  4. 4 Scroll the table to see each payment split into interest and principal.
  5. 5 Copy the schedule as CSV for your spreadsheet.

About Mortgage Amortization Schedule

The Mortgage Amortization Schedule turns a loan into a complete, payment-by-payment table so you can see exactly where your money goes.

Enter the loan amount, the annual interest rate, the term in years and how many payments you make each year, and the tool computes the level payment and every row of the schedule.

Each row shows the payment number, the fixed payment, how much of it covers interest, how much pays down the principal, and the remaining balance afterwards.

Early on, most of each payment is interest; as the balance falls, more of every payment chips away at the principal.

Watching that crossover is the clearest way to understand why paying a little extra early saves so much over the life of a loan.

You are not limited to monthly loans: choose monthly, bi-weekly, quarterly or annual payment frequencies to match your real schedule.

The summary reports the per-payment amount, the total number of payments, the total amount paid and the total interest.

The final payment is adjusted so the balance lands at exactly zero, absorbing any rounding.

You can copy the whole schedule as CSV to drop into a spreadsheet.

All of it runs locally in your browser with no uploads, so your figures stay private and it works offline.

FAQ

What does each row of the schedule show?

The payment number, the fixed payment, the interest and principal portions of that payment, and the remaining balance afterwards.

Can I model bi-weekly or quarterly payments?

Yes. Pick monthly, bi-weekly, quarterly or annual frequency and the payment and schedule recompute accordingly.

Why does the last payment differ slightly?

The final payment is adjusted so the balance reaches exactly zero, soaking up the rounding that builds up over many payments.