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.
Monthly Payment
750,94 €
Total Interest
75.280,61 €
Total to Pay
225.280,61 €
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | 750,94 € | 313,44 € | 437,50 € | 149.686,56 € |
| 2 | 750,94 € | 314,35 € | 436,59 € | 149.372,22 € |
| 3 | 750,94 € | 315,27 € | 435,67 € | 149.056,95 € |
| 4 | 750,94 € | 316,19 € | 434,75 € | 148.740,76 € |
| 5 | 750,94 € | 317,11 € | 433,83 € | 148.423,65 € |
| 6 | 750,94 € | 318,03 € | 432,90 € | 148.105,62 € |
| 7 | 750,94 € | 318,96 € | 431,97 € | 147.786,66 € |
| 8 | 750,94 € | 319,89 € | 431,04 € | 147.466,77 € |
| 9 | 750,94 € | 320,82 € | 430,11 € | 147.145,95 € |
| 10 | 750,94 € | 321,76 € | 429,18 € | 146.824,19 € |
| 11 | 750,94 € | 322,70 € | 428,24 € | 146.501,49 € |
| 12 | 750,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%)
| Term | Monthly payment | Total interest |
|---|---|---|
| 15 years | 1.381 € | 48.598 € |
| 20 years | 1.109 € | 66.208 € |
| 25 years | 948 € | 84.520 € |
| 30 years | 843 € | 103.552 € |
| 35 years | 770 € | 123.274 € |
| 40 years | 716 € | 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.