Fixed vs. Variable Interest Rates: How Amortization Changes

Fixed-rate schedules are predictable mathematically

With a fixed rate, the periodic rate does not change. If the loan is fully amortizing with level payments, the scheduled principal-and-interest payment can remain constant from the first row through the final adjusted payment.

The interest portion still declines because the principal balance declines.

Variable-rate schedules have reset points

An adjustable or variable-rate loan uses rules that determine when the rate can change and how the new rate is calculated. The schedule may need a new payment after each reset so the remaining balance still amortizes over the remaining term.

Example of a rate increase

Suppose a 30-year loan begins at 5% and changes to 7% after five years. At the reset, first determine the balance after the initial five-year schedule. Then apply the new rate to that balance and the remaining 25-year term if the agreement calls for full re-amortization.

Simply replacing 5% with 7% on the original principal would overstate the balance subject to the new rate.

Caps, floors, and indexes matter

Real adjustable-rate agreements can include an index, margin, periodic cap, lifetime cap, floor, lookback date, and rounding rule. Those details determine the actual rate placed into the schedule. A generic “variable rate” assumption is not enough for an exact lender match.

Use row-level edits for historical or irregular loans

When auditing a loan that has already experienced several rate changes, it can be easier to enter each known rate change on the actual payment row rather than trying to force one formula to describe the entire history. The schedule should preserve prior rows while recalculating the future from the change point.

Build variable-rate scenarios without pretending to know the future

Future index values are usually unknown, so a long-term adjustable-rate projection should be presented as a scenario, not a prediction. One practical approach is to build a low-rate, unchanged-rate, and higher-rate case using the contract’s adjustment limits. This shows a range of possible payments and balances.

For an existing adjustable-rate loan, historical rows are different: those rates are known and should be entered exactly. Preserve the actual history through the most recent payment, then branch into scenarios only for future resets. This keeps the current balance anchored to known data.

When comparing the scenarios, report the payment immediately after each reset, the remaining balance at a chosen date, and cumulative interest. A single projected “average rate” can hide payment shocks that occur at specific adjustment dates.