Mortgage Loans — Guide & Simulator

Discover flexible mortgage loan options tailored to help you secure your dream home with confidence and ease.

  • Instant result
  • No sign-up
  • Visible assumptions
  • Deterministic calculation

In 30 seconds: Access competitive mortgage loans designed to fit your financial needs and goals. Deterministic calculation with auditable formulas. The result is indicative — adjust the assumptions to reflect your real operation.

Methodology

Monthly rate (r) = Annual rate ÷ 12 ÷ 100

Number of payments (n) = Term in years × 12

Monthly payment = Loan × r × (1 + r)ⁿ ÷ ((1 + r)ⁿ − 1)

Total paid = Monthly payment × n

Total interest = Total paid − Loan

Debt-to-income (DTI) = Monthly payment ÷ Monthly net income

Variables

Loan amount
Principal borrowed (excluding down payment). Currency follows the active selector (USD, EUR, MXN, COP, ARS, CLP).
Annual rate
Fixed annual interest rate. Typical: 6.5% US conventional 30-yr, 3% Spain fixed, 10.5% Mexico bank.
Term
Years to pay off the loan. Common terms: 10, 15, 20, 25 or 30 years.
Monthly income
Optional. If you add it, we compute the payment-to-income (DTI) ratio banks look at when approving.

Practical example

Loan: $400,000 USD over 30 years at 6.5% fixed.

Monthly rate: 6.5 ÷ 12 ÷ 100 = 0.005417.

Number of payments: 30 × 12 = 360 months.

Monthly payment ≈ $2,528 USD.

Total paid: $2,528 × 360 = $910,000 USD.

Total interest: $910,000 − $400,000 = $510,000 USD — you pay 128% extra in interest over the principal.

Interpretation

If total interest exceeds the principal, consider shortening the term or negotiating the rate — long-term loans transfer enormous wealth to the lender.

Lenders typically reject loans where the payment exceeds 35% of monthly net income. Below 25% is comfortable.

Cutting the term from 30 to 15 years raises the payment ~30% but slashes total interest by ~60%.

Comparing two mortgages is more than comparing rates: check APR (or CAT/TAE in Latin America/Spain) which includes fees.

Assumptions and limitations

  • Fixed rate over the entire term. Adjustable-rate (ARM) or hybrid mortgages will have payments that change after the reset date.
  • Excludes origination fees, closing costs, taxes, and insurance (life, hazard) — budget those separately.
  • Excludes prepayments. Any extra payment to principal reduces total interest but is not modeled here.
  • The result is indicative. The final payment depends on the exact rate the lender approves after evaluating your profile.

When to use this calculator

  • Before visiting a lender, so you walk in with a realistic monthly payment range and don't accept the first rate offered.

  • To compare offers from multiple lenders holding loan amount and term constant — see which offer leaves less total interest.

  • When deciding between 15, 20 or 30 years. Seeing total interest per scenario typically changes the decision.

  • To validate the payment fits your income before falling in love with a property outside your real capacity.

  • To understand the effect of a larger down payment: lowering the loan amount cuts payment and interest non-linearly.

  • If you plan to make principal prepayments, simulate the shorter term (without extras) first to see if the base payment is workable.

Common mistakes

  • Looking only at the monthly payment, not total interest. A comfy 30-year payment can cost double the total of a tighter 15-year payment.

  • Forgetting closing costs: title, recording, transfer tax, origination fee, mandatory insurance. These can add 2-5% of the loan in the US, 8-12% in Mexico.

  • Not checking APR. Lenders compete on nominal rate but APR — which includes fees — can tell a different story.

  • Assuming future income will rise to justify a high payment today. Lenders assess your current situation; if income drops the payment doesn't.

  • Defaulting to the maximum term out of habit. In most cases, a 15-20 year term plus periodic prepayments comes out far better.

Industry use cases

First-time buyer (US)

$350,000 home with 20% down ($70,000). Loan of $280,000 over 30 years at 6.5% fixed: monthly payment ~$1,770. Need net income above $5,050/mo for the payment to stay at 35% DTI (lender soft cap).

Investor — rental property

$220,000 condo with 25% down. Loan of $165,000 over 15 years at 7%: payment ~$1,484/mo. If expected rent is $1,800-2,000, post-maintenance net cash flow is thin — raise down payment or shift markets.

Spain — first home

€250,000 flat with 20% deposit (€50,000). €200,000 mortgage over 25 years at 3.2% fixed: payment ~€969/mo. Real APR closer to 3.7% once tied insurance and pension plans are added.

Refinance after a rate drop

Current loan: $250,000 at 7.5% with 22 years left (payment ~$1,930). Refinance to 6.0% same term: payment falls to ~$1,710 — saves ~$58,000 in interest after closing costs.

Mexico — bank mortgage

