A variable rate amortization schedule shows how a loan with an interest rate that can change over time is paid off, including the new monthly payment and the remaining balance after each rate adjustment. You enter the loan amount, the initial interest rate, the loan term, and the frequency and size of rate changes, and the schedule recalculates your payment and balance at each change. This lets you see how future rate movements would affect your payment and total interest before you commit to the loan.
Formula
The variable rate amortization schedule is built on the standard fixed-rate payment formula, applied repeatedly for each rate period. For a given interest rate r (as a monthly decimal) and remaining term n (months), the monthly payment is:
Payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
where P is the remaining principal balance at the start of that period, r is the monthly interest rate (annual rate ÷ 12), and n is the number of months left in the loan. The balance after each payment is calculated as:
Balance = P × (1 + r)^k − Payment × ((1 + r)^k − 1) / r
where k is the number of payments made in that rate period. When the rate changes, the remaining balance becomes the new P, the remaining term becomes the new n, and the payment is recalculated. This is the same method lenders use for adjustable-rate mortgages (ARMs) and variable-rate student or personal loans.
Worked Example
Using the default values: $20,000 loan, 8% initial APR, 5-year term, adjustment every 1 year, new rate 9% after each adjustment.
- First period: monthly rate r = 8/1200 = 0.0066667, n = 60 months. Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1) = $405.53 (rounded to cents).
- After 12 payments, balance = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1) / 0.0066667 = $16,340.24.
- Second period: new rate 9%, monthly r = 0.0075, remaining term n = 48 months. New payment = 16340.24 × (0.0075 × (1.0075)^48) / ((1.0075)^48 − 1) = $406.51.
- Continue this for each year. Total interest = sum of all payments minus the $20,000 principal. With this example, total interest ≈ $4,331.47 (the calculator computes this exactly).
The key point: the payment changes when the rate changes, but the loan still ends on the original schedule (assuming no payment caps).
Assumptions
- Fixed rate within each adjustment period; rate changes occur at the specified intervals.
- Payments are made monthly at the end of each month.
- Interest compounds monthly at the annual rate divided by 12.
- No fees, taxes, insurance, or PMI are included.
- The new rate applies to the entire remaining balance, and the payment is recalculated to keep the original maturity date.
How to Read the Schedule
The schedule shows three things changing over time: the monthly payment, the interest portion of each payment, and the remaining balance. In the early years, most of each payment goes to interest; as the balance drops, more goes to principal. When the rate rises, the payment jumps up (as in the example), and when it falls, the payment drops. The total interest figure is the sum of all interest payments over the life of the loan, which is higher than a fixed-rate loan if rates rise, and lower if rates fall.
Common Mistakes and Misconceptions
- Assuming the payment stays the same: With a variable rate, the payment changes at each adjustment, even if the rate change is small.
- Ignoring the remaining term: When the rate changes, the payment is recalculated based on the remaining months, not the original term. This is why a small rate increase can cause a larger payment jump.
- Using the APR as the monthly rate: Always divide the annual rate by 12. An 8% APR means a monthly rate of 0.6667%, not 8%.
- Forgetting caps and floors: Real variable-rate loans often have limits on how much the rate can change per adjustment and over the life of the loan. This calculator does not model those caps; you must check your loan contract.
- Confusing the initial rate with the lifetime rate: The initial rate is often a teaser rate that lasts only until the first adjustment. The schedule shows the effect of the new rate, but the actual rate will depend on the index and margin.
How to Choose Between Fixed and Variable
This calculator helps you compare a variable-rate loan to a fixed-rate loan. Use it to see what happens if rates rise by 1%, 2%, or more. The trade-off is simple: a variable rate typically starts lower than a fixed rate, but you take on the risk that rates will increase. If you plan to keep the loan only a few years, the initial lower rate might save you money. If you plan to keep it for the full term, a fixed rate protects you from future increases. The calculator does not tell you which is better; it shows the numbers so you can decide based on your own risk tolerance.
Costs and Safety Considerations
Variable-rate loans carry interest rate risk. If rates rise, your payment increases, which could strain your budget. Some loans have payment caps that limit how much the payment can increase, but if the payment cap is lower than the interest increase, you could face negative amortization (the balance grows even though you make payments). Always read the loan contract to understand:
- The index (e.g., SOFR, LIBOR) and margin that determine your rate.
- Rate caps: periodic and lifetime maximums.
- Payment caps and whether unpaid interest is added to the principal.
- Prepayment penalties, if any.
This calculator assumes no caps, so the payment can increase without limit. For a more conservative estimate, use the maximum possible rate to see your worst-case payment.
Alternatives to Variable Rate Loans
If you are uncomfortable with rate uncertainty, consider a fixed-rate loan, which locks in a constant payment for the entire term. Another option is a hybrid loan (like a 5/1 ARM) that has a fixed rate for the first few years then adjusts. You can also refinance a variable-rate loan into a fixed-rate loan later, but that depends on your credit and market conditions. This calculator can model the variable part; for fixed-rate comparisons, use a standard amortization calculator.
Frequently Asked Questions
How often does the rate change on a variable rate loan?
The adjustment frequency is set in your loan contract. Common frequencies are every 1, 3, or 5 years for mortgages, and monthly or quarterly for some student and personal loans. The calculator lets you set this as the adjustment frequency input.
Can the payment go down if the rate goes down?
Yes. When the rate decreases, the payment is recalculated using the lower rate and the remaining term, so the payment drops. The balance continues to amortize over the original term.
What happens if the rate increases but I keep paying the same amount?
If you pay less than the required payment, the shortfall is added to the principal, and the loan will not be paid off by the original maturity date. This is called negative amortization. Most loans require you to pay at least the interest due, but some allow payment caps that cause this.
How is the new payment calculated after a rate change?
It uses the remaining balance, the new interest rate, and the remaining loan term. The formula is the same as the original payment formula, but with the updated values. The goal is to have the loan fully paid off by the original end date.
Does the total interest include the initial teaser rate?
Yes, the total interest is the sum of all interest payments over the entire loan term, including the initial period. The calculator uses the initial rate for the first period and the new rate for subsequent periods, so the total reflects the entire schedule.
What is the difference between APR and the interest rate in this calculator?
APR includes fees and other costs, so it is usually higher than the nominal interest rate. This calculator uses the APR as the annual interest rate for simplicity, but your actual loan may have a different APR that includes origination fees. Use the rate your lender quotes for the interest rate, not the APR with fees, for a more accurate payment estimate.
The result is an estimate and the lender’s disclosure gives the exact figures.
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 | Adjustment frequency | years | 1 | 0.0833 | 50 in rate2 | New rate after each adjustment | % | 9 | 0.01 | 100 out pmt | Monthly payment (first period) | $ | 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
- 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