calculate-loan

01 Loan payments

Free Online Amortization Schedule? Yes, Here’s How

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

Yes, you can get a free online amortization schedule from many websites, including this one. You enter the loan amount, interest rate, and loan term, and the calculator generates a full payment-by-payment breakdown showing principal, interest, and remaining balance. This article explains how these schedules work, what to look for in a good calculator, and common pitfalls to avoid.

Formula

The standard amortization formula calculates the fixed monthly payment (PMT) required to pay off a loan over a specified term at a fixed interest rate. The formula is:

PMT = P × (r × (1 + r)^n) / ((1 + r)^n – 1)

Where:

  • P = principal loan amount (in dollars)
  • r = monthly interest rate (annual rate 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)

Each monthly payment is split into interest (current balance × r) and principal (PMT − interest). The remaining balance after each payment is the previous balance minus the principal portion. The schedule repeats this for every period until the balance reaches zero.

Worked Example

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

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Total payments n = 5 × 12 = 60
  3. Monthly payment PMT = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. (1.0066667)^60 ≈ 1.48985
  5. Numerator = 20000 × (0.0066667 × 1.48985) ≈ 20000 × 0.009932 ≈ 198.64
  6. Denominator = 1.48985 − 1 = 0.48985
  7. PMT ≈ 198.64 / 0.48985 ≈ 405.53

So the monthly payment is $405.53 (rounded to cents). Total paid over 60 months = 60 × 405.53 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80. These match the calculator’s outputs.

Assumptions

  • Fixed interest rate for the entire loan term.
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at APR/12.
  • No fees, taxes, insurance, PMI, or escrow are included.
  • The loan is fully amortized (no balloon payment).

How to Read an Amortization Schedule

An amortization schedule is a table with columns for payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the schedule, a large portion of each payment goes toward interest; as the balance decreases, the interest portion shrinks and the principal portion grows. For example, in the $20,000 loan above, the first payment of $405.53 includes about $133.33 in interest and $272.20 in principal, leaving a balance of $19,727.80. By the 60th payment, interest is only about $2.69 and principal is $402.84.

You can use the schedule to see how much total interest you’ll pay over the life of the loan, which is often more than you might expect. It also helps you track how much equity you’re building (for a mortgage) or how much you still owe at any point.

Choosing a Free Online Amortization Calculator

Not all free online calculators are equal. Look for these features:

  • Customizable inputs: ability to enter loan amount, APR, term (in years or months), and sometimes start date.
  • Extra payment options: some calculators let you add one-time or recurring extra payments to see how they shorten the term and reduce interest.
  • Biweekly payment option: some allow you to compare monthly vs. biweekly payments (though biweekly is not always equivalent to an extra monthly payment).
  • Clear output: a full schedule you can view or print, plus a summary of total interest and payoff date.
  • Transparent formula: the site should show the formula and assumptions, so you know what you’re getting.
  • No hidden fees: the calculator should be genuinely free, without requiring a sign-up or payment.

Also check whether the calculator rounds the payment to the cent before computing the schedule. Some calculators use the unrounded payment, which can cause a slight discrepancy in the final balance (usually a few cents). A good calculator will round each payment to the cent and adjust the final payment if needed.

Common Mistakes and Misconceptions

  • Using the nominal APR instead of the monthly rate: Always divide the annual rate by 12 to get the monthly rate. For 8% APR, the monthly rate is 0.6667% (not 8%).
  • Forgetting to convert years to months: A 5-year loan has 60 monthly payments, not 5.
  • Rounding too early: If you round the monthly rate to 0.0067 instead of 0.0066667, the payment will be slightly off. Keep as many decimals as possible during calculations.
  • Assuming the schedule shows the same interest each month: Interest is recalculated on the remaining balance, so it decreases over time.
  • Thinking a 0% APR loan has no interest: True, but many loans have fees that effectively add to the cost; the schedule only covers the interest portion.

Limitations of the Basic Amortization Formula

The basic formula assumes a fixed rate and a fixed payment for the entire term. Real-world loans often have variations:

  • Adjustable-rate mortgages (ARMs): The rate changes after an initial period, so the payment and schedule change. You’d need a different calculator that allows rate adjustments.
  • Interest-only loans: For a period, you pay only interest, so the balance doesn’t decrease. The formula doesn’t apply during that period.
  • Balloon payments: Some loans require a large final payment. The standard formula doesn’t account for that.
  • Fees and points: Origination fees, closing costs, and mortgage points are not included in the interest calculation. To get the true cost, you’d need to include them in the principal or APR.
  • Prepayment penalties: If you pay off the loan early, some lenders charge a penalty. The schedule doesn’t model that.

For these cases, you may need a more specialized calculator or to adjust the inputs manually (e.g., add fees to the principal).

Frequently Asked Questions

Can I get a free amortization schedule without signing up? Yes, most online calculators, including this one, are free and require no registration. You just enter your loan details and see the schedule instantly.

Why does my amortization schedule show a different final balance than zero? This usually happens because the payment was rounded to the nearest cent, and the final payment may need to be adjusted. A good calculator will handle this by making the last payment slightly different to bring the balance to exactly zero.

How do I calculate amortization with extra payments? You can use a calculator that supports extra payments, or you can manually adjust the schedule by reducing the principal after each extra payment. The effect is that you pay less interest overall and finish the loan earlier.

What is the difference between APR and interest rate? The interest rate is the cost of borrowing the principal, while APR includes other fees and costs, expressed as a yearly rate. For the amortization schedule, you should use the APR if it reflects the true cost, but the schedule itself only shows interest, not fees.

Can I use an amortization schedule for a car loan or personal loan? Yes, the formula works for any fixed-rate, fully amortizing loan, including auto loans, personal loans, and student loans. Just enter the appropriate amount, rate, and term.

Is the amortization schedule the same as a loan payoff statement? No, a payoff statement from a lender gives the exact amount needed to pay off the loan on a specific date, including accrued interest and any fees. The amortization schedule is an estimate based on the original terms.

The result from this calculator is an estimate; your lender’s disclosure will provide the exact figures for your loan.

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 →