$2.5M MXN home with 20% down. Loan of $2M MXN over 20 years at 10.5% fixed: payment ~$19,970/mo. Need ~$57,000/mo net income for the payment to stay within Infonavit/bank 35% cap.

Want to go beyond the quick calculation?

Sign up to access advanced simulators with multiple scenarios, data export, and detailed projections.

No spam. Just early access to the mortgage loans guide simulator.

Financial disclaimerIndicative result — not professional financial advice. Consult a specialist before making investment or credit decisions.

View methodology

Complete guide

Mortgage Loans 2026: Types, Rates, and How to Compare Offers in Spain and Latin America

A mortgage loan (préstamo hipotecario) is the most significant financial commitment most households will ever make. The three-way choice between fixed, variable, and mixed rate structures — combined with differences in LTV requirements, opening costs, and lender bundling policies — means that the same borrower asking three banks for the same amount and term can receive meaningfully different total costs. This guide covers the full landscape of mortgage products available in 2026 and how to systematically compare them.

The Three Core Mortgage Structures

Hipoteca Fija (Fixed-Rate Mortgage): The interest rate is locked for the entire term — typically 15-30 years. Monthly payments are predictable and immune to EURIBOR movements. In Spain 2026, fixed rates from major banks range from approximately 3.0% to 4.5% TIN depending on LTV, term, and bundled products. Fixed rates are currently close to variable rates, making the fixed option particularly attractive for long-term borrowers who prioritize certainty.

Hipoteca Variable (Variable-Rate Mortgage): The rate resets annually (occasionally semi-annually) against the 12-month EURIBOR plus a fixed spread. The spread is negotiated at origination and remains constant; only the EURIBOR component changes. With 12-month EURIBOR at approximately 2.4% in early 2026 and typical spreads of EURIBOR + 0.60-1.00%, effective rates are approximately 3.0-3.4%. If the ECB continues easing, these rates could fall further; if inflation resurges, they could rise substantially. Variable rates reward borrowers who can absorb payment volatility.

Hipoteca Mixta (Mixed-Rate Mortgage): Fixed for an initial period (typically 5-10 years) then switches to EURIBOR + spread. The fixed period's rate is usually below the pure-fixed rate and above current variable equivalent — approximately 2.8-3.5% TIN in 2026. Mixed mortgages appeal to borrowers who want initial payment certainty but are willing to assume rate risk once the loan balance is smaller.

TIN vs TAE vs CAT: Understanding the Real Cost

TIN (Tipo de Interés Nominal): The base interest rate that determines your monthly payment. It does not include fees, insurance, or other mandatory costs.

TAE (Tasa Anual Equivalente) in Spain: The all-in annualized cost. By law (Ley 5/2019), lenders must disclose TAE on all mortgage offers. It includes TIN plus: opening commission, mandatory insurance (life, home), and any other mandatory linked products. TAE is the correct metric for cross-lender comparison.

CAT (Costo Anual Total) in Mexico: Mexico's equivalent of TAE, required to be disclosed under CNBV regulations. It includes interest, origination fees, and mandatory insurance. Banks must publish CAT for their standard mortgage products.

Example: A mortgage with TIN 3.2% but mandatory life insurance costing EUR 600/year on a EUR 200,000 loan adds approximately 0.3% to the effective cost. TAE might be 3.65% — meaningfully different from the advertised 3.2%. Always compare TAE, not TIN.

Spain's Big-5 Banks: 2026 Comparison

LenderFixed (approx., max discounts)Variable SpreadLTV MaxNotable
BBVA3.0-3.5%EURIBOR + 0.60%80% primaryBBVA Valora simulator
Santander3.1-3.6%EURIBOR + 0.65%80% primaryMundo 123 bundling
CaixaBank3.0-3.8%EURIBOR + 0.75%80% primarymyMortgage digital
ING2.9-3.4%EURIBOR + 0.59%75% primaryNo opening fee; 100% online
Sabadell3.2-3.9%EURIBOR + 0.80%80% primaryRegional strength

Note: rates are indicative, with maximum bonificaciones (discounts) applied. Rates without discounts are typically 0.5-1.0pp higher.

Government-Backed Programs

Spain: FROB (Fondo de Reestructuración Ordenada Bancaria) does not directly originate mortgages, but the Spanish government offers ICO-backed (Instituto de Crédito Oficial) guarantees for young buyers (under 35) that allow up to 100% financing for qualifying properties. Demand for these ICO guarantees consistently exceeds supply.

Mexico: INFONAVIT originates approximately 60% of all residential mortgages in Mexico. Available to formal private-sector workers with active IMSS registration. 2026 fixed rate: approximately 10.45% nominal for standard loans (rate varies by salary level). FOVISSSTE serves federal government employees at comparable rates. Private bank rates in Mexico are substantially higher: 9.0-12.0% TIN.

