Choosing between a fixed-rate mortgage and an adjustable-rate mortgage is one of the most significant decisions homebuyers face. Each option calculates payments differently, and understanding these calculations is essential for making an informed choice.
Fixed-rate mortgages offer simplicity and predictability. Your interest rate never changes, so your principal and interest payment remains the same for the entire loan term. Adjustable-rate mortgages are more complex. They start with a fixed period, then reset periodically based on market conditions, causing payments to potentially rise or fall.
This article explains how both types of mortgages are calculated, compares their mathematical structures, and helps you understand which might suit your situation. Whether you are a first-time homebuyer or considering refinancing, knowing the math behind these loans puts you in control.
Fixed-Rate Mortgage Calculations
The Basic Formula
Fixed-rate mortgages use the standard amortization formula that ensures loans are fully paid by the end of the term. The formula is:
M = P × [ r(1 + r)^n ] ÷ [ (1 + r)^n – 1 ]
Where:
- M is the monthly principal and interest payment
- P is the loan amount (principal)
- r is the monthly interest rate (annual rate ÷ 12)
- n is the total number of payments (years × 12)
This formula calculates the exact payment needed to pay off the loan completely over the chosen term .
Step-by-Step Calculation Example
Consider a $300,000 fixed-rate mortgage at 6 percent annual interest for 30 years.
First, convert the annual rate to a monthly rate:
6% ÷ 12 = 0.5% = 0.005 in decimal form
Next, determine the total number of payments:
30 years × 12 months = 360 payments
Now apply the formula:
(1 + 0.005)^360 = 6.022
Numerator: $300,000 × 0.005 × 6.022 = $9,033
Denominator: 6.022 – 1 = 5.022
Monthly payment: $9,033 ÷ 5.022 = $1,798.65
This $1,798.65 is the monthly principal and interest payment. Property taxes and homeowners insurance would be added separately .
Using Spreadsheets for Calculation
Spreadsheet software makes fixed-rate calculations simple. In Excel or Google Sheets, the PMT function handles the formula automatically:
=PMT(annual rate/12, years×12, -loan amount)
For our example:
=PMT(6%/12, 30×12, -300000)
This returns $1,798.65, the same result as the manual calculation .
How Fixed Payments Amortize
Each fixed payment splits into interest and principal. The interest portion is calculated on the current loan balance. The principal portion is whatever remains after interest is paid.
First payment:
- Interest: $300,000 × 0.005 = $1,500
- Principal: $1,798.65 – $1,500 = $298.65
- New balance: $300,000 – $298.65 = $299,701.35
After 10 years (120 payments):
- Balance is approximately $245,000
- Interest: $245,000 × 0.005 = $1,225
- Principal: $1,798.65 – $1,225 = $573.65
After 20 years (240 payments):
- Balance is approximately $142,000
- Interest: $142,000 × 0.005 = $710
- Principal: $1,798.65 – $710 = $1,088.65
This shifting balance shows why extra payments early in the loan term save so much interest .
Adjustable-Rate Mortgage Basics
ARM Structure
Adjustable-rate mortgages have two distinct phases: an initial fixed period and subsequent adjustment periods. Common ARM types include:
- 5/1 ARM: Fixed for 5 years, then adjusts annually
- 7/1 ARM: Fixed for 7 years, then adjusts annually
- 5/5 ARM: Fixed for 5 years, then adjusts every 5 years
- 10/1 ARM: Fixed for 10 years, then adjusts annually
The first number indicates the fixed period in years. The second number indicates how often the rate adjusts after the fixed period ends .
Initial Rate Calculation
During the fixed period, an ARM calculates payments exactly like a fixed-rate mortgage. The initial rate, often called the teaser rate, is typically lower than prevailing fixed rates .
For a $300,000 5/1 ARM with an initial rate of 5 percent:
Monthly rate: 5% ÷ 12 = 0.004167
Number of payments in initial calculation: 30 years × 12 = 360
(1 + 0.004167)^360 = 4.468
Numerator: $300,000 × 0.004167 × 4.468 = $5,585
Denominator: 4.468 – 1 = 3.468
Monthly payment during first 5 years: $5,585 ÷ 3.468 = $1,610.46
This initial payment is lower than the fixed-rate example because of the lower starting rate .
Index and Margin
After the fixed period ends, the rate adjusts based on two components: an index and a margin .
The Index is a benchmark interest rate that fluctuates with market conditions. Common indexes include:
- SOFR (Secured Overnight Financing Rate)
- CMT (Constant Maturity Treasury)
- LIBOR (being phased out but still appears in some existing loans)
The Margin is a fixed percentage set by your lender when you take out the loan. Unlike the index, the margin never changes for the life of the loan .
The formula for the new rate at each adjustment is:
New Rate = Index + Margin
For example, if your ARM has a margin of 2.5 percent and the current index is 4 percent, your new rate would be 6.5 percent .
Fully Indexed Rate
The fully indexed rate is the sum of the index and margin at any given time. This is the rate you would pay if no caps limited the adjustment .
Using the example above, if your initial teaser rate was 5 percent and the fully indexed rate becomes 6.5 percent, your rate would increase at the next adjustment, subject to any caps.
ARM Adjustment Calculations
How Adjustments Work
When an ARM reaches its first adjustment date, the lender recalculates your payment using:
- The remaining loan balance
- The new interest rate (index + margin)
- The remaining loan term
The payment is recalculated as if you were starting a new loan with these three inputs, ensuring the loan will still be fully paid by the original maturity date .
First Adjustment Example
Continuing our $300,000 5/1 ARM example:
After 5 years (60 payments), the remaining balance is approximately $272,000 (assuming no extra payments). The initial 5 percent rate expires, and the new rate based on index + margin is 6.5 percent. The remaining term is 25 years (300 payments).
Monthly rate: 6.5% ÷ 12 = 0.005417
Number of payments remaining: 300
(1 + 0.005417)^300 = 5.022
Numerator: $272,000 × 0.005417 × 5.022 = $7,400
Denominator: 5.022 – 1 = 4.022
New monthly payment: $7,400 ÷ 4.022 = $1,840
The payment increases from $1,610 to $1,840, a $230 monthly increase.
Subsequent Adjustments
At each future adjustment date, the same process repeats. The lender takes the then-current balance, applies the new rate (subject to caps), and recalculates over the remaining term .
If rates fall, payments can decrease. Using the same loan, if at the next adjustment the rate drops to 5.5 percent:
Monthly rate: 5.5% ÷ 12 = 0.004583
Remaining term now 24 years (288 payments)
New payment would be approximately $1,670, lower than the previous $1,840.
ARM Caps and Their Effects
What Are Caps?
Caps are limits on how much your interest rate can change. They protect borrowers from extreme payment shocks. Most ARMs have three types of caps :
Initial Adjustment Cap limits how much the rate can increase at the first adjustment. Common limits are 2 percent or 5 percent.
Periodic Adjustment Cap limits how much the rate can change at each subsequent adjustment. This is typically 1 percent or 2 percent.
Lifetime Cap limits how much the rate can increase over the entire loan term. This is often 5 percent or 6 percent above the initial rate.
Cap Calculation Example
Using the previous example with caps:
- Initial rate: 5 percent
- First adjustment cap: 2 percent
- Periodic cap: 1 percent
- Lifetime cap: 5 percent (maximum rate 10 percent)
At first adjustment, index + margin = 6.5 percent. Without caps, the rate would become 6.5 percent. Since this is within the 2 percent first adjustment cap (5% + 2% = 7%), the rate becomes 6.5 percent.
At second adjustment, suppose index + margin = 8 percent. The periodic cap allows only a 1 percent increase from the previous 6.5 percent, so the new rate is 7.5 percent, even though the fully indexed rate is higher.
If at a later adjustment index + margin reaches 9 percent, the lifetime cap of 5 percent above the initial rate limits the maximum to 10 percent. If the calculated rate exceeds this, the cap applies.
Payment Caps
Some ARMs also have payment caps that limit how much your monthly payment can increase, regardless of rate changes. However, if payment caps prevent full interest from being paid, negative amortization can occur where unpaid interest is added to the loan balance .
Comparing Fixed and ARM Calculations
Certainty vs Flexibility
Fixed-rate mortgages offer absolute certainty. Using the PMT function, you can calculate your exact payment for the next 30 years . This predictability simplifies long-term budgeting.
ARMs offer lower initial payments but require projections. To estimate future payments, you must:
- Calculate the initial payment using the teaser rate
- Project the balance at first adjustment using amortization schedules
- Estimate future index values (though actual future rates are unknown)
- Apply caps to determine maximum possible payments
Break-Even Analysis
When comparing a fixed-rate mortgage to an ARM, calculate the break-even period. This is how long you must keep the ARM for the initial savings to offset potentially higher payments later.
Consider a fixed rate at 6 percent ($1,799 payment) versus a 5/1 ARM at 5 percent ($1,610 payment). The ARM saves $189 monthly for 60 months, totaling $11,340 in savings.
If after adjustment the ARM payment rises to $1,840, that is $41 more than the fixed payment. The $11,340 initial savings would cover this $41 monthly difference for 276 months (over 23 years). In this scenario, even with the rate increase, the ARM remains cheaper for a very long time .
Rate Scenarios
To fully compare, consider three scenarios:
Rates Stay Same: If rates at adjustment equal the initial rate, the ARM remains cheaper throughout.
Rates Rise Moderately: With typical caps, the ARM may still be cheaper for many years.
Rates Rise Sharply: Lifetime caps limit total damage, but payments could become higher than the fixed option.
Example Comparisons
Scenario 1: Short-Term Homeowner
Sarah plans to live in her home for 5 years. She compares:
Fixed 30-year at 6.25%: $1,847 monthly
5/1 ARM at 5.25%: $1,657 monthly
Over 5 years, the ARM saves $190 monthly × 60 months = $11,400. She sells before any adjustment, so she never faces higher payments. The ARM is clearly better .
Scenario 2: Long-Term Homeowner
Michael plans to stay for 20 years. He compares the same loans but must consider adjustments.
After 5 years, his ARM balance is $276,000. If rates rise to 7% at adjustment, his new payment becomes $1,950, higher than the fixed $1,847. He must decide whether the initial $11,400 savings justifies potential higher payments for 15 years.
If rates average 6.5% over the remaining term, total interest might still favor the ARM. If rates average 7.5%, the fixed would be cheaper .
Scenario 3: Rising Income
Early-career professional with expected income growth might choose an ARM knowing they can afford potential increases later. The lower initial payments help when income is lower .
Factors Affecting ARM Calculations
Index Selection
Different indexes behave differently. Some track short-term rates, others track longer-term rates. The index your lender uses affects how quickly your rate responds to market changes .
Margin Differences
Margins vary by lender and loan program. A lower margin means lower rates at each adjustment, all else equal. When comparing ARMs, consider both the initial rate and the margin .
Adjustment Frequency
More frequent adjustments (like 6/1 ARMs) mean rates change more often, potentially causing payment volatility. Less frequent adjustments (like 5/5 ARMs) provide more stability between resets .
Remaining Term
As loans age, the remaining term shortens. When rates increase later in the loan, the payment impact is smaller because fewer payments remain to amortize the balance .
Tools for Comparing Calculations
Online ARM Calculators
Specialized ARM calculators allow you to input:
- Loan amount and term
- Initial rate and fixed period
- Index and margin assumptions
- Cap structure
- Rate projections
These tools show estimated payments at each adjustment and total interest under different scenarios .
Spreadsheet Models
Building an ARM comparison in Excel involves:
- Creating an amortization schedule for the fixed period
- Determining balance at first adjustment
- Creating subsequent schedules with new rates
- Using PMT function for each adjustment period
- Summing payments and interest for comparison
Professional Guidance
Given the complexity of ARM calculations, mortgage professionals can run detailed projections showing best-case, worst-case, and likely-case scenarios based on historical index data .
Regulatory Disclosure Requirements
ARM Disclosures
Lenders must provide detailed ARM disclosures explaining:
- How your interest rate is determined
- The index your loan uses
- Your margin
- How often rates can change
- All cap limitations
- Historical payment examples
These disclosures include an example showing how payments would have changed based on actual index history over the past 15 years .
Understanding the Example
The required example typically shows a $10,000 loan with your ARM terms, illustrating maximum possible payments under the cap structure. To estimate your actual payments, divide your loan amount by $10,000 and multiply the example payments by that factor .
Making Your Decision
When Fixed Makes Sense
Fixed-rate mortgages are generally better when:
- You plan to stay in your home for many years
- You prefer predictable payments for budgeting
- You are uncomfortable with payment uncertainty
- Fixed rates are historically low
- You are on a fixed income
When ARMs Make Sense
Adjustable-rate mortgages may be preferable when:
- You plan to move before the fixed period ends
- You expect your income to rise significantly
- Initial rates are substantially lower than fixed
- You want to qualify for a larger loan
- You can afford potential payment increases
- You plan to refinance before adjustments
Hybrid Approaches
Some borrowers split the difference with combination strategies:
- Take an ARM but make payments based on the fixed rate, building a cushion
- Plan to refinance to a fixed rate before adjustments
- Use ARM savings to pay down principal faster
Conclusion
Fixed-rate and adjustable-rate mortgages use fundamentally different calculation methods. Fixed rates apply a single formula once, producing predictable payments for the entire loan term. ARMs require multiple calculations over time, incorporating index movements, margins, and caps that determine how payments evolve.
Understanding these calculations helps you make informed decisions. Fixed rates offer simplicity and certainty, with payments calculated using the standard amortization formula. ARMs offer lower initial payments but require projections about future rates and careful attention to caps.
The right choice depends on your specific situation. How long will you stay in your home? How much payment uncertainty can you tolerate? What do you expect from future interest rates? By understanding the math behind both options, you can answer these questions with confidence and choose the mortgage that best fits your financial life.