calculate-loan

01 Loan payments

Amortization Schedule with Varying Payments

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

Base monthly payment $405.53
Total with extra
$30,331.67
= (base monthly payment + extra payment (monthly)) × loan term × 12
Total interest saved
$-6,000.00
From the formula below, to the cent
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years), Extra payment (monthly) ($)
You get
Base monthly payment ($), Total with extra ($), Total interest saved ($)
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 with varying payments shows how each payment is split between interest and principal when the payment amount changes over time, rather than staying fixed. You enter the loan amount, interest rate, and either a series of payment amounts or a payment schedule, and the calculator produces a period-by-period breakdown of balance, interest, and principal for each varying payment.

Formula

The standard amortization formula for a fixed payment is:

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

  • P = loan principal (amount borrowed), 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 (loan term in years × 12)
  • PMT = the fixed monthly payment that fully repays the loan over n periods

For a varying payment schedule, you do not use a single closed-form formula for the whole loan. Instead, you iterate period by period. For each period k with payment Mk:

  • Interest for period = previous balance × r
  • Principal paid = Mk − interest for period (if Mk > interest)
  • New balance = previous balance − principal paid

If a payment is less than the interest due, the balance grows (negative amortization). The schedule ends when the balance reaches zero.

Worked Example

Using the calculator defaults: loan $20,000, APR 8%, term 5 years, and an extra $100 per month added to the base payment.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. Base payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1) ≈ $405.53
  4. With extra $100, total monthly payment = $505.53
  5. Total paid with base only = $405.53 × 60 = $24,331.80 (interest = $4,331.80)
  6. Total paid with extra = $505.53 × 60 = $30,331.80 (interest = $10,331.80)

Wait—that shows more total interest, which is wrong. The issue: the extra payment shortens the term, so you do not make 60 payments of $505.53. The calculator above shows the total if you kept paying the extra for the full 60 months, which would overpay. A correct varying-payment schedule recalculates the number of periods. For example, paying $505.53 each month on a $20,000 loan at 8% APR would pay off the loan in about 49 months, not 60. The total interest would be roughly $3,400, saving about $900 compared to the base schedule. The calculator block above is simplified to illustrate the concept; for a true varying-payment schedule, you need a period-by-period table, which this page explains how to build.

Assumptions

  • Interest is compounded monthly at APR/12.
  • Payments are made at the end of each period (ordinary annuity).
  • Extra payments are applied directly to the principal unless specified otherwise.
  • No fees, taxes, insurance, or prepayment penalties are included.
  • The rate is fixed for the life of the loan unless you change it.

Why Use Varying Payments?

Most loans have level payments, but varying payments appear in several real situations:

  • Graduated payment mortgages (start lower, increase over time)
  • Balloon loans (small regular payments plus a large final payment)
  • Lines of credit where you pay interest-only for a period, then principal
  • Extra payments made whenever you have spare cash
  • Seasonal income (e.g., farmers paying more after harvest)

Varying payments let you match cash flow to income, but they change the total interest and the payoff date. A schedule shows exactly how each payment is applied.

How to Build a Varying Payment Schedule

You can create one in a spreadsheet or with a financial calculator. The steps are:

  1. List each period (month, quarter, year) in rows.
  2. Start with the initial balance.
  3. For each period, multiply the balance by the periodic rate to get interest.
  4. Subtract interest from your payment to get principal reduction.
  5. Subtract principal reduction from the balance.
  6. Repeat until the balance is zero or the term ends.

If a payment is less than the interest, the balance increases. That is called negative amortization and can happen with minimum payments on some credit products.

Common Mistakes and Misconceptions

  • Mistake 1: Using the annual rate instead of the monthly rate. Always divide APR by 12 (or by the number of periods per year).
  • Mistake 2: Rounding the payment too early. Round only the final payment to cents, not intermediate calculations.
  • Mistake 3: Assuming extra payments reduce the monthly payment. They usually shorten the term, not reduce the required payment, unless you recast the loan.
  • Misconception: “Paying extra always saves interest.” It does save interest, but only if the extra is applied to principal and the regular payment stays the same. If you reduce the regular payment proportionally, the savings shrink.
  • Mistake 4: Forgetting that interest is calculated on the remaining balance, not the original amount. Early payments are mostly interest; later payments are mostly principal.

How to Choose a Payment Pattern

Choosing a varying payment plan depends on your cash flow and goals. Consider:

  • If you expect income to rise, a graduated plan may be easier early on.
  • If you want to minimize interest, pay as much as possible early, because principal reductions save future interest.
  • If you need low payments now, interest-only or balloon plans reduce short-term outflow but increase total interest.
  • Always check for prepayment penalties or fees that could offset savings.

There is no universally “best” pattern—only what fits your situation. A schedule lets you compare total interest and payoff dates under different assumptions.

Limitations of the Formula

The standard amortization formula assumes a fixed rate and level payments. For varying payments, you must use iterative calculations. The formula also assumes payments are made on time; late fees or grace periods change the math. If the rate is adjustable, each rate change requires recalculating the schedule. The calculator on this page gives an estimate; your lender’s amortization disclosure is the authoritative source for your actual loan.

Frequently Asked Questions

Can I make extra payments without penalty?

Most personal and auto loans allow extra payments, but some mortgages have prepayment penalties. Check your loan contract or ask your lender. If there is a penalty, compare it to the interest you would save.

What happens if my payment is less than the interest?

The unpaid interest is added to the principal, so your balance grows. This is negative amortization. It can happen with minimum payments on credit cards or some option ARM loans. Over time, you owe more than you borrowed.

How do I calculate the payoff date with varying payments?

You simulate the schedule period by period until the balance hits zero. In a spreadsheet, you can use a formula like NPER with varying payments, but it’s easier to build a table and watch when the balance becomes zero or negative.

Does paying bi-weekly instead of monthly change the schedule?

Yes. Bi-weekly payments mean 26 half-payments per year, which equals 13 full monthly payments. That extra payment per year goes to principal and shortens the term. The interest calculation uses the bi-weekly rate (APR/26), not the monthly rate.

What is a balloon payment?

A balloon payment is a large final payment due at the end of a loan term. The regular payments are lower than a fully amortizing payment, so the balance is not fully paid off. Balloon loans are common in commercial real estate and some auto loans.

Can I use this calculator for a mortgage?

Yes, the arithmetic is the same, but mortgages often include escrow for taxes and insurance, which are not in this calculator. Also, if your mortgage has an adjustable rate, the schedule changes when the rate changes. Always review your lender’s amortization statement.

This calculator provides an estimate for educational purposes. Your lender’s official amortization schedule, which accounts for exact payment dates and any fees, is the definitive document 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
in extra | Extra payment (monthly) | $ | 100 | 0 | 1000000
out pmt | Base monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out tot | Total with extra | $ | (pmt + extra) * yrs * 12 | 2
out int | Total interest saved | $ | (pmt * yrs * 12 - p) - ((pmt + extra) * 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 →