Amortization Calculator
Build the full amortization schedule for any fixed-rate loan. See how each payment splits between principal and interest, when principal overtakes interest, what extra payments save, and download the schedule as a CSV file.
How to Use
- Enter the amount borrowed, the yearly interest rate and the term, in years or months.
- Choose how often you pay — monthly for most mortgages and car loans — and the month of the first payment.
- Optionally add an extra amount on every payment, or one-off payments such as “#24 2000” (payment 24) or “2028-06 5000”.
- Read the payment, total interest, the crossover payment where principal overtakes interest, and the payoff date.
- Switch the schedule between yearly and per-payment rows, or press Download CSV to open it in a spreadsheet.
Worked Example
A $250,000 mortgage at 6.5% for 30 years. The monthly rate is 0.065 ÷ 12 = 0.00541667 and there are 360 payments, so the payment is 250,000 × 0.00541667 × 1.00541667³⁶⁰ ÷ (1.00541667³⁶⁰ − 1) = $1,580.17.
The first payment. Interest is 250,000 × 0.00541667 = $1,354.17, so only $1,580.17 − $1,354.17 = $226.00 reduces the balance, leaving $249,774.00. Each month the interest shrinks a little and the principal grows by the same amount. Payment 233 is the first with more principal than interest, and over the whole loan the interest adds up to $318,861.22 — more than the amount borrowed.
The common mistake: halving the term halves the interest. It does far more than that. The same $250,000 at 6.5% over 15 years costs $2,177.77 a month and $141,998.31 of interest, less than half of the 30-year total, because the balance falls fast before interest can build up.
Show Work
Formulas
Where Amortization Comes From
The word comes from the Old French amortir, “to kill off” — a debt is put to death a little at a time. The arithmetic of a level payment is the arithmetic of an annuity, worked on by Edmond Halley and Abraham de Moivre in the late 1600s and 1700s for life annuities, and used in printed interest tables long before calculators.
For ordinary borrowers, fully amortizing loans spread in the 1930s, when American lenders moved away from short interest-only loans that ended in a balloon payment. Today the schedule is what your lender’s system produces for every fixed-rate loan, and the yearly totals are what end up on an interest statement. The loan amortization guide walks through it in more depth.
About This Tool
This calculator produces the payment-by-payment schedule for any fixed-rate, fully amortizing loan — mortgage, car, student, personal or business — paid monthly, semi-monthly, bi-weekly, weekly, quarterly or yearly. It finds the crossover payment, shows interest and principal in each payment on a chart, and compares the balance with and without extra payments. The schedule can be viewed by year or by payment and downloaded as a CSV file built in your browser.
Interest is taken to compound once per payment period, which is how most US loans work. Everything runs in your browser; nothing you enter is sent anywhere.
Estimates for planning and education — not financial, tax or legal advice.
Related tools: Mortgage Calculator, Mortgage Payoff Calculator, and Refinance Calculator.
Frequently Asked Questions
Why are early payments mostly interest?
Interest is charged on the balance still owed, which is largest at the start. On a $250,000 loan at 6.5% the first monthly payment of $1,580.17 is $1,354.17 interest and only $226.00 principal. In the first year you pay $16,167.73 of interest; in the last year, $651.08.
What is the crossover point?
It is the first payment in which more goes to principal than to interest. For $250,000 at 6.5% over 30 years it is payment 233, more than 19 years in. Shorter loans cross much sooner: a $30,000 car loan at 7.5% over 60 months is already mostly principal from the first payment ($413.64 principal, $187.50 interest).
How are extra payments applied?
An extra payment lowers the balance straight away, so every later payment carries less interest and more principal while the scheduled payment stays the same. Adding $150 a month to the $250,000, 6.5% loan finishes it 77 payments early and saves $79,991.62. Ask your lender to apply extras to principal, not to the next payment.
Does this work for car, student and personal loans?
Yes — any fixed-rate loan with level payments uses the same maths. A $50,000 student loan at 6.5% over 10 years is $567.74 a month with $18,128.79 of interest, and a $15,000 personal loan at 12% over 36 months is $498.21 a month with $2,935.73 of interest.
What does the CSV file contain?
One row per payment: the payment number, its date, the payment, the principal and interest in it, any extra principal, and the balance left — every payment, even when the page shows only the first 600. A 30-year monthly loan gives 360 rows; open the file in Excel, Numbers or Google Sheets.
How do I use the Amortization Calculator?
Simply type your numbers and read the result, which refreshes the instant you change something. There is nothing to submit and nothing to wait for.
Do I need to install or sign up for anything?
Not at all — it runs in the browser with nothing to install and no account. After it loads once, it even works without an internet connection.
Is my information private?
Yes. Everything happens in your browser. Nothing you type is sent to a server or saved anywhere.
Common Use Cases
Mortgage interest for taxes
The yearly view of a $250,000, 6.5% mortgage shows $16,167.73 of interest in year 1 — the figure a lender reports on Form 1098 for a loan that started in January.
Car loan check
A $30,000 car loan at 7.5% over 60 months is $601.14 a month and $6,068.31 of interest in total.
Equity after five years
After 60 payments on a $250,000, 6.5% mortgage the balance is still $234,027.44 — only $15,972.56 of principal repaid.
Testing an extra payment
An extra $150 a month on the same mortgage moves the crossover from payment 233 to payment 171 and saves $79,991.62.
Spreadsheet work
Download the CSV of a 36-payment personal loan ($15,000 at 12%, $498.21 a month) to track actual payments against the plan.
Last updated: