Finance
Back to home

Advanced Mortgage Simulator

Calculate your monthly mortgage payment, total interest and get your full amortisation schedule.

A mortgage is the most important long-term loan most families will ever take out. The advanced simulator lets you calculate the exact monthly payment, total interest paid and visualise the full amortisation schedule, month by month. The French amortisation system, the most common in Spain, keeps the monthly payment constant throughout the loan although the split between principal and interest changes each month.

The calculator distinguishes between fixed and variable rate mortgages. For variable mortgages, the calculation assumes a constant interest rate (the one you enter) to project the payments, although in practice the Euribor changes at each annual review. This lets you make a realistic estimate and compare different scenarios before signing with the bank.

Loan Details
150.000
10.000 €1.000.000 €
3.5 %
0 %15 %
25 yr
140

Monthly Payment

750,94 €

Total Interest

75.280,61 €

Total to Pay

225.280,61 €

Outstanding Capital Evolution
Amortisation Schedule
MonthPaymentPrincipalInterestBalance
1750,94 €313,44 €437,50 €149.686,56 €
2750,94 €314,35 €436,59 €149.372,22 €
3750,94 €315,27 €435,67 €149.056,95 €
4750,94 €316,19 €434,75 €148.740,76 €
5750,94 €317,11 €433,83 €148.423,65 €
6750,94 €318,03 €432,90 €148.105,62 €
7750,94 €318,96 €431,97 €147.786,66 €
8750,94 €319,89 €431,04 €147.466,77 €
9750,94 €320,82 €430,11 €147.145,95 €
10750,94 €321,76 €429,18 €146.824,19 €
11750,94 €322,70 €428,24 €146.501,49 €
12750,94 €323,64 €427,30 €146.177,85 €

Results are indicative. Always consult the FEIN and FIAE documents your bank provides before signing any mortgage.

How the French amortisation system works

This is the method used by practically all mortgages in Spain and is characterised by a constant monthly payment throughout the life of the loan. What varies month to month is its internal composition. Each month the interest is calculated first by applying the monthly rate to the outstanding capital; the rest of the payment goes towards repaying principal. Since the outstanding capital falls with each payment, the following month's interest is lower and the portion repaying principal rises. The result is that at the start of the loan you pay mostly interest and very little capital, while in the final years the opposite happens. That is why early repayment is far more profitable in the first years.

Worked example

For a €200,000 mortgage at 3% over 30 years, the monthly payment is about €843. On the first instalment, interest is 200,000 × 0.03 / 12 = €500, so only €343 repays capital. Ten years later, with outstanding capital near €152,000, the month's interest falls to about €380 and repayment rises to €463. In the mortgage's final year, virtually the entire payment goes to capital. Over the thirty years you will have paid roughly €103,500 in interest alone.

Payment and interest by term (€200,000 at 3%)

TermMonthly paymentTotal interest
15 years1.381 €48.598 €
20 years1.109 €66.208 €
25 years948 €84.520 €
30 years843 €103.552 €
35 years770 €123.274 €
40 years716 €143.632 €

How to read the amortisation schedule

The schedule lets you see exactly how much you owe at any point, which is essential if you are considering early repayment or selling the property before paying it off. Pay particular attention to the outstanding capital column: many people are surprised to find that after ten years of payments they still owe more than 75% of the original loan. Compare the total interest across different terms too: extending from twenty to thirty years reduces the payment by about €266 a month but makes the loan more than €37,000 more expensive. As a practical rule, choose the shortest term your budget can comfortably bear, and remember you can always repay early if your situation improves.

Frequently Asked Questions about Mortgages

It is the most widely used system in Spain. It keeps a constant monthly payment throughout the loan (if the interest rate does not change). At the beginning you pay more interest and less capital, and at the end of the loan the opposite occurs.

It depends on your risk profile. The fixed rate gives you certainty of always paying the same amount, although it usually has a higher initial interest rate. The variable rate (linked to Euribor) may be cheaper initially but you take on the risk that the payment rises if interest rates increase.

In addition to the principal, you must account for purchase costs (notary, land registry, taxes such as ITP or VAT) which typically range between 10% and 12% of the property value. There are also valuation fees and possible mortgage arrangement fees.

The benchmark banks apply is that the monthly payment should not exceed 30-35% of your net income, including any other debt you have. On a net income of €2,500 a month, that means a maximum payment of around €875, which at 3% over thirty years allows a mortgage of about €207,000. On top of that capacity, lenders normally finance 80% of the appraised value, so you will need to contribute the remaining 20% plus the transaction costs. Length of employment, type of contract and the availability of guarantors also influence the final decision.

The Euribor is the average interest rate at which major European banks lend to each other, and it serves as the reference index for most variable-rate mortgages in Spain. On a variable mortgage, your rate is calculated by adding the current Euribor to a fixed spread agreed in the deed, for example Euribor + 0.9%. The review is normally done every six or twelve months, at which point the payment is recalculated with the new index value. That is why a variable mortgage can become considerably more expensive if the Euribor rises: a one-point increase on €200,000 over thirty years adds around €110 to the monthly payment.

Other Finance calculators