Mortgage Calculator Explained: Fixed vs Reducing-Balance, Rates, and Overpayment
What a Mortgage Calculator Actually Computes
Don't be intimidated by the form. A mortgage calculation comes down to two variables: repayment method (fixed vs reducing-balance) + interest rate. Set those, and monthly payment, total interest, and total cost fall out automatically.
Universal symbols:
P= loan principal (home price − down payment, not the price itself)R= annual interest rate (%), monthly ratei = R ÷ 12 ÷ 100n= total number of payments = loan term in years × 12
Fixed Payment (Amortizing): Same Bill Every Month
You pay the same amount each month. Early on, interest is a bigger slice and principal a smaller one; the mix flips over time. Good for stable income and predictable budgeting.
Formula: monthly payment M = P × i × (1+i)^n ÷ [(1+i)^n − 1]
Example: borrow 1,000,000 at 3.1% over 30 years (n=360, i≈0.002583) → monthly ≈ 4,270, total interest ≈ 537,000.
Reducing Balance: Fixed Principal, Shrinking Payment
You repay the same principal each month; interest falls as the balance drops, so the payment decreases over time — but the early payments are heavier. Suited to higher incomes or anyone planning to overpay.
- fixed principal per month =
P ÷ n - month k payment =
P÷n + (P − paid so far) × i - first payment =
P÷n + P×i; it drops by(P÷n) × ieach month - total interest ≈
P × i × (n+1) ÷ 2
Same example: 1,000,000 / 30y / 3.1% → first payment ≈ 5,361, last ≈ 2,785, total interest ≈ 466,000 (about 70,000 less than the fixed-payment plan, at the cost of heavier early payments).
How Rates Work (Country-Neutral)
Interest rates vary by country and product:
- Many markets quote a base rate set by the central bank; lenders add a margin on top.
- A fixed-rate loan locks the rate for the term (common in the US as a 30-year fixed); an adjustable / variable-rate loan resets periodically with the market (common in the UK, Australia, and much of Europe, often on a 25-year term).
- The APR bundles the rate with fees, so compare APRs, not headline rates.
- Your down payment size changes the principal and sometimes the rate — bigger down payment, lower risk, often better terms.
Rates move with policy and market conditions. Use the rate your lender actually quotes for your region; the formulas above are the same everywhere.
What Overpayment Really Saves
When you overpay, the remaining principal drops, and future interest is calculated on that smaller balance — so you pay less total interest and/or finish early. Because reducing-balance plans front-load principal, overpaying there bites into interest sooner; fixed-payment plans spend more on interest early, so overpaying still helps but saves a bit less in the first years. If you have spare cash and plan to clear the loan early, overpay aggressively or choose reducing-balance.
Which Should You Pick? Three Questions
- Sensitive to monthly pressure? Yes → fixed payment; no → reducing balance.
- Planning to overpay within 5–10 years? Yes → reducing balance; no → fixed payment.
- Holding to the end? Yes → reducing balance saves more interest; no → fixed payment is steadier.
The Fastest Way to Run the Numbers
🛠mortgage-calculatorUse this tool in Antpact Toolbox →
Enter the loan amount (not the home price), the current interest rate, the term, and the repayment method — it returns monthly payment, total interest, total cost, and a month-by-month breakdown.
Frequently Asked Questions
Q: My lender's app is off by a few to a few dozen — normal? Yes, usually just rounding to the cent; the formula is the same.
Q: Can I switch methods later? Often yes, sometimes for a fee — check the contract.
Q: Do rates keep changing? Variable rates reset on the review date with the market; fixed rates hold for the term.
Q: Can I combine two loan types? Yes — a "split loan" runs part fixed, part variable; enter each portion separately.
Q: Overpay to shorten term or cut the monthly? Either works; shortening the term saves more total interest.