Loading crypto prices…
Tools

Free Amortization Schedule Calculator: Monthly Payment Table

Create a full monthly amortization schedule for a mortgage, car loan or personal loan, with every payment split into principal and interest, the balance after each month, and the effect of extra and one-time payments. Download it as a PDF or CSV.

Listen to this article5 min · AI voice

0:00 / 4:55

An amortization schedule shows every payment on a loan, how much of it pays interest and how much reduces the balance. This free amortization schedule calculator builds the full month-by-month table for a mortgage, car loan or personal loan, rounded to the cent the way lenders calculate it, and shows how extra monthly or one-time payments shorten the loan and cut the interest.

Amortization schedule calculator

The payment and each month's interest are rounded to the cent, the way lenders do it, and the last payment pays off the exact remaining balance. Interest is figured monthly at the rate ÷ 12. Property tax, insurance and PMI are not included; dates assume the first payment is due next month.

Key takeaways

  • A $250,000 loan at 6.5% for 30 years costs $1,580.17 a month and $318,861.58 of interest in total.
  • In the first payment, $1,354.17 is interest and only $226.00 reduces the balance. The split shifts toward principal every month.
  • Paying $200 extra each month pays the loan off 7 years and 11 months sooner and saves $97,618.44 of interest.
  • The same loan over 15 years costs $2,177.77 a month but only $141,998.15 of interest.

How amortization works

Each month, interest is charged on the remaining balance: balance × annual rate ÷ 12. Your fixed payment first covers that interest, and the rest pays down the principal. Because the balance shrinks, the interest part gets smaller and the principal part larger with every payment.

Monthly payment = loan × r ÷ (1 − (1 + r)−n), with r = annual rate ÷ 12 and n = number of payments

PaymentPaymentInterestPrincipalBalance
1$1,580.17$1,354.17$226.00$249,774.00
2$1,580.17$1,352.94$227.23$249,546.77
3$1,580.17$1,351.71$228.46$249,318.31
360$1,580.55$8.52$1,572.03$0.00

After the first year, you have paid $16,167.73 of interest and only $2,794.31 of principal. The last payment is 38 cents higher because the monthly payment is rounded to the cent.

Extra payments: how much they save

$250,000 at 6.5%, 30 yearsPaymentsTotal interestInterest saved
Regular payments360$318,861.58—
$200 extra every month265$221,243.14$97,618.44
One extra $10,000 with payment 12323$269,588.09$49,273.49

Extra money early in the loan saves the most, because it stops interest from building on that part of the balance for many years. Tell your lender that extra payments should go to principal, and check that your loan has no prepayment penalty. Before paying extra, it usually makes sense to have an emergency fund and to pay off debt with higher interest rates, such as credit cards.

15-year or 30-year loan?

A shorter term means higher payments but far less interest, and lenders usually offer a lower rate on 15-year mortgages, which increases the savings further. On $250,000 at the same 6.5% rate, the 15-year loan costs $597.60 more a month but saves $176,863.43 of interest. A 30-year loan with voluntary extra payments keeps the lower required payment as a safety net.

What an amortization schedule does not show

  • Escrow: mortgage payments often include property tax and homeowners insurance, which are not part of the loan. Our mortgage calculator adds them.
  • Mortgage insurance: PMI or FHA mortgage insurance comes on top of principal and interest.
  • Adjustable rates: the schedule assumes a fixed rate for the whole term.
  • Daily interest: some auto and personal loans charge interest daily, so paying early or late in the month changes the split slightly.

Frequently asked questions

What is an amortization schedule?

A table that lists every payment on a loan, with the interest, the principal and the remaining balance after each one, until the loan is paid off.

Why do I pay so much interest at the beginning?

Interest is charged on the balance, which is highest at the start. As the balance falls, each payment covers less interest and more principal.

Does an extra payment lower my monthly payment?

Usually not. On most fixed-rate loans, extra payments shorten the loan instead. Some lenders offer a recast that lowers the payment after a large lump sum; see mortgage recast vs. refinance.

Can I use this for a car loan or personal loan?

Yes. Enter the loan amount, rate and term. A $20,000 car loan at 8% for 5 years costs $405.53 a month and $4,331.62 of interest.

How do I download the schedule?

Use "Download PDF" or "Download CSV" under the results. Both contain the full monthly schedule; the CSV file opens in Excel, Numbers and Google Sheets.