Amortization Schedule Calculator

Enter your loan amount, interest rate and term to get the fixed monthly payment and a complete amortization table — how much of each payment goes to principal versus interest, and the balance after each one.

Enter the loan details, then press Build schedule.

How amortization works

An amortizing loan is repaid with equal periodic payments that cover both interest and principal. Early on, most of each payment is interest; over time the balance shrinks, so less interest accrues and more of each payment chips away at principal. The fixed monthly payment comes from the standard formula:

M = P × i × (1 + i)ⁿ ÷ ((1 + i)ⁿ − 1)

where P is the principal, i is the monthly rate (annual ÷ 12) and n is the number of payments. Each month, interest is i × balance, the rest of the payment reduces the balance, and the cycle repeats until the balance reaches zero.

Worked example

$250,000 at 6.5% over 30 years (360 payments):

Monthly rate: 6.5% ÷ 12 = 0.5417%.
Payment: ≈ $1,580.17 per month.
Payment 1: interest = 0.005417 × 250,000 ≈ $1,354; principal ≈ $226 — almost all interest at the start.

Reading the schedule

The table lists every payment with its interest, principal and remaining balance. Watch the crossover point where principal first exceeds interest — it's surprisingly far in on long loans. Adding an extra monthly payment goes entirely to principal, which shortens the term and can save large amounts of total interest; the calculator recomputes the payoff and shows the savings. You can download the full schedule as a CSV to open in any spreadsheet.

Tip: comparing the true cost of offers with fees? Use the APR calculator; for a quick payment only, the loan calculator or mortgage calculator.

Frequently asked questions

Why is most of my early payment interest?

Interest each month is the rate times the current balance, and the balance is largest at the start. So early payments are mostly interest with little principal; as the balance falls, the interest portion shrinks and principal grows.

How does an extra payment help?

Every extra dollar goes straight to principal, so it skips all the future interest that dollar would have accrued. Even a small consistent extra payment can cut years off a long loan and save thousands in interest.

What is the amortization crossover point?

It's the payment at which principal first exceeds interest. On a 30-year loan it can fall well past the halfway mark in time, which is why early extra payments are so powerful.

Can I export the schedule?

Yes. The Download CSV button saves the full table — payment number, interest, principal and balance — so you can open it in Excel, Google Sheets or Numbers and analyze it further.

MB
Mustafa Bilgic · Editor, Calcool
Uses the standard amortization formula; each row applies interest = rate × balance, then reduces the balance by the principal portion. Everything runs in your browser — nothing you enter is uploaded, logged or stored.

Related calculators