What is an amortization schedule?
It’s a table of every payment on a loan. Each payment covers that month’s interest first, and the rest lowers your balance. So early payments are mostly interest, and later ones are mostly principal.
Amortization formula
Payment = P × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1)
Interest this month = balance × r
Principal this month = payment − interest
P is the loan amount, r is the yearly rate ÷ 12, and n is the number of payments.
Worked example
A $300,000 loan at 6.5% for 30 years has a payment of $1,896.20. Over the life of the loan, you’d pay $382,633.47 in interest.
| In year 1 | Amount |
|---|---|
| Paid toward principal | $3,353.18 |
| Paid in interest | $19,401.27 |
| Balance at the end of the year | $296,646.82 |
In that first year, most of what you pay goes to interest.
How to use the schedule
- Switch views. See totals for each year, or every single month.
- Add an extra payment. See how much sooner the loan ends. Check first that your lender applies extra payments to principal.
- Download it. Get every payment as a CSV to open in Excel or Google Sheets.
What this leaves out
It assumes a fixed rate. Your actual payment may also include taxes, insurance and fees, so use our mortgage calculator for a full house payment. To compare prepayment options, use our prepayment calculator. This isn’t financial advice.
Worked example: a $20,000 car loan
Enter a loan amount of 20,000, an interest rate of 7 and a loan term of 5 years. The regular payment is $396.02 a month for 60 payments, and the total interest is $3,761.44, so you pay $23,761.44 in all. Shown by year, the schedule looks like this:
| Period | Principal | Interest | Balance |
|---|---|---|---|
| Year 1 | $3,461.96 | $1,290.33 | $16,538.04 |
| Year 2 | $3,712.22 | $1,040.06 | $12,825.82 |
| Year 3 | $3,980.58 | $771.71 | $8,845.23 |
| Year 4 | $4,268.34 | $483.95 | $4,576.90 |
| Year 5 | $4,576.90 | $175.39 | $0.00 |
The payment never changes, but its make-up does. In the first month, $116.67 goes to interest and $279.36 to principal. By the last month, only $2.30 is interest and $393.73 pays off the rest of the balance.
Why the split changes over time
The CFPB explains that with a typical fixed-rate loan, the combined principal and interest payment stays the same, but the amounts going to principal and to interest change.[1] At the start you owe more interest because the balance is still high, and as you pay the balance down you owe less interest each month.[1] The part of a payment that goes to interest doesn’t reduce your balance or build equity.[1] Lenders use a standard formula to set a payment that pays the loan off exactly at the end of the term.[1] This calculator uses that same formula.
Car loans work the same way. The CFPB calls the chart of how each payment splits between principal and interest an amortization schedule, and notes that the principal balance falls slowly at first, then more quickly near the end.[2] It also says a longer term lowers your monthly payments but raises the interest you pay over the life of the loan.[2]
How an extra payment changes the schedule
Type an amount in Extra each month to see what paying a little more does. On the $300,000 loan at 6.5% for 30 years, an extra $200 makes the monthly payment $2,096.20. The loan is paid off in 277 payments instead of 360, and total interest drops from $382,633.47 to $279,184.67, a saving of $103,448.80. With a first payment in January 2027, the last payment moves from December 2056 to January 2050.
Smaller loans benefit too. Adding $100 a month to the $20,000 car loan above pays it off in 47 payments, with $2,867.72 of interest instead of $3,761.44. The extra amount goes entirely to principal in this tool, so ask your lender how it applies extra payments before you rely on the result.
Reading the amortization schedule calculator results
- Monthly payment. The regular payment plus any extra amount you entered.
- Regular payment and number of payments. The payment from the loan formula, and how many payments it takes to clear the loan.
- Total interest and total paid. Every interest charge added up, and the loan amount plus that interest.
- The table. Use Show schedule by to switch between Year and Month. Each row lists the principal and interest paid in that period and the balance left at the end.
- The CSV file. It holds every payment with its number, date, amount, principal, interest and balance.
The loan term box takes decimals, so 2.5 years gives a schedule of 30 payments. The First payment box only sets the dates in the table; it doesn’t change any amounts.
Common amortization schedule mistakes
- Adding taxes and insurance to the loan amount. Enter only what you borrow. Escrow amounts are separate from principal and interest.
- Using the APR as the rate. Enter the note rate from your loan papers, because the payment is worked out from it.
- Expecting the last payment to match the others. The final payment clears whatever balance is left. With an extra $200 on the $300,000 loan, payment 277 is only $632.35. Download the CSV to see it.
How we calculate this
The monthly payment comes from the standard loan formula. With monthly rate r = yearly rate ÷ 1,200 and n payments, payment = amount × r × (1 + r)^n ÷ ((1 + r)^n − 1). At a 0 percent rate, payment = amount ÷ n.
Each month, interest = balance × r. Principal = payment − interest. The new balance = balance − principal. An extra payment, if you enter one, is added to the regular payment and goes entirely to principal, so the loan ends sooner. The last payment clears whatever balance remains.
The schedule can be shown by year or by month. Yearly rows add up that year's principal and interest and show the ending balance. The start month sets the dates. Limits are a loan up to 10 billion, a rate up to 50 percent, and a term up to 50 years. You can download the full schedule as a CSV file.
What next
Use this often? Add Amortization to your Home screen.
Frequently asked questions
How do I read an amortization schedule?
Each row shows how much of a payment goes to principal and to interest, and the balance left afterward.
Why is so much of my early payment interest?
Interest is charged on your balance, which is highest at the start. As the balance falls, more of each payment goes to principal.
Can I use this as an EMI amortization schedule?
Yes. An EMI is a fixed monthly loan payment, so this schedule shows how each EMI splits between principal and interest.
Can I download the schedule?
Yes. Press Download CSV, then open it in Excel or Google Sheets.
How much interest does an extra $200 a month save on a $300,000 mortgage?
At 6.5% for 30 years, an extra $200 a month cuts total interest from $382,633.47 to $279,184.67, a saving of $103,448.80, and pays the loan off in 277 payments instead of 360.
Why is my last payment smaller than the others?
The last payment only clears the balance that is left. When you add an extra amount each month, the loan ends early and the final payment is usually smaller, such as $632.35 instead of $2,096.20 on a $300,000 loan with an extra $200.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.