calculate-loan

01 Loan payments

Run a Free Amortization Schedule: How It Works

Calculator No. 01-21884 · 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 run a free amortization schedule right here—enter your loan amount, interest rate, and term, and the calculator below generates a complete payment breakdown showing principal, interest, and balance for every period. You’ll also see the monthly payment and total interest upfront, so you can instantly understand the true cost of a loan before you commit.

Formula

The calculator uses the standard amortization formula for a fixed-rate loan with equal monthly payments:

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

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

After each payment, the interest portion is r × current balance, and the rest of the payment reduces principal. The balance after k payments is:

Bk = P(1 + r)k − M × [(1 + r)k − 1] / r

This is the same math that banks use for fixed-rate mortgages, auto loans, and personal loans.

Worked Example

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

  1. Convert APR to monthly rate: r = 0.08 / 12 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.48985
  4. Monthly payment: M = 20000 × [0.0066667 × 1.48985] / [1.48985 − 1] = 20000 × 0.009933 / 0.48985 ≈ 405.53
  5. Total paid: 405.53 × 60 = 24,331.80
  6. Total interest: 24,331.80 − 20,000 = 4,331.80

The calculator rounds the monthly payment to $405.53 and total interest to $4,331.80, matching the example exactly.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Equal monthly payments made at the end of each month.
  • Monthly compounding at APR ÷ 12, which is standard for most amortized loans.
  • No fees, taxes, insurance, or PMI are included—those would increase the actual payment.
  • No prepayment penalties or extra payments are modeled.

How to Read the Schedule

An amortization schedule is a table with one row per payment. Each row shows the payment number, the payment amount, the interest portion, the principal portion, and the remaining balance. For the default loan:

  • Payment 1: interest = 0.0066667 × 20,000 = $133.33, principal = 405.53 − 133.33 = $272.20, new balance = $19,727.80.
  • Payment 2: interest = 0.0066667 × 19,727.80 ≈ $131.52, principal = $274.01, balance = $19,453.79.
  • As the balance drops, the interest portion decreases and the principal portion increases—this is the hallmark of amortization.
  • By the final payment, the balance reaches exactly $0.

You’ll notice that early payments are interest-heavy. For a 30-year mortgage, the first payment might be 70% interest; for a 5-year auto loan, it’s closer to 50% at the start. This is normal, not a penalty.

Why Use an Amortization Schedule?

People run amortization schedules for several practical reasons:

  • Budgeting: Knowing the exact monthly payment helps you plan cash flow.
  • Comparing loans: A longer term lowers the payment but increases total interest—the schedule makes that trade-off visible.
  • Planning extra payments: You can see how an extra $50 per month shortens the term and reduces interest.
  • Tax or accounting purposes: The interest portion each year is often deductible (for mortgages, subject to tax rules—check with a professional).
  • Refinancing decisions: Compare your current schedule with a new loan’s schedule to see if the numbers make sense.

The schedule is also useful for understanding how much equity you build over time, especially for a home or car loan.

Common Mistakes and Misconceptions

  • Using the APR as the monthly rate: Always divide by 12. For 8% APR, the monthly rate is 0.6667%, not 8%.
  • Forgetting to multiply the term by 12: A 5-year loan has 60 payments, not 5.
  • Assuming interest is calculated on the original balance: Amortization uses the declining balance, so interest decreases over time.
  • Confusing APR with the nominal rate: APR includes some fees and reflects the true cost, but the schedule uses the APR as the annual rate for simplicity.
  • Thinking a lower payment is always better: A longer term reduces the payment but increases total interest—check the total cost, not just the monthly amount.

Another misconception: “If I pay extra, I just shorten the term.” Yes, but the interest savings can be significant. For the default loan, an extra $50 per month would cut the term by about 8 months and save roughly $400 in interest—but the exact numbers depend on when you make the extra payment.

How to Use the Calculator for Different Loans

The same formula works for any fixed-rate amortized loan. Here are examples:

  • Mortgage: $300,000 at 6.5% APR for 30 years → monthly payment ≈ $1,896.20, total interest ≈ $382,633.
  • Auto loan: $25,000 at 7% APR for 5 years → monthly payment ≈ $495.05, total interest ≈ $4,703.
  • Personal loan: $10,000 at 10% APR for 3 years → monthly payment ≈ $322.67, total interest ≈ $1,616.

For each, just change the inputs. The calculator handles any realistic combination (loan amount up to $100 million, APR up to 100%, term up to 50 years).

Limits of the Calculator

This calculator assumes a fixed rate and equal payments. It does not model:

  • Adjustable-rate loans (where the rate changes after a period).
  • Interest-only periods or balloon payments.
  • Fees, points, or closing costs that are rolled into the loan.
  • Prepayment penalties or biweekly payment plans.
  • Government program rules (e.g., student loan forgiveness, FHA requirements)—those are not part of the general arithmetic.

For those situations, you’d need a more specialized calculator or a lender’s disclosure. The result here is an estimate based on the inputs you provide; the exact figures will be in your loan contract.

Frequently Asked Questions

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

A payment calculator gives you just the monthly payment and total interest. An amortization schedule shows every payment in detail—how much goes to principal vs. interest each month, and the remaining balance. The schedule is more useful for tracking equity or planning extra payments.

Can I run an amortization schedule for a loan with extra payments?

Yes, but this basic calculator doesn’t include an extra-payment input. You can manually adjust by using the schedule and adding an extra principal payment to a specific month, then recalculating the remaining schedule. Many spreadsheet templates do this automatically.

Why does the interest portion start so high?

Because interest is calculated on the current balance, which is largest at the beginning. As you pay down principal, the interest portion shrinks. This is standard for amortized loans and is not a penalty—it’s just how the math works.

Is the APR the same as the interest rate?

APR (Annual Percentage Rate) includes the interest rate plus certain fees and costs, expressed as a yearly rate. For this calculator, we use the APR as the annual rate for simplicity. If your loan has fees, the true APR may be slightly higher than the nominal rate, and your payment may be higher if those fees are financed.

Can I use this for a variable-rate loan?

No, this calculator assumes a fixed rate for the entire term. For a variable-rate loan, the payment would change when the rate changes, so you’d need to recalculate with the new rate at each adjustment period.

How do I calculate the balance after a certain number of payments?

Use the balance formula: Bk = P(1 + r)k − M × [(1 + r)k − 1] / r. For example, after 12 payments on the default loan, the balance is about $16,600. You can also just look at the schedule row for that payment number.

Remember, this is an estimate for educational purposes—your lender’s disclosure will show the exact payment and schedule for your specific 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 →