Amortization Schedule

Full loan amortization table with principal, interest, and payoff date, plus CSV export.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

Educational estimate only — not investment, lending, or financial advice. Confirm figures with statements or a qualified professional before you act.

About this tool

Enter a loan amount, rate and number of payments to see the level payment and a full payment-by-payment schedule. Add an extra payment each period to see how much sooner you finish and how much interest you save. Download the schedule as CSV.

How to use

1
Step 1
Enter the loan amount, annual rate and payments per year.
2
Step 2
Enter the total number of payments (360 for a 30-year monthly loan).
3
Step 3
Add an extra payment per period if you want to test paying down faster.
4
Step 4
Optionally set a start date, then calculate and download the CSV.

How it works

The level payment is fixed by the loan amount, rate and term, with interest compounding at the payment frequency. Each month interest is charged on the remaining balance; the rest of the payment reduces principal, so early payments are mostly interest. Any extra payment goes entirely to principal and the schedule stops the period the balance reaches zero.

payment = P × i ÷ (1 − (1 + i)^−n)      interest = balance × i      principal = payment − interest      i = annual rate ÷ payments per year

Worked example

A 300,000 loan at 6.5% over 30 years

Input
Loan 300,000; 6.5%; 12 a year; 360 payments; extra 0, then 200
Output
Payment 1,896.20; total interest 382,636.71. With 200 extra: paid off in 277 payments; interest 279,186.52
Walkthrough
In month one, interest is 300,000 × 0.065 ÷ 12 = 1,625.00 and principal is 271.20. With 200 extra each month the loan clears in 277 payments instead of 360, 83 payments sooner, and interest drops by 382,636.71 − 279,186.52 = 103,450.19.

Limitations

  • Fixed rate, level payments. Variable rates, fees and escrow are not modelled.
  • Extra payment is the same every period.
  • Estimate only; your lender's schedule governs.

Questions

What is the monthly payment on 300,000 at 6.5% for 30 years?
1,896.20, with total interest of 382,636.71 over 360 payments.
How much does an extra 200 a month save?
The loan is paid off in 277 payments instead of 360 and about 103,450.19 of interest is saved.
Why is so much of the early payment interest?
Interest is charged on the full balance, which is largest at the start. In month one, 1,625.00 of the 1,896.20 is interest.
Can I download the schedule?
Yes, as a CSV with payment, principal, interest, extra payment and balance for each period.

Features

  • Full payment schedule
  • Extra payment simulation
  • CSV download
  • Optional start date
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • Amortization

    Khan Academy

    Principal vs interest breakdown for schedules.

    Watch on YouTube

  • Present value and future value

    Khan Academy

    TVM vocabulary for N/I/Y/PV/PMT/FV solves.

    Watch on YouTube

More Finance tools

See all ›
Bond Calculator
Bond price from yield (or yield from price), current yield, and duration.
Loan Calculator
Estimate loan payment, interest, and payoff total.
Mortgage Calculator
Estimate monthly mortgage payment, interest, and total cost.
EMI Calculator
Calculate EMI for a loan from principal, rate, and tenure.
Depreciation Calculator
Straight-line, sum-of-years-digits, and declining-balance depreciation schedules with CSV export.