calculate-loan

01 Loan payments

Free Amortization Calculator Payment Schedule

Calculator No. 01-23271 · 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.

This free amortization calculator creates a full payment schedule for any fixed-rate loan: enter the loan amount, annual interest rate (APR), and term in years, and you get the monthly payment, total interest, and a complete breakdown of every payment by principal, interest, and remaining balance. The schedule shows exactly how much of each payment goes toward interest versus reducing the loan balance, so you can see the true cost of borrowing and how extra payments would shorten the term.

Formula

The calculator uses the standard fixed-rate loan payment formula:

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

Where:

  • P = loan principal (the amount borrowed, in dollars)
  • r = monthly interest rate = annual APR ÷ 12 (as a decimal, so 8% APR → 0.08/12 = 0.0066667)
  • n = total number of monthly payments = term in years × 12

Each row of the schedule is built from two recursive equations:

  • Interest portion = previous balance × r
  • Principal portion = monthly payment − interest portion
  • New balance = previous balance − principal portion

The payment is rounded to the nearest cent, and every subsequent calculation uses that rounded payment, so the final balance after the last payment is exactly zero (or within a cent due to rounding).

Worked Example

Using 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
  2. Total payments: n = 5 × 12 = 60
  3. Compute the payment: pmt = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. (1.0066667)^60 ≈ 1.4898457
  5. Numerator: 20000 × 0.0066667 × 1.4898457 ≈ 198.646
  6. Denominator: 1.4898457 − 1 = 0.4898457
  7. Payment ≈ 198.646 / 0.4898457 ≈ 405.53 (rounded to $405.53)

Total paid over 60 months = 60 × 405.53 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80. This matches the calculator’s output exactly.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at the APR divided by 12.
  • The schedule does not include fees, taxes, insurance, PMI, escrow, or prepayment penalties unless you add them manually.
  • All payments are exactly the same amount; if you pay extra or miss a payment, the schedule changes.

How to Read the Payment Schedule

The schedule lists each payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. In the early months, the interest portion is large and the principal portion is small. As the balance decreases, the interest portion shrinks and the principal portion grows. This is called amortization, from the Latin ad mortem (to death), because the debt is gradually killed off.

For the example above, the first payment of $405.53 breaks down as: interest = $20,000 × 0.0066667 = $133.33, principal = $405.53 − $133.33 = $272.20, new balance = $19,727.80. By the 60th payment, interest is only about $2.68 and principal is $402.85.

Common Mistakes and Misconceptions

  • Using the APR directly in the formula – you must divide by 12 to get the monthly rate. Forgetting this gives a payment that is far too high.
  • Confusing APR with the nominal rate – the APR includes some fees in some contexts, but this calculator uses the APR as the annual interest rate. If your loan has origination fees, the true cost is higher than the APR alone.
  • Rounding too early – if you round the monthly rate to 0.007 instead of 0.0066667, the payment will be off by a few cents. Always keep full precision until the final payment.
  • Ignoring payment timing – the formula assumes the first payment is due one full month after the loan is issued. If your first payment is due sooner (e.g., a mortgage with a short first period), the schedule shifts.
  • Thinking the total interest is simply APR × principal × years – that would be $8,000 in this example, but because you pay down the principal, the actual interest is $4,331.80, about half.

How to Use This Calculator for Real Decisions

To get a realistic schedule for your situation, enter the exact loan amount you plan to borrow, the APR your lender quotes (not an advertised rate), and the term in years. The calculator gives you the payment and total interest. You can then experiment with different terms: a 3-year term on the same $20,000 loan at 8% gives a payment of $626.45 and total interest of $2,552.20, while a 7-year term gives $311.87 and $6,197.08. Shorter terms mean higher payments but much less interest.

You can also simulate extra payments by manually adding to the principal portion in a spreadsheet, or by using a dedicated extra-payment calculator. Even a small extra payment of $50 per month on the 5-year loan would shorten the term by about 8 months and save roughly $500 in interest.

Limits of the Formula

This schedule assumes you make every payment on time and never miss one. It does not account for late fees, deferment, forbearance, or interest rate changes. It also assumes the rate is fixed; if you have an adjustable-rate mortgage (ARM), the payment changes when the rate resets. For loans with daily interest (like some private student loans), the monthly compounding here is an approximation. Always check your lender’s disclosure for the exact amortization schedule, which may differ by a few cents due to rounding conventions.

Frequently Asked Questions

What is the difference between an amortization schedule and a payment schedule?

They are the same thing. An amortization schedule is a table that shows each payment, how much goes to interest, how much to principal, and the remaining balance. Some people use “payment schedule” to mean just the list of due dates and amounts, but in lending, it refers to the full breakdown.

Why is the interest portion so high in the first few payments?

Because the loan balance is largest at the start. Interest is calculated as a percentage of the remaining balance, so early on, that balance is high, and the interest charge is correspondingly high. As you pay down principal, the interest charge shrinks, and more of your fixed payment goes to principal.

Can I use this calculator for a mortgage, car loan, or student loan?

Yes, as long as the loan has a fixed interest rate and equal monthly payments. Mortgages often have additional costs like property taxes and insurance that are escrowed, but those are not part of the loan amortization itself. Car loans are typically simple fixed-rate loans, and student loans can be fixed-rate as well. Just enter the loan amount, APR, and term.

What happens if I make an extra payment?

If you make an extra payment, the extra amount goes directly to reduce the principal (unless your lender applies it to interest first). This reduces the remaining balance, which means less interest accrues in future months. The loan will be paid off early unless you recast or recalculate. Many lenders allow you to specify that extra payments be applied to principal.

Why does the total interest shown differ from what my lender quoted?

Lenders may quote an APR that includes fees, or they may use a different rounding method. Also, if your first payment period is longer or shorter than one month, the schedule shifts. The calculator uses the standard formula; your lender’s disclosure will show the exact figures for your specific loan.

Is the monthly payment from this calculator the same as my minimum payment?

For a fixed-rate installment loan, yes, the monthly payment is the minimum and the required payment. For credit cards or lines of credit, the minimum payment is different because the balance is revolving. This calculator is for closed-end loans, not revolving credit.

The result is an estimate for educational purposes; your lender’s disclosure provides the exact 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 →