A mortgage calculator for buying in Spain
Use this tool when you have a purchase budget or a mortgage illustration and want to understand the cash commitment. It separates the loan repayment from money needed at purchase, so a modest monthly payment is not mistaken for a small initial outlay. Start with one scenario; add a second to isolate a different loan amount, rate, term or fee budget. All entries refer to the same property price.
Enter the purchase price, your own budget for taxes and purchase fees, and any reserve you want to keep. Enter the amount borrowed, annual nominal interest rate (TIN), term and borrower-paid loan costs. Add a second scenario to compare. Amounts and rates shown in the form are examples, not current bank offers.
Upfront cash: more than the down payment
Enter the total purchase tax amount applicable to your transaction, not a universal percentage. Purchase fees can include your conveyancing, purchase deed, ownership registration and agreed professional fees. Separate purchase costs from costs of the mortgage deed. A reserve is cash kept aside, not a fee. Avoid double counting.
Borrowing is limited here to the purchase price for a clear purchase budget; this is not a bank lending limit. Enter agreed borrower-paid loan fees as a euro total, separately from appraisal and purchase fees. No automatic loan-to-value limit is assigned by nationality or residence.
TIN, TAE and changing interest rates
The nominal annual rate is divided by twelve. It stays constant for the whole simulated term. Use TIN, not TAE/APR. Fees and insurance can affect TAE. For variable or mixed loans, compare constant-rate scenarios as sensitivities; this does not forecast Euribor or future resets.
Comparing resident and non-resident scenarios
Borrowing terms for buyers abroad depend on the actual lender and transaction. The calculator therefore asks for the amount and rate directly rather than promising a financing percentage. Being a foreign citizen is not the same as being a Spanish tax non-resident. Check the lender’s requirements for income evidence, currency, appraisal and documentation. Use the tax-residence tool separately; it does not determine mortgage approval.
How the payment and amortisation work
For principal P, monthly rate r = TIN / 1200 and n monthly payments, the regular payment is P × r / (1 − (1 + r)^−n). At zero interest it is P / n. Each month, interest is charged on the outstanding balance and the rest repays principal. The model rounds to cents monthly and clears the remaining principal in the final scheduled payment. The annual table shows payments, interest, principal and closing balance; yearly payments equal interest plus principal.
The estimate assumes equal monthly periods and French-system amortisation, with unchanged TIN and no repayment holiday or early repayment. Interest and payments are rounded to cents monthly; the last payment clears the balance and may differ from the regular payment. Totals sum actual modelled payments. Recurring insurance, bundled products and other charges are excluded unless explicitly entered as upfront costs. TAE and bank approval are not calculated.
A reproducible example and next steps
Illustration: a €200,000 purchase with a €160,000 loan at 3% TIN for 25 years gives a regular monthly payment of €758.74. The modelled final payment is €757.90 and total interest is €67,621.16 under monthly cent rounding. These input terms are illustrative, not a current bank offer.
With the same purchase, a hypothetical €20,000 checked purchase-tax budget, €2,000 other purchase fees, €500 appraisal, no loan fee and a €5,000 reserve, upfront cash is €67,500: €40,000 down payment plus those four amounts. The €20,000 is an example chosen for arithmetic, not a Spanish tax rate or assessment. Replace it with the amount applicable to your property and region.
Negative means the entered value is lower in B. A lower monthly payment does not necessarily mean lower total interest. Compare terms, loan amounts and costs together; no offer is ranked as suitable for you.
Common questions
Can I use this mortgage calculator as a non-resident?
Yes. Enter the terms actually available to you. The calculator does not assign an automatic non-resident loan limit or decide whether a bank will lend.
Should I enter TIN or TAE?
Enter annual nominal TIN. TAE includes a wider cost measure and cannot be used as the nominal rate in the monthly payment formula.
Does it calculate Spanish purchase taxes?
No. Enter a checked euro amount. New versus resale property, region, taxable base and reliefs can change the tax. Zero is accepted only as your deliberate input.
Does a variable-rate mortgage keep this payment?
Only while the modelled rate remains unchanged. Different constant-rate scenarios can show sensitivity but do not predict Euribor or contractual resets.
Why is the final payment different?
Monthly cent rounding can leave a small balance difference. The final scheduled payment clears that balance instead of multiplying the regular payment by the full term.
Is the displayed cash reserve spent?
No. It is money you choose to retain. It increases the cash you need available but is not included in the interest-and-loan-cost measure.
Sources and next steps
Official references
- Banco de España — Simulador de préstamo hipotecario
- Banco de España — Cálculo de la TAE
- Banco de España — Gastos de hipoteca y compraventa
- Related calculator: Spain Property Investment Calculator
- Related calculator: Spain Property Purchase Costs Calculator — Taxes & Fees
- Related calculator: Spain Non-Resident Property Tax Calculator — IRNR / Modelo 210
- Related calculator: Spain Cost of Living Calculator 2026 — Compare Cities
- Related calculator: Spain Tax Residency Calculator: 183-Day Rule & Tax Status
- Keep planning in My Account