Chile: BancoEstado offers subsidized Crédito Hipotecario products for social housing (DS49, DS1). Standard private bank mortgages reference the UF (Unidad de Fomento, Chile's inflation-indexed unit): typical terms are UF + 4.0-5.5% annually.

Down Payment Requirements by Jurisdiction

CountryStandard Down PaymentMaximum LTVNotes
Spain20-30%80% primary / 70% second homePlus 10-12% closing costs
Mexico (INFONAVIT)5-10%90-95%Subaccount balance reduces down payment
Mexico (private banks)10-20%80-90%
Chile10-20%80-90%UF-indexed loans
Colombia20-30%70-80%

Worked Example: EUR 200,000 Mortgage Across 3 Spanish Lenders

Borrower: EUR 200,000 loan, 25-year term, primary residence, payroll domiciliation and insurance bundled.

LenderTINMonthly PaymentTotal Interest (25y)Total Cost
ING (3.2% TIN)3.2%EUR 966EUR 89,800EUR 289,800
BBVA (3.4% TIN)3.4%EUR 988EUR 96,400EUR 296,400
Sabadell (3.8% TIN)3.8%EUR 1,033EUR 109,900EUR 309,900

Difference between cheapest and most expensive: EUR 20,100 in total interest — 10% of the original principal — from a 0.6% rate difference over 25 years.

Early Repayment Rights (Spain)

Under Ley 5/2019, early repayment penalties are capped:

  • Fixed-rate mortgages: 2% of repaid capital in the first 10 years; 1.5% from year 11 onward.
  • Variable-rate mortgages: 0.25% in the first 3 years; 0% thereafter.

Partial early repayment (amortización parcial) reduces the outstanding balance and can be structured to either reduce the monthly payment or shorten the remaining term — most borrowers prefer shortening the term to reduce total interest paid.

Subrogation: Switching Lenders Mid-Mortgage

A subrogación allows you to transfer an existing mortgage to a new lender without going through a full application process. The new lender pays off the old lender and assumes the mortgage. Since Ley 5/2019, the old lender cannot charge the full notary and registry costs for a subrogation — only the early repayment fee applies. This has made switching lenders mid-mortgage more accessible and has improved competition.

Alternatives to Conventional Mortgage Loans

Leasing inmobiliario (real estate leasing): The property is owned by a leasing company, and the buyer makes monthly payments that combine use fee and purchase option premium. At lease end, the buyer exercises an option to acquire at a residual value. Used mainly by businesses (where lease payments are tax-deductible) rather than individual homebuyers.

Rent-to-buy (alquiler con opción a compra): The tenant pays rent with a portion applied toward a future purchase price. Useful for buyers who need time to save the down payment or improve credit, but at risk of losing accumulated payments if they cannot close. Contract terms vary widely; always verify how the accumulated amount is treated if the purchase option is not exercised.

Second mortgage (segunda hipoteca): A second lien on a property that already carries a first mortgage. Second mortgages carry higher rates because the second-lien holder has subordinate priority in foreclosure. Typically used for home equity extraction, not primary purchase.

How to Use the Monthly Payment Calculator

Enter: loan principal, annual TIN, and term in years. The calculator applies the French amortization formula to output: monthly installment, total amount paid over the full term, total interest, and a simplified amortization schedule showing the principal-vs-interest split at key intervals (year 1, 5, 10, midpoint, last year). Use three TIN scenarios simultaneously — current rate, +1%, +2% — to see how payment changes under rate stress.

From theory to calculation

The calculator on this page runs with your numbers — no forms, no login. Scroll up and try it.

Try the calculator

Frequently asked questions

1What is a préstamo hipotecario?
A préstamo hipotecario is a mortgage loan used to buy or refinance real estate. It involves borrowing money secured by the property, which the borrower repays over time with interest.
2What are the main types of préstamos hipotecarios?
The main types include fixed-rate mortgages, variable or adjustable-rate mortgages, and interest-only loans. Each type varies in interest rates, payment stability, and terms to fit different financial situations.
3What are the common requirements for a préstamo hipotecario?
Typical requirements include proof of income, a good credit score, a down payment, valid identification, and documentation of the property to be mortgaged. Lenders may also assess debt-to-income ratio.
4How is the interest rate determined for a préstamo hipotecario?
Interest rates depend on factors such as credit score, loan amount, term length, and market conditions. Fixed-rate loans offer constant rates, while variable rates can change based on economic indexes.
5Can I prepay or refinance my préstamo hipotecario?
Yes, many lenders allow prepayment or refinancing, which can save money by reducing interest costs or adjusting loan terms. However, some loans may have penalties or fees for early repayment.

Last updated: April 30, 2026 · Reviewed by the Simúlalo editorial team. Figures and benchmarks are indicative; verify with your own data before deciding.

View methodology