Skip to content
Financial Figure

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.

Loan details
Extra payments

Applied once a year, in month 12, 24, 36…

Year-by-year summary

Amounts shown are the totals paid within each loan year.
YearPrincipalInterestExtraBalance
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.