calculate-loan

01 Loan payments

Amortization Schedule: Full Table & How to Read It

Calculator No. 01-20919 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An amortization schedule is a table that shows each monthly loan payment, split into the interest portion and the principal portion, along with the remaining balance after every payment. You enter your loan amount, interest rate, and loan term, and the schedule shows you exactly how your debt decreases month by month until it reaches zero.

Formula

The amortization schedule is built from the standard fixed-rate loan payment formula:

Monthly payment (M) = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = loan principal (the amount you borrowed, in dollars)
  • r = monthly interest rate = annual percentage rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08 / 12 = 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

For each payment number k (from 1 to n), the schedule uses two more calculations:

  • Interest for month k = previous balance × r
  • Principal for month k = monthly payment − interest for month k
  • New balance = previous balance − principal for month k

This is a standard amortization formula that assumes a fixed interest rate and equal monthly payments for the entire term. The formula is sometimes written as M = P × r / (1 − (1 + r)^−n), which is mathematically identical.

Worked Example

Let’s use the default values from the calculator: a $20,000 loan at 8% APR for 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667 (as a decimal)
  2. Total number of payments: n = 5 × 12 = 60
  3. Plug into the formula:
    M = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. Calculate (1.0066667)^60: ≈ 1.489846
  5. Numerator: 20000 × (0.0066667 × 1.489846) = 20000 × 0.0099323 = 198.646
  6. Denominator: 1.489846 − 1 = 0.489846
  7. Monthly payment: 198.646 / 0.489846 ≈ 405.53 (rounded to the cent)

So the monthly payment is $405.53. Over 60 payments, you pay 60 × 405.53 = $24,331.80 total. The total interest is $24,331.80 − $20,000 = $4,331.80.

To see the schedule, start with a balance of $20,000. For month 1, interest = 20000 × 0.0066667 = $133.33. Principal = 405.53 − 133.33 = $272.20. New balance = 20000 − 272.20 = $19,727.80. Repeat this for each month, always using the current balance. By month 60, the balance reaches $0.00.

Assumptions

  • The interest rate is fixed for the entire loan term.
  • Payments are made at the end of each month (not at the beginning).
  • Interest compounds monthly at APR / 12.
  • The payment amount is rounded to the cent, and the final payment may differ slightly to clear the balance.
  • This schedule does not include fees, taxes, insurance, PMI, or escrow amounts unless you add them separately.

How to Read an Amortization Schedule

Each row in the schedule shows the payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. In the early months, most of your payment goes toward interest. As the balance decreases, the interest portion shrinks and the principal portion grows. By the final payment, nearly all of it goes to principal.

For example, in the $20,000 loan above, month 1 has $133.33 interest and $272.20 principal. By month 30, the balance is about $11,000, so interest is around $73, and principal is about $332. By month 60, the interest is only a few dollars.

You can also see the total interest paid over the life of the loan, which is the sum of all interest portions. This total is often higher than people expect—for a 30-year mortgage, total interest can exceed the original loan amount.

Common Mistakes and Misconceptions

  • Using the APR directly as the monthly rate. Always divide by 12. An 8% APR is 0.6667% per month, not 8% per month.
  • Rounding too early. If you round the monthly rate to 0.007 instead of 0.0066667, your payment will be off by several dollars. Keep full precision until the final step.
  • Ignoring the final payment adjustment. Because the payment is rounded to the cent, the last payment often differs by a few cents to bring the balance to exactly zero.
  • Thinking the payment is half interest, half principal. That only happens near the middle of the loan, not at the start.
  • Assuming extra payments reduce your monthly payment. Unless you recast the loan, extra payments shorten the term, not the payment amount.

How to Use the Schedule for Extra Payments

If you make an extra payment toward principal, the schedule changes. The extra amount reduces the balance immediately, which means less interest accrues in future months. You have two options:

  • Keep the same monthly payment: The loan will be paid off early, and total interest will be lower.
  • Recast the loan: The lender recalculates the payment based on the new balance and the remaining term, so your monthly payment drops but the term stays the same.

To see the effect, you can adjust the loan amount or term in the calculator. For example, if you pay an extra $1,000 at the start of the $20,000 loan, the effective principal becomes $19,000. The new payment would be about $385.25, and total interest drops to about $4,115—saving roughly $216.

Alternatives to a Fixed-Rate Amortization Schedule

Not all loans amortize the same way. Here are common alternatives:

  • Interest-only loans: You pay only interest for a set period (e.g., 5 years), then the payment jumps to include principal. The schedule shows zero principal reduction during the interest-only phase.
  • Balloon loans: You make small payments for a few years, then a large lump sum at the end. The schedule shows a large final balance.
  • Adjustable-rate mortgages (ARMs): The interest rate changes periodically, so the schedule is only accurate until the first rate adjustment.
  • Biweekly payments: You pay half the monthly amount every two weeks, which results in 26 half-payments per year (equivalent to 13 full payments). This shortens the term and reduces total interest.

For most standard loans—auto loans, personal loans, student loans, and fixed-rate mortgages—the amortization schedule described here applies exactly.

Frequently Asked Questions

Why does my amortization schedule show more interest than I expected?

Interest is calculated on the remaining balance, which is highest at the start. Even a modest rate like 8% on a 5-year loan adds over $4,000 in interest on a $20,000 loan. For longer terms, the effect is larger because the balance stays high for longer.

Can I create an amortization schedule in Excel?

Yes. Use the PMT function to get the payment, then for each row calculate interest = previous balance × monthly rate, principal = payment − interest, and new balance = previous balance − principal. Excel has built-in templates, but the formulas above work in any spreadsheet.

What happens if I make an extra payment?

If you make an extra payment and tell the lender to apply it to principal, your balance drops immediately. Future interest is calculated on the lower balance, so you pay less interest overall. The loan may end early if you keep making the same monthly payment.

Is the amortization schedule the same for a mortgage and a car loan?

Yes, if both have fixed rates and equal monthly payments. The only difference is the term and rate, which change the numbers but not the structure. Some mortgages have escrow for taxes and insurance, but those are not part of the amortization of the principal.

Why is my last payment different from the others?

Because the monthly payment is rounded to the cent, the final payment is adjusted to pay off the exact remaining balance. It may be a few cents higher or lower than the regular payment.

Does the schedule include PMI or property taxes?

No. The amortization schedule covers only the loan principal and interest. PMI, taxes, and insurance are separate costs that may be included in your total monthly payment but are not part of the loan amortization.

This calculator provides an estimate based on the inputs you enter. Your lender’s official amortization schedule will show the exact figures, including any fees or adjustments.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →