Mortgage Loan — Practical Guide with Calculator

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

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

In 30 seconds: Access competitive mortgage loans designed to fit your financial needs and homeownership 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 loan guide simulator.

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

View methodology

Complete guide

Mortgage Loan (Crédito Hipotecario): Types, Requirements, and Monthly Payment Calculator

A mortgage loan — called crédito hipotecario in Mexico and most of Latin America, or préstamo hipotecario in Spain — is a long-term secured loan whose collateral is the property being purchased. The lender holds a lien on the property (hipoteca) until the debt is fully repaid; if the borrower defaults, the lender can foreclose and sell the asset to recover its claim. Understanding the different products, the real cost drivers, and the application process before signing protects you from the most common and expensive mistakes in personal finance.

Types of Mortgage Loan

Fixed-Rate Mortgage (Hipoteca Fija)

The nominal interest rate stays constant for the entire term — typically 15 to 30 years. Monthly payments never change. In Spain, fixed rates as of April 2026 range from approximately 3.05% (ING, Openbank with linked products) to 4.00% TIN for standard profiles. In Mexico, fixed-rate bank mortgages range from 9.5% to 12.5% nominal. This product suits borrowers who prioritize payment certainty and plan to hold the property long term.

Variable-Rate Mortgage (Hipoteca Variable)

The rate adjusts periodically — typically annually in Spain — based on a reference index plus a spread. In Spain, the dominant index is the 12-month EURIBOR (2.45% as of April 2026). A mortgage at EURIBOR + 0.90% currently implies a nominal rate of approximately 3.35%, cheaper than most fixed offers. The risk: when EURIBOR rises, so does your payment. EURIBOR peaked at 4.16% in October 2023, raising monthly payments on variable mortgages by EUR 200–300 on a EUR 200,000 / 25-year loan relative to 2021 levels.

Mixed-Rate Mortgage (Hipoteca Mixta)

Fixed for an initial period (typically 3 to 10 years), then variable for the remainder. Suitable for borrowers who want short-term payment certainty but are willing to accept rate variability later, or who plan to make significant principal repayments during the fixed phase.

Government-Backed Programs

  • Mexico — INFONAVIT: Workers in the formal private sector accumulate a housing sub-account (5% of salary, paid by employer). This balance can serve as down payment and, for qualifying workers, covers part or all of the mortgage. INFONAVIT rate: 10.45% nominal annual (2026). Maximum loan: varies by worker salary and credit score.
  • Mexico — FOVISSSTE: Equivalent program for government employees. Joint INFONAVIT-FOVISSSTE credits allow married couples where one partner works in the private sector and the other in government to combine both balances.
  • Spain — ICO / Línea ICO Joven Aval: State guarantee program for buyers under 35 purchasing their first primary residence, allowing LTV up to 95% at participating banks (Bankinter, CaixaBank, BBVA). The state covers the risk of the 15-pp LTV gap between 80% and 95%.

How Mortgage Costs Are Measured: CAT vs TAE

Mexico — CAT (Costo Anual Total): Required disclosure by Banxico. Includes the nominal rate plus all mandatory costs — opening commission, life insurance, home insurance, any credit life insurance, and notarial fees if the bank controls them. Typical CAT for mortgage loans in Mexico: 13%–18%. Always compare CAT across banks, not just the nominal rate.

Spain — TAE (Tasa Anual Equivalente): Required by Banco de España under Directive 2014/17/EU. Includes TIN (nominal rate), origination fee, and all mandatory linked products. The FEIN (European Standardized Information Sheet) discloses the TAE and must be delivered at least 10 business days before signing. Best TAE in Spain (April 2026): ~3.31% from ING.

Eligibility Requirements by Market

Spain: Stable income (permanent employment contract or 2+ years of self-employment with filed IRPF), debt-to-income ratio below 30–35% of net monthly income, clean credit history (no CIRBE/ASNEF defaults), LTV at or below 80% (for standard programs), minimum income of EUR 1,800–EUR 2,500/month depending on the loan amount, NIE/DNI.

Mexico: RFC, formal employment or verifiable self-employment income (últimos 3 recibos de nómina + 2 years of SAT tax declarations), Buró de Crédito score (minimum varies by bank; BBVA México requires at least "Regular", HSBC requires "Bueno"), enganche from own documented funds (10–20% of property value), property appraisal (avalúo) ordered and paid by the bank.

