Amortization Schedule Calculator
Generate a full month-by-month amortization schedule for any fixed-rate loan. See how each payment splits between principal and interest, add extra payments, review a year-by-year summary and download the whole table as a CSV file.
Year-by-year summary
| Year | Principal | Interest | Extra | Balance |
|---|---|---|---|---|
| 1 | $3,577 | $20,695 | $0 | $316,423 |
| 2 | $3,816 | $20,455 | $0 | $312,607 |
| 3 | $4,072 | $20,200 | $0 | $308,535 |
| 4 | $4,345 | $19,927 | $0 | $304,191 |
| 5 | $4,636 | $19,636 | $0 | $299,555 |
| 6 | $4,946 | $19,325 | $0 | $294,609 |
| 7 | $5,277 | $18,994 | $0 | $289,332 |
| 8 | $5,631 | $18,641 | $0 | $283,701 |
| 9 | $6,008 | $18,264 | $0 | $277,694 |
| 10 | $6,410 | $17,861 | $0 | $271,284 |
| 11 | $6,839 | $17,432 | $0 | $264,444 |
| 12 | $7,297 | $16,974 | $0 | $257,147 |
| 13 | $7,786 | $16,485 | $0 | $249,361 |
| 14 | $8,308 | $15,964 | $0 | $241,053 |
| 15 | $8,864 | $15,407 | $0 | $232,189 |
| 16 | $9,458 | $14,814 | $0 | $222,732 |
| 17 | $10,091 | $14,180 | $0 | $212,641 |
| 18 | $10,767 | $13,505 | $0 | $201,874 |
| 19 | $11,488 | $12,784 | $0 | $190,386 |
| 20 | $12,257 | $12,014 | $0 | $178,129 |
| 21 | $13,078 | $11,193 | $0 | $165,051 |
| 22 | $13,954 | $10,317 | $0 | $151,097 |
| 23 | $14,888 | $9,383 | $0 | $136,208 |
| 24 | $15,886 | $8,386 | $0 | $120,323 |
| 25 | $16,949 | $7,322 | $0 | $103,373 |
| 26 | $18,085 | $6,187 | $0 | $85,289 |
| 27 | $19,296 | $4,976 | $0 | $65,993 |
| 28 | $20,588 | $3,683 | $0 | $45,405 |
| 29 | $21,967 | $2,305 | $0 | $23,438 |
| 30 | $23,438 | $833 | $0 | $0 |
Disclaimer: Estimates only — not financial, tax or legal advice. Results depend on assumptions you should confirm with a qualified professional.
How the amortization schedule works
A fully amortising loan spreads the repayment of principal evenly across the term while charging interest on whatever balance is still outstanding. The result is a payment of constant size that changes in composition every month. This page builds that table for your loan and lets you add extra principal to see the effect on the payoff date.
The payment formula
The fixed monthly payment comes from the standard amortisation formula:
M = P × r ÷ (1 − (1 + r)−n)
P is the loan amount, r is the monthly interest rate (the annual rate divided by twelve) and n is the number of monthly payments. Each month the schedule charges interest equal to the balance times r, applies the rest of the payment to principal, and records the new balance until the loan reaches zero.
Worked example
Borrow $320,000 at 6.5% for 30 years. The formula gives a monthly principal-and-interest payment of about $2,022.62. In the first month the interest charge is roughly $1,733, so only about $290 goes to principal. By the final year the split has reversed: almost all of each payment reduces the balance. Over the full 360 payments you would repay about $728,000 — some $408,000 of which is interest. Add $200 a month of extra principal and the loan is retired years earlier with far less interest, all of which the schedule spells out month by month.
Reading the year-by-year summary
The monthly table is precise but long, so the summary groups twelve payments at a time. It shows how much principal and interest you pay in each loan year and the balance left at the end of it — the fastest way to see the crossover where principal payments overtake interest. The CSV download contains every individual month if you need the detail.
Limitations
The schedule assumes a fixed interest rate and on-time payments, and it ignores escrow, taxes and insurance. Real loans can also charge late fees or allow adjustable rates, which this table does not model. Use it to understand the shape of the loan, then confirm the precise figures with your lender's own statement.
Frequently asked questions
- What is an amortization schedule?
- An amortization schedule is a table showing every payment on a loan. Each row lists the payment number, the amount paid, how much went to principal, how much went to interest and the balance left afterwards. It reveals how the mix shifts over time: early payments are mostly interest, later payments are mostly principal.
- Why is most of my early payment interest?
- Interest is charged on the outstanding balance, which is highest at the start. With a $320,000 loan at 6.5% the first month's interest is about $1,733; only the remainder of the payment touches the balance. As the balance falls, the interest portion shrinks and more of each payment goes to principal.
- How do extra payments change the schedule?
- This calculator applies extra payments straight to principal, which shortens the loan rather than lowering the monthly payment. Because the balance falls faster, less interest accrues, the payoff date moves earlier and the total interest drops. The summary shows exactly how many months and dollars the extras save.
- Can I download the schedule?
- Yes. The Download CSV button builds the full month-by-month table in your browser and saves it as a CSV file that opens in any spreadsheet. Nothing is uploaded — the file is generated entirely on your device.
- Does the schedule account for taxes and insurance?
- No. Amortization describes only the loan itself: principal and interest. Property tax, homeowners insurance and HOA dues are separate recurring costs, so add them on top of the payment shown here when you build a full housing budget.
