calculate-loan

01 Loan payments

Amortization Schedule by Payment: Full Guide

Calculator No. 01-20795 · 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 by payment shows exactly how each payment is split between interest and principal over the life of a loan. You enter the loan amount, annual interest rate (APR), and term in years, and the calculator below gives your monthly payment, total interest, and the full breakdown you can use to see your balance at any point.

Formula

The standard amortization formula for a fixed-rate, level-payment loan is:

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

Where:

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = APR / 12 / 100 (e.g., 8% APR → r = 0.08/12 = 0.0066667)
  • n = total number of payments = term in years × 12

The payment is rounded to the nearest cent. Each month’s interest is r × current balance, and the rest of the payment reduces principal. The new balance is previous balance − principal portion.

Worked Example

Using the default values: loan $20,000, APR 8%, term 5 years.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. (1.0066667)^60 ≈ 1.48985
  5. Payment = 20000 × (0.0066667 × 1.48985) / (1.48985 − 1) = 20000 × 0.0099323 / 0.48985 ≈ 405.53

So the monthly payment is $405.53 (rounded). Total paid = 60 × 405.53 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80. The calculator shows exactly these numbers.

Assumptions

  • Fixed interest rate for the entire term
  • Payments are made at the end of each month
  • Interest compounds monthly at APR/12
  • No fees, taxes, insurance, PMI, or escrow are included
  • The payment is rounded to the cent, and total interest uses that rounded payment

Real loans may have origination fees, prepayment penalties, or variable rates—those are not modeled here.

How to Read an Amortization Schedule

Each row of an amortization schedule lists the payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. Early in the term, interest consumes most of the payment. For the $20,000 loan above, the first payment’s interest is 20000 × 0.0066667 = $133.33, so principal reduction is only $272.20. By the last payment, interest is just a few dollars.

To see your own schedule, you can extend the calculation: after k payments, the remaining balance is:

Balance = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r

For example, after 12 payments on the default loan: balance = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1)/0.0066667 ≈ 20000 × 1.082999 − 405.53 × 12.4499 ≈ 21659.98 − 5048.89 = $16,611.09. That matches the schedule.

Common Mistakes and Misconceptions

  • Using APR as a monthly rate: Always divide by 12 and by 100. 8% APR is 0.08/12 = 0.0066667 per month, not 0.08.
  • Forgetting to round the payment: Lenders round to the cent. Using an unrounded payment changes the final balance slightly, which matters for payoff calculations.
  • Assuming equal interest each month: Interest is calculated on the current balance, so it decreases every month. The principal portion increases correspondingly.
  • Confusing APR with the periodic rate: APR is the annual rate; the monthly rate is APR/12. Some loans use daily compounding, but this calculator assumes monthly.

How to Use This for Your Own Loan

Enter your actual loan amount, APR, and term. The calculator gives the payment and total interest. To build a full schedule, you can use the balance formula for each month or use a spreadsheet. Many lenders provide an amortization schedule with your loan documents—check the disclosure statement. If you plan to make extra payments, the schedule changes: extra payments reduce principal faster, lowering total interest and shortening the term. You can estimate the effect by recalculating with a shorter term or a higher payment, but the exact schedule depends on when the extra payment is applied.

When an Amortization Schedule Is Useful

An amortization schedule helps you see how much equity you build in an asset (like a house or car) over time, how much interest you’ll pay in total, and how prepayments affect your loan. It is also useful for comparing loan offers: a lower APR or shorter term reduces total interest, but the schedule shows the trade-off with a higher monthly payment. However, don’t use it to decide whether a loan is “good” or “bad”—that depends on your budget and goals, which are personal.

Limits of the Amortization Formula

This formula assumes a fixed rate and constant payments. It does not handle adjustable-rate mortgages (ARMs), interest-only periods, balloon payments, or loans with fees rolled in. For those, you need a more complex model. Also, the formula gives the payment before any taxes, insurance, or PMI—those are separate costs. The result is an estimate; your lender’s disclosure will show the exact figures for your specific loan.

Frequently Asked Questions

What is the difference between APR and interest rate?

APR (annual percentage rate) includes the interest rate plus certain fees, expressed as a yearly rate. The interest rate is the base cost of borrowing. For amortization, the monthly rate is typically APR/12, but if fees are involved, the effective rate may differ.

How do extra payments affect my amortization schedule?

Extra payments go directly to principal (unless the lender directs otherwise). This reduces the balance faster, which means less interest accrues in future months. The loan may be paid off early, and total interest decreases. The exact effect depends on the amount and timing of the extra payment.

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

Yes, the formula works for any fixed-rate, level-payment loan. Just enter the loan amount, APR, and term. For loans with different payment frequencies (e.g., biweekly), adjust the rate and number of periods accordingly.

Why does my payment amount differ from the lender’s quote?

Lenders may include fees, insurance, or taxes in the payment. They might also use a slightly different rounding method or a different compounding assumption. Always check the loan estimate for the exact payment breakdown.

What happens if I miss a payment?

Missing a payment can trigger late fees and may affect your credit score. The amortization schedule assumes on-time payments; a missed payment will change the balance and interest accrual. Contact your lender to understand the consequences.

How do I calculate the payoff amount?

The payoff amount is the remaining balance plus any accrued interest and fees up to the payoff date. Use the balance formula above for a given month, then add any per-diem interest for the days since the last payment. Your lender will provide the exact payoff figure.

This calculator provides an estimate for educational purposes; your lender’s official disclosure gives the exact terms and figures.

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 →