Mortgage Calculator
Loan amount: 240.000,00 €
Monthly payment
1201,50 €
Total interest
120.448,97 €
Total paid
360.448,97 €
LTV
80.0%
Composition of total paid
Amortization schedule
First and last 12 months| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | 1201,50 € | 501,50 € | 700,00 € | 239.498,50 € |
| 2 | 1201,50 € | 502,96 € | 698,54 € | 238.995,54 € |
| 3 | 1201,50 € | 504,43 € | 697,07 € | 238.491,12 € |
| 4 | 1201,50 € | 505,90 € | 695,60 € | 237.985,22 € |
| 5 | 1201,50 € | 507,37 € | 694,12 € | 237.477,85 € |
| 6 | 1201,50 € | 508,85 € | 692,64 € | 236.968,99 € |
| 7 | 1201,50 € | 510,34 € | 691,16 € | 236.458,66 € |
| 8 | 1201,50 € | 511,83 € | 689,67 € | 235.946,83 € |
| 9 | 1201,50 € | 513,32 € | 688,18 € | 235.433,51 € |
| 10 | 1201,50 € | 514,82 € | 686,68 € | 234.918,70 € |
| 11 | 1201,50 € | 516,32 € | 685,18 € | 234.402,38 € |
| 12 | 1201,50 € | 517,82 € | 683,67 € | 233.884,56 € |
| — ... — | ||||
| 289 | 1201,50 € | 1160,23 € | 41,27 € | 12.988,07 € |
| 290 | 1201,50 € | 1163,61 € | 37,88 € | 11.824,45 € |
| 291 | 1201,50 € | 1167,01 € | 34,49 € | 10.657,44 € |
| 292 | 1201,50 € | 1170,41 € | 31,08 € | 9487,03 € |
| 293 | 1201,50 € | 1173,83 € | 27,67 € | 8313,21 € |
| 294 | 1201,50 € | 1177,25 € | 24,25 € | 7135,96 € |
| 295 | 1201,50 € | 1180,68 € | 20,81 € | 5955,27 € |
| 296 | 1201,50 € | 1184,13 € | 17,37 € | 4771,15 € |
| 297 | 1201,50 € | 1187,58 € | 13,92 € | 3583,57 € |
| 298 | 1201,50 € | 1191,04 € | 10,45 € | 2392,52 € |
| 299 | 1201,50 € | 1194,52 € | 6,98 € | 1198,00 € |
| 300 | 1201,50 € | 1198,00 € | 3,49 € | 0,00 € |
Frequently Asked Questions
Mortgage, LTV, payments and amortization
What is LTV (Loan to Value)?
LTV is the ratio between the loan and the property value. Banks generally finance up to 80% of the value (LTV 80%). Exceeding this threshold requires additional guarantees or insurance policies. With LTV > 80%, the applied interest rate is usually higher.
How is the mortgage payment calculated?
The French amortization formula is used: M = P × [r(1+r)^n] / [(1+r)^n - 1], where P is the principal, r the monthly rate (annual/12) and n the number of payments (years × 12). The payment remains constant throughout the term.
Fixed or variable rate?
A fixed rate offers certainty: the payment never changes. The variable rate (usually lower at the start) follows the Euribor and can rise or fall. In periods of high rates, fixed protects you; in periods of low and stable rates, variable is more advantageous.
How is the repayment worked out?
With the annuity method: the payment stays the same for the whole term, and what changes is its make-up, heavy on interest at the start and heavy on capital towards the end.
What does the amortisation schedule show?
For every month it lists the payment, the capital share, the interest share and the debt still outstanding. It is what shows how much of the early years goes on interest alone.
Does the calculation include the fees?
No, it works on capital, rate and term. Valuation, arrangement fees, insurance and taxes are separate costs, and they have to be added in to know what the loan really costs.