The Application Process: What to Expect

StageWhat happensTypical time
Pre-qualificationBank reviews income and Buró/CIRBE; issues indicative offer2–5 business days
Property appraisalCertified appraiser values the property; bank reviews LTV7–14 business days
Credit committeeBank formally approves the amount, rate, and conditions5–10 business days
FEIN / binding offerSpain: legally binding pre-contract document, 10-day cooling period10 days mandatory
Notary signingMortgage deed executed; public deed registered1–3 business days
Total typical timeline4–8 weeks

In Mexico, registration at the Registro Público de la Propiedad follows signing and typically takes 10–20 additional business days depending on the state.

Worked Example: Monthly Payment Calculation

Spain, fixed rate: EUR 200,000 at 3.50% TIN / 25 years.

  • Monthly rate r = 3.50% ÷ 12 = 0.002917
  • n = 300 months
  • M = 200,000 × [0.002917 × (1.002917)^300] / [(1.002917)^300 − 1] ≈ EUR 1,001/month
  • Total interest paid over 25 years: EUR 100,300 (50% of the original principal)

Mexico, fixed rate: MXN 1,500,000 at 11.0% nominal / 20 years.

  • Monthly rate r = 11.0% ÷ 12 = 0.009167
  • n = 240 months
  • M ≈ MXN 15,490/month
  • Total interest paid over 20 years: MXN 2,217,600 − MXN 1,500,000 = MXN 717,600

Red Flags to Watch For

Floor clauses (cláusula suelo): Minimum rate floors in variable mortgages were ruled abusive by Spain’s Supreme Court and the TJUE in 2016. If you are refinancing a mortgage signed before 2015, verify whether it contained one and whether you are entitled to restitution of overpaid interest.

Forced insurance cross-selling: Banks may offer a lower TIN in exchange for subscribing to their home insurance and life insurance at non-market premiums. Calculate the true net cost: annual interest saving versus annual insurance premium differential compared with the open market. Under Ley 5/2019 in Spain, these cannot be legally required, but the discounted rate depends on them.

Early repayment penalties: In Spain: maximum 2% in the first 10 years and 1.5% thereafter for fixed-rate mortgages (Ley 5/2019). In Mexico: penalties must be disclosed in the contract and in the CAT; they vary by bank but Banxico enforces disclosure.

Notary and registration costs (gastos de formalización): In Spain these are now paid by the bank under Ley 5/2019 — you do not pay AJD (stamp duty) or notary fees for the mortgage deed. You do pay for the sale contract notarization and Land Registry inscription. In Mexico, both escritura fees and ISAI (Impuesto Sobre Adquisición de Inmuebles, 2–4% depending on the state) are paid by the buyer.

How to Use the Simúlalo Mortgage Calculator

Enter the loan amount, annual nominal rate, and term in years. The calculator outputs the monthly installment and the full amortization table. Use it to:

  1. Compare fixed vs. variable scenarios: Enter the fixed rate and the current EURIBOR + spread for variable, and see when the cumulative interest paid crosses over.
  2. Calculate your LTV: Enter the bank’s appraised value and your desired loan to see whether you stay below the 80% threshold.
  3. Run prepayment scenarios: See how one extra payment per year reduces total interest and shortens the loan term — typically by 3–5 years on a 25-year mortgage.

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 Crédito Hipotecario?
A Crédito Hipotecario is a mortgage loan used to purchase or refinance real estate. It involves borrowing money secured by the property, which serves as collateral until the loan is fully repaid.
2What types of Crédito Hipotecario are available?
Common types include fixed-rate, variable-rate, and mixed-rate mortgages. Each varies in interest rate structure and payment flexibility to suit different financial situations and market conditions.
3What are the basic requirements for obtaining a Crédito Hipotecario?
Requirements typically include proof of income, good credit history, a valid ID, property appraisal, and a down payment. Lenders may also request employment verification and debt-to-income ratio analysis.
4How is the interest rate determined on a Crédito Hipotecario?
Interest rates depend on credit score, loan amount, term length, and market conditions. Fixed rates stay constant, while variable rates fluctuate based on economic indicators like the prime rate.
5Can I use a Crédito Hipotecario for refinancing?
Yes, a Crédito Hipotecario can be used to refinance existing mortgages. This may help secure better interest rates, reduce monthly payments, or access home equity for other needs.

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