Loan Calculator: Fixed vs Variable Rate and What Your Lender Does Not Tell You
Reviewed by Jerry Croteau, Founder & Editor
Table of Contents
When you borrow money, the monthly payment is the number the lender wants you to focus on. The number that actually matters is the total interest cost over the life of the loan — and behind that number are several variables that lenders are required to disclose but rarely explain clearly.
Our shows payment, total interest, and full amortization for any loan. This guide covers what you need to understand before signing.
The fundamental loan formula
Every fixed-rate loan payment comes from the amortized payment formula:
Payment = P x [r(1+r)^n] / [(1+r)^n - 1]
Where P = principal, r = monthly rate (APR/12), n = number of payments
This formula produces a constant payment that covers an ever-shifting mix of interest and principal. Early payments are mostly interest; late payments are mostly principal.
Fixed vs variable rate: the core tradeoff
Fixed rate loans
The interest rate stays constant for the entire loan term. Your payment never changes. You trade the possibility of lower rates for certainty and predictability.
Best for: mortgages, long-term personal loans, any situation where you need predictable monthly cash flow.
Variable rate loans
The interest rate adjusts periodically based on a benchmark rate (typically SOFR — Secured Overnight Financing Rate — which replaced LIBOR) plus a margin. The loan documents specify the index, the margin, the adjustment frequency, and any rate caps.
Variable rate anatomy: Rate = Index + Margin
Example: "SOFR + 2.5%" means if SOFR is 4.3%, your rate is 6.8%.
| Feature | Fixed rate | Variable rate |
|---|---|---|
| Payment predictability | Perfect — never changes | Changes with rate adjustments |
| Initial rate (typical) | Higher | Lower (teaser rate) |
| Risk | None (lender absorbs rate risk) | Rate can rise significantly |
| Best environment | Low-rate environment (lock in) | High-rate environment (expecting cuts) |
| Short-term borrowing | Slightly disadvantaged | Advantaged if rates fall |
Total interest cost: the number that matters
A $25,000 personal loan at 8% over 5 years:
Monthly payment: $507.64
Total paid: $507.64 x 60 = $30,458
Total interest: $5,458
The same loan at 12%:
Monthly payment: $556.11
Total paid: $33,367
Total interest: $8,367 — $2,909 more for a 4-point rate difference
| APR | Monthly payment ($25K, 5yr) | Total interest |
|---|---|---|
| 6% | $483 | $3,999 |
| 8% | $508 | $5,458 |
| 10% | $531 | $6,955 |
| 14% | $581 | $9,872 |
| 20% | $662 | $14,745 |
| 29.99% (credit card rate) | $799 | $22,936 |
APR vs interest rate: the difference matters
The interest rate is the pure cost of borrowing. The APR (Annual Percentage Rate) includes origination fees, points, and other lender costs spread over the loan term. The APR is the more complete cost comparison tool.
A loan with a 7% interest rate and $1,000 origination fee on a $20,000 / 3-year loan has an APR of approximately 9.3% — meaningfully higher than the headline rate. Always compare APR, not interest rate, when shopping loans.
Prepayment penalties
Some loans charge a fee for paying off early. This effectively increases the true cost of the loan if you plan to pay ahead of schedule. Types:
- Hard prepayment penalty: Fee applies regardless of how you pay off early (sale, refinance, extra payments). Less common after the 2010 Dodd-Frank regulations for mortgages, but still appears in personal and auto loans.
- Soft prepayment penalty: Fee applies only if you refinance, not if you sell the underlying asset. More common in mortgages.
- Step-down penalty: Fee decreases over time — e.g., 3% in year 1, 2% in year 2, 1% in year 3, then none. Common in commercial real estate.
If you might pay off early, calculate whether the savings exceed the penalty. A 2% prepayment penalty on a $25,000 loan is $500 — weigh that against the interest saved.
Loan term impact: shorter is almost always cheaper
| Term | Monthly payment ($25K @ 8%) | Total interest |
|---|---|---|
| 2 years | $1,130 | $2,124 |
| 3 years | $783 | $3,183 |
| 5 years | $508 | $5,458 |
| 7 years | $389 | $7,706 |
Going from 5 to 7 years saves $119/month but costs $2,248 more in interest. The monthly savings rarely justify the additional interest unless cash flow is genuinely tight.
Questions to ask before signing
- Is this a fixed or variable rate? If variable, what is the index, margin, adjustment frequency, and rate cap?
- What is the APR (not just the interest rate)?
- Is there a prepayment penalty? If yes, what type and what is the fee?
- Are there origination fees, application fees, or other upfront costs?
- Is the interest simple or compound? (Personal and auto loans are almost always simple interest; credit cards compound daily.)
Model any loan scenario with the — adjust rate, term, and principal to see total interest cost and the full amortization schedule before you sign.
Related Calculators
Get smarter with numbers
Weekly calculator breakdowns, data stories, and financial insights. No spam.
Discussion
Be the first to comment!
