Complete mortgage guide: types, rates, amortization, and the numbers that matter
A mortgage is the largest financial commitment most households take on. It is also one of the most opaque: banks present a TIN and a TAE, the notary reads a deed at speed, and the borrower leaves with a 20-30 year obligation they may not fully understand. This guide covers the mechanics, the formulas, and the 2026 rate environment for Spain and Mexico — the two markets where our simulator has the deepest local context.
The three mortgage types and when each makes sense
Fixed-rate mortgage (hipoteca fija)
The interest rate is locked for the entire term. Your monthly installment is the same in year 1 and year 23. In Spain (2026), fixed rates from the major banks sit at 3.2-4.0% nominal (TAE 3.5-4.3%). In Mexico, banks like BBVA, Santander, and Banorte offer fixed rates at 9.5-12.5% for peso loans.
Best for: borrowers who value payment certainty over the life of the loan, those with fixed incomes (public employees, salaried workers), or anyone who believes rates will rise from their current level.
Variable-rate mortgage (hipoteca variable)
In Spain, variable mortgages are indexed to 12-month EURIBOR (April 2026: 2.45%) plus a fixed spread (typically EURIBOR + 0.60-1.20%). Your installment resets annually when the EURIBOR reference is updated. When EURIBOR rises sharply (as it did from -0.5% in 2022 to a peak of 4.2% in late 2023), variable mortgage holders saw installments rise 30-50%.
Best for: borrowers who expect rates to fall over the loan horizon, those with short planned holding periods (plan to sell within 5-7 years), or those with financial flexibility to absorb payment variability.
Mixed mortgage (hipoteca mixta)
Fixed rate for an initial period (typically 3-10 years), then switches to EURIBOR + spread for the remainder. CaixaBank and ING offer popular 5- and 10-year fixed windows in Spain. It suits buyers who want short-term certainty but accept longer-term variability — typically when they expect income growth or plan early partial prepayment.
French amortization: the formula behind every monthly payment
Spanish and Mexican mortgages use French amortization (cuota constante): the monthly installment is constant, but its composition shifts over time. Early installments are mostly interest; later ones are mostly principal repayment.
Monthly installment formula:
C = P × [r(1+r)^n] / [(1+r)^n - 1]
Where: C = monthly installment, P = principal (loan amount), r = monthly interest rate (annual rate / 12), n = number of monthly payments (years × 12).
Worked example — Spain:
- Loan: EUR 200,000
- Term: 25 years (n = 300)
- Rate: 3.5% fixed (r = 0.003517/month)
- Monthly installment: EUR 1,001
- Total paid over 25 years: EUR 300,300
- Total interest: EUR 100,300 (50.2% of principal)
Worked example — Mexico:
- Loan: MXN 2,000,000
- Term: 20 years (n = 240)
- Rate: 10.5% fixed (r = 0.00875/month)
- Monthly installment: MXN 19,952
- Total paid over 20 years: MXN 4,788,480
- Total interest: MXN 2,788,480 (139% of principal)
The Mexican example underscores why mortgage calculators matter — many buyers see only the monthly payment and miss the total cost picture.
Down payment and transaction costs
Spain
Banks lend up to 80% of the appraised value (LTV 80%). Effective minimum down payment: 20% of purchase price + transaction costs of 10-12%:
- ITP (property transfer tax on resale): 6-10% depending on Autonomous Community (Madrid 6%, Catalonia 10%, Andalucía 7%).
- IVA (VAT) on new builds: 10%.
- Notary + Land Registry + appraisal: 1-2%.
For a EUR 300,000 home: down payment EUR 60,000 + EUR 33,000-36,000 transaction costs = minimum liquid capital needed: EUR 93,000-96,000.
Mexico
Banks finance 70-90% of the property value (typically 80%). Standard transaction costs include:
- Notary fees: 1.5-3% of property value (vary by state).
- ISAI (Impuesto Sobre Adquisición de Inmuebles): 2-5% depending on state.
- Appraisal: MXN 3,000-8,000.
- Bank origination fee (comisión de apertura): 0.5-2% of loan amount.
INFONAVIT subscribers can apply their housing sub-account balance as enganche (down payment), reducing or eliminating the cash requirement for qualifying properties.
The document checklist
Spain (standard bank list):
DNI/NIE + passport, last 3 payslips or 2-year tax return (IRPF) for self-employed, CIRBE credit report (bank obtains it), most recent 6 months of bank statements, nota simple of the property, appraisal report (tasación, ordered by the bank).
Under Ley 5/2019, the bank must provide the FEIN (Ficha Europea de Información Normalizada) at least 10 business days before signing — this is the binding offer you compare across lenders. Before notary signing, both borrower and lender must attend a preliminary notary consultation (acta de transparencia).
Mexico (major bank list):
Official ID + CURP + RFC, payslips (last 3 months) or income verification letter (constancia de ingresos), bank statements (last 6 months), proof of address, employment letter, credit bureau authorization. For INFONAVIT co-financing: CESI (Carta de Elegibilidad de Subrogación de INFONAVIT) and employer registration with IMSS.
Refinancing: subrogación vs novación
Subrogación (Spain): transferring the mortgage to a new lender. The new bank pays off the original bank and sets new terms. Key cost: early-repayment penalty (comisión de amortización anticipada) capped by Ley 5/2019 at 0.25% in years 1-3 and 0.15% in years 4-5 for variable mortgages; 2% in years 1-10 for fixed, 1.5% after that.
Novación: modifying the existing mortgage with the same lender (rate, term, or amount). Usually lower cost than subrogación but subject to lender willingness.
Rule of thumb: refinancing makes sense when the rate reduction × remaining balance × remaining years exceeds the total switching costs.
Renting vs buying: the 200× price-to-rent rule
A practical heuristic: if the purchase price / annual gross rent > 200, renting is likely cheaper from a pure cash-flow perspective. In Madrid city center in 2026, average apartment prices run EUR 5,000-7,000/m², while rents run EUR 22-28/m²/month. For a 70 m² apartment: price ~EUR 420,000, annual rent ~EUR 22,176. Ratio = 420,000 / 22,176 = 18.9 (under 200×, purchase is relatively competitive). In tourist coastal areas (Costa del Sol, Canarias), ratios often exceed 25×, tilting toward renting or investment logic.
Common mistakes when taking a mortgage
- Comparing only TIN, not TAE. TIN is the nominal rate; TAE includes all costs (origination fee, insurance bundled by the bank) and is the only valid basis for comparison between offers.
- Taking the first offer. Comparing 3 banks plus a mortgage broker typically saves EUR 15,000-40,000 over 25 years on a EUR 200,000 loan.
- Underestimating transaction costs. First-time buyers in Spain routinely underestimate the ITP bill and find themselves short at signing.
- Signing at variable without modeling EURIBOR scenarios. Running the payment at EURIBOR + 2% (a historically plausible scenario) gives the stress-test version of affordability.
- Not reading the amortization schedule. Understanding that 70% of the first 10 years of payments is interest (not principal) changes the calculus on early partial prepayment.
Refinancing decision framework 2026
Refinancing (subrogación in Spain) makes financial sense when two conditions are met simultaneously: the rate drop is at least 0.75 percentage points, and the remaining loan term is at least 10 years. Below either threshold, the closing costs typically exceed the present value of monthly savings.
Worked example: Existing loan EUR 180,000, remaining term 18 years, current rate 4.1%, new offer 3.2%. Monthly saving: old installment EUR 1,152 vs new EUR 1,047 = EUR 105/month. Total switching costs (early-repayment penalty 0.25% on variable, appraisal, notary, registry): approximately EUR 3,200. Breakeven = 3,200 ÷ 105 = 30.5 months. At 18 years remaining, the breakeven is reached in month 31 — the switch clearly pays. If the remaining term were only 6 years, total savings would be EUR 7,560 against EUR 3,200 of costs — still positive, but much tighter, and rate risk over a short horizon changes the calculus.