Mortgage calculator - Equated Monthly Installment
This calculator allows you to simulate your mortgage payments. You can adjust the house price, down payment, interest rate, and the number of years you plan to have your mortgage for. The simulation will show you the monthly payment, total interest paid, and the mortgage table. The formulas used are based on the EMI formula.
The important takeaways are that the monthly payment is fixed, but the interest paid decreases over time while the principal paid increases.
House price
€245,000.00
Simulate years
15
Down payment
€125,000.00
Rate
2.50%
| Monthly payment | Total interest paid |
|---|---|
€800.15 | €24,026.47 |
Mortgage table
| Year | Yearly payment | Interest | Principal repayment | Remaining | Remaining interest | x |
|---|---|---|---|---|---|---|
| 1 | €9,601.76 | €2,923.83 | €6,677.94 | €113,322.06 | €21,102.64 | 0.18621830300076433 |
| 2 | €9,601.76 | €2,754.95 | €6,846.81 | €106,475.25 | €18,347.69 | 0.1723188242003465 |
| 3 | €9,601.76 | €2,581.81 | €7,019.96 | €99,455.29 | €15,765.88 | 0.15852231268617945 |
| 4 | €9,601.76 | €2,404.28 | €7,197.48 | €92,257.81 | €13,361.60 | 0.14482892883283907 |
| 5 | €9,601.76 | €2,222.27 | €7,379.49 | €84,878.32 | €11,139.33 | 0.13123882044758498 |
| 6 | €9,601.76 | €2,035.65 | €7,566.11 | €77,312.21 | €9,103.68 | 0.11775212270513895 |
| 7 | €9,601.76 | €1,844.32 | €7,757.45 | €69,554.76 | €7,259.36 | 0.1043689580879442 |
| 8 | €9,601.76 | €1,648.14 | €7,953.62 | €61,601.14 | €5,611.21 | 0.09108943633195632 |
| 9 | €9,601.76 | €1,447.01 | €8,154.75 | €53,446.38 | €4,164.20 | 0.07791365437801322 |
| 10 | €9,601.76 | €1,240.79 | €8,360.98 | €45,085.41 | €2,923.41 | 0.0648416963288263 |
| 11 | €9,601.76 | €1,029.35 | €8,572.41 | €36,513.00 | €1,894.06 | 0.051873633411630184 |
| 12 | €9,601.76 | €812.57 | €8,789.20 | €27,723.80 | €1,081.49 | 0.039009523946523184 |
| 13 | €9,601.76 | €590.30 | €9,011.46 | €18,712.34 | €491.19 | 0.026249413320526535 |
| 14 | €9,601.76 | €362.42 | €9,239.35 | €9,473.00 | €128.77 | 0.013593333967384378 |
| 15 | €9,601.76 | €128.77 | €9,473.00 | €0.00 | -€0.00 | -0.000230206233032213 |