calculate-loan

01 Loan payments

Floating Rate Amortization Schedule: How It Works

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

A floating rate amortization schedule shows how loan payments and the remaining balance change when the interest rate is not fixed but adjusts periodically, such as every month, quarter, or year. You enter the loan amount, initial rate, term, and how often the rate changes, and the schedule recalculates each payment period using the current rate, so the payment amount can go up or down over the life of the loan.

Formula

The payment for any period is calculated with the standard amortization formula:

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

Where:

  • P = outstanding principal balance at the start of the period (dollars)
  • r = periodic interest rate = annual rate ÷ (12 × number of periods per year). For monthly payments, r = APR / 1200.
  • n = number of payments remaining in the loan term (months)

The calculator above computes the first payment using the initial APR and the full term. It also shows the total interest you would pay if the rate never changed, which serves as a baseline for comparing adjustable-rate scenarios.

Worked Example

Using the defaults: loan amount $20,000, initial APR 8%, term 5 years (60 months).

  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. (1.0066667)^(−60) ≈ 0.67121
  5. 1 − 0.67121 = 0.32879
  6. 0.0066667 / 0.32879 ≈ 0.020276
  7. Payment = 20000 × 0.020276 = $405.52

The calculator shows $405.52 as the first monthly payment. Total interest if the rate never changes = $405.52 × 60 − $20,000 = $4,331.20.

Assumptions

  • Payments are made at the end of each month.
  • Interest compounds monthly at the annual rate divided by 12.
  • The rate is fixed for the initial period (here 12 months) and then could change, but the calculator above only shows the initial payment and baseline interest; it does not simulate future rate changes.
  • No fees, taxes, insurance, or other charges are included.

How a Floating Rate Schedule Differs from a Fixed Rate

With a fixed-rate loan, the payment stays the same for the entire term because the interest rate never changes. With a floating (or adjustable) rate, the rate is reset at specified intervals based on an index (like SOFR or a prime rate) plus a margin. When the rate adjusts, the payment is recalculated using the remaining balance, the new rate, and the remaining term. This means your payment can increase or decrease, and the proportion of each payment going to interest versus principal shifts accordingly.

Why Lenders Use Floating Rates

Floating rates transfer some interest rate risk from the lender to the borrower. Lenders can offer a lower initial rate because they are not locked into a fixed return for the whole term. For borrowers, an adjustable-rate loan often starts with a lower payment than a fixed-rate loan, but that payment is not guaranteed to stay low. If market rates rise, your payment rises; if they fall, your payment falls.

Common Mistakes When Reading a Floating Rate Schedule

  • Assuming the first payment stays constant: The first payment is only valid until the first rate adjustment. Always check the adjustment frequency.
  • Ignoring the remaining term: When the rate changes, the payment is recalculated over the remaining months, not the original term. A shorter remaining term means a larger payment increase for the same rate hike.
  • Confusing APR with the periodic rate: APR is annual; the monthly rate is APR/12. A 6% APR is 0.5% per month.
  • Forgetting caps: Many adjustable loans have rate caps (e.g., a maximum increase of 2% per adjustment and 5% over the loan life). These caps limit how much your payment can change, but they are not included in the simple calculator above.

How to Use a Floating Rate Schedule for Planning

To plan for possible payment changes, you can create multiple schedules using different assumed future rates. For example, run the calculation with the initial rate, then with a rate 2% higher, then 2% lower. See how your payment changes in each case. This helps you understand your exposure to rate movements. Remember that the actual future rate depends on market conditions and the specific index your loan uses—those are not predictable from the loan terms alone.

Limits of This Calculator

This calculator only gives the initial payment and a baseline total interest. It does not model:

  • Rate caps or floors
  • Index changes or margins
  • Payment caps that limit how much the payment can change even if the rate changes
  • Negative amortization (when the payment is less than the interest due, causing the balance to grow)
  • Prepayment or extra payments

For a full floating-rate amortization schedule, you would need to input a projected path of future rates, which is speculative. This tool is for educational estimation only.

Frequently Asked Questions

How is the payment recalculated after a rate adjustment?

At each adjustment date, the lender takes the remaining principal balance, the new annual rate, and the number of months left in the loan term, then applies the standard amortization formula to find the new payment that will pay off the loan by the original end date.

Can my payment go down with a floating rate?

Yes, if the index rate falls, your rate and payment can decrease. However, the payment will never go below what is needed to cover the interest and gradually pay down the principal over the remaining term, unless the loan has a payment cap that could cause negative amortization.

What is a rate cap?

A rate cap is a limit on how much the interest rate can change at each adjustment (periodic cap) and over the life of the loan (lifetime cap). For example, a 2/5 cap means the rate can increase by no more than 2% at each adjustment and no more than 5% total over the loan’s life. Caps protect you from extreme payment spikes but are not included in this basic calculator.

Should I choose a floating rate or a fixed rate?

That depends on your risk tolerance and how long you plan to keep the loan. A floating rate often starts lower but can rise; a fixed rate gives certainty but may start higher. This calculator helps you see the initial payment difference, but it cannot predict future rates. Consider your budget’s ability to absorb a higher payment and how long you expect to hold the loan.

What is negative amortization?

Negative amortization occurs when your payment is less than the interest charged, so the unpaid interest is added to the principal balance, causing the balance to increase over time. This can happen with some adjustable-rate loans that have payment caps. It is generally risky and is not modeled by this calculator.

The result shown is an estimate for educational purposes; the exact figures for your loan will be provided in the lender’s official disclosure.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Initial interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
in adj | Rate adjustment frequency | months | 12 | 1 | 600
out pmt | First monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest (if rate never changes) | $ | 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 →