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).
- Monthly rate r = 8 / 1200 = 0.0066667
- Number of payments n = 5 × 12 = 60
- Payment = 20000 × (0.0066667 / (1 − (1.0066667)^(−60)))
- (1.0066667)^(−60) ≈ 0.67121
- 1 − 0.67121 = 0.32879
- 0.0066667 / 0.32879 ≈ 0.020276
- 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
- Personal Loans Interest Free? The Real Answer$405.53
- Personal Loan 0% Interest: Is It Real?$405.53
- Personal Loan Zero Interest: Is It Real?$405.53
- Only Loans LLC: What It Is and How It Works$405.53
- Personal Loan and Interest Only Option?$133.33
- No Interest Personal Loan? What It Really Means$405.53