calculate-loan

01 Loan payments

Amortization Schedule with Fixed Payment: How It Works

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 with a payment amount set shows each monthly payment broken into interest and principal over the life of a loan, given a fixed payment. You enter the loan amount, annual interest rate, and loan term, and the calculator below produces the full schedule plus the total interest paid. The payment is level (same every month), and the schedule reveals how the interest portion shrinks while the principal portion grows over time.

Formula

The monthly payment for a fixed-rate amortizing loan is calculated using the standard annuity formula:

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

Where:

  • P = loan amount (principal), 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
  • PMT = the fixed monthly payment, in dollars

Once the payment is known, each row of the schedule is built recursively. For payment number k (starting at 1):

  • Interest for that month = previous balance × r
  • Principal paid = PMT − interest for that month
  • New balance = previous balance − principal paid

The final payment is adjusted by a few cents to bring the balance exactly to zero, because rounding the payment to two decimals leaves a tiny residual.

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. Number of payments: n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 / (1 − (1.0066667)^(−60)))
  4. Calculate (1.0066667)^(−60) ≈ 0.671216
  5. Denominator = 1 − 0.671216 = 0.328784
  6. Payment = 20000 × (0.0066667 / 0.328784) = 20000 × 0.020276 = 405.52
  7. Total paid = 405.52 × 60 = 24,331.20
  8. Total interest = 24,331.20 − 20,000 = 4,331.20

The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the example exactly.

Assumptions

This schedule assumes:

  • Fixed interest rate for the entire term (no adjustable-rate changes)
  • Payments are made at the end of each month, starting one month after the loan originates
  • Interest compounds monthly at a rate equal to APR/12
  • No fees, taxes, insurance, PMI, or escrow are included; those would change the actual payment
  • Payments are rounded to the nearest cent, and the last payment may differ by a few cents

The result is an estimate; your lender’s amortization schedule (which may use daily interest or a different rounding method) is the authoritative document.

How to Read an Amortization Schedule

Each row of the schedule has four key numbers: payment number, interest paid, principal paid, and remaining balance. Early in the term, interest consumes most of the payment. For the $20,000, 8%, 5-year example, the first payment of $405.52 breaks down as $133.33 interest and $272.19 principal, leaving a balance of $19,727.81. By the 60th payment, interest is only $2.68 and principal is $402.84.

The cumulative interest column shows how much you have paid in interest so far. The total interest is the sum of all interest rows, which equals the difference between total payments and the original principal. You can also see that the balance declines faster in later years because more of each payment goes to principal.

How to Choose a Payment Amount

When you set a payment amount above the minimum required, the amortization schedule changes dramatically. The calculator above uses the payment derived from the term, but you can also work backward: given a target monthly payment, you can find how many months it takes to pay off the loan using the formula:

n = −ln(1 − r × P / PMT) / ln(1 + r)

For example, if you pay $500 per month on the same $20,000 loan at 8% APR, the number of months is −ln(1 − 0.0066667 × 20000 / 500) / ln(1.0066667) ≈ 44.3, so 45 months. The total interest would be $500 × 45 − $20,000 = $2,500, saving about $1,831 compared to the 60-month schedule. However, note that the payment must exceed the monthly interest (r × P) or the balance never decreases; in this case, that threshold is $133.33.

Common Mistakes and Misconceptions

  • Using APR as the monthly rate: Always divide the annual rate by 12. An 8% APR means 0.6667% per month, not 8% per month.
  • Ignoring payment timing: The formula assumes the first payment is one full month after the loan starts. If you make the first payment sooner or later, the schedule shifts.
  • Rounding too early: If you round the monthly rate to 0.0067 instead of 0.0066667, the payment will be off by a few cents, which compounds over 60 months.
  • Thinking the interest is simple: Amortized loans use compound interest on the declining balance, so the total interest is less than simple interest on the full principal for the whole term.
  • Believing the last payment equals the others: Due to rounding, the final payment is often a few cents different to bring the balance to zero.

Extra Payments and Refinancing

Making extra payments directly reduces the principal, which shortens the term and lowers total interest. For example, adding $50 to each monthly payment on the $20,000, 8%, 5-year loan reduces the payoff time from 60 months to about 51 months and cuts total interest by roughly $800. If you refinance to a lower rate, the payment formula still applies, but you must recalculate using the new rate and remaining balance. The schedule resets, but the same math governs it.

Limitations of the Standard Schedule

The standard amortization formula assumes a constant rate and regular payments. Real-world loans may have:

  • Variable rates that change at specified intervals
  • Payment holidays or deferment periods
  • Balloon payments at the end
  • Daily interest accrual (common in some private loans)
  • Prepayment penalties that affect the true cost of extra payments

For these, you need a custom schedule that accounts for the changing parameters. The calculator here is a baseline that works for the most common fixed-rate, level-payment loans.

Frequently Asked Questions

Why does the interest portion decrease over time?

Because interest is calculated on the remaining balance. As you pay down principal, the balance shrinks, so the interest charged on that smaller balance also shrinks. The payment stays the same, so the freed-up money goes to principal.

What happens if I miss a payment?

Missing a payment typically adds late fees and may cause interest to accrue on the unpaid amount, increasing the balance. The schedule would then be recalculated, often with a higher payment or extended term, depending on the lender’s policy. The standard formula no longer applies directly.

Can I use this calculator for a mortgage with escrow?

No. The calculator only covers principal and interest. Property taxes, homeowners insurance, and PMI are separate costs that are often escrowed into your monthly payment but are not part of the amortization formula. You would need to add those amounts separately.

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

Use the formula: Balance after k payments = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r. For example, after 12 payments on the $20,000, 8%, 5-year loan, the balance is 20000 × (1.0066667)^12 − 405.52 × ((1.0066667)^12 − 1) / 0.0066667 ≈ $16,612. You can also see this in the schedule’s balance column.

Is it better to make biweekly payments?

Biweekly payments (half the monthly payment every two weeks) result in 26 half-payments per year, which equals 13 full monthly payments instead of 12. That extra payment reduces principal faster, shortening the term and lowering total interest. The math is the same as making one extra monthly payment per year, but you must confirm your lender applies biweekly payments correctly.

Remember, this calculator provides an estimate for educational purposes. Your lender’s official amortization schedule and loan disclosure give the exact figures 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 →