Mortgage calculator
Calculate the monthly payment, interest and insurance costs of a mortgage loan, with a year-by-year amortization schedule.
Your settings
Results update with each entry.
Loan interest rate excluding insurance, as stated in the loan offer.
Annual rate applied to the borrowed amount (insurance constant over the full term).
- Monthly payment, insurance included
- €1,499.59
- Including €1,437.09 of credit and €62.50 of insurance, over 20 years.
- Interest cost
- €94,901
- Insurance cost
- €15,000
- Total cost of credit
- €109,901
- Indicative APRC
- 3.95%
- Approximation, excluding arrangement and guarantee fees
Outstanding principal
At year-end, after the year's payments.
Amortization schedule
Annual summary. Expand a year to see the details of each monthly payment.
| Period | Monthly payments | Interest | Principal repaid | Insurance | Outstanding principal |
|---|---|---|---|---|---|
| €17,245 | €8,362 | €8,883 | €750 | €241,117 | |
| €17,245 | €8,056 | €9,189 | €750 | €231,928 | |
| €17,245 | €7,738 | €9,507 | €750 | €222,421 | |
| €17,245 | €7,410 | €9,835 | €750 | €212,586 | |
| €17,245 | €7,070 | €10,175 | €750 | €202,412 | |
| €17,245 | €6,719 | €10,526 | €750 | €191,886 | |
| €17,245 | €6,355 | €10,890 | €750 | €180,996 | |
| €17,245 | €5,979 | €11,266 | €750 | €169,730 | |
| €17,245 | €5,590 | €11,655 | €750 | €158,076 | |
| €17,245 | €5,188 | €12,057 | €750 | €146,018 | |
| €17,245 | €4,771 | €12,474 | €750 | €133,545 | |
| €17,245 | €4,341 | €12,904 | €750 | €120,640 | |
| €17,245 | €3,895 | €13,350 | €750 | €107,290 | |
| €17,245 | €3,434 | €13,811 | €750 | €93,479 | |
| €17,245 | €2,957 | €14,288 | €750 | €79,191 | |
| €17,245 | €2,464 | €14,781 | €750 | €64,410 | |
| €17,245 | €1,953 | €15,292 | €750 | €49,118 | |
| €17,245 | €1,425 | €15,820 | €750 | €33,298 | |
| €17,245 | €879 | €16,366 | €750 | €16,932 | |
| €17,245 | €313 | €16,932 | €750 | €0 |
How this calculation is made
The simulator calculates an amortizing loan with constant monthly payments. With borrowed principal P, a monthly rate i (annual nominal rate divided by 12) and n monthly payments, the monthly payment excluding insurance equals:
M = P × i / (1 − (1 + i)^−n)
Each month, interest is calculated on the outstanding principal; the rest of the payment repays principal. Early payments therefore contain more interest than later ones.
- Insurance is calculated on the initial capital and remains constant: P × insurance rate / 12 per month. Some contracts calculate it on the outstanding balance.
- The total cost of credit adds up interest and insurance.
- The indicative APR is the annual percentage rate that equates the capital received with the monthly payments made, insurance included. It excludes arrangement, guarantee and brokerage fees: the APR in your loan offer will be higher.
The results are simulations based on the stated assumptions. They do not predict future results and do not take your personal situation into account. The information published on TimeLinq is for informational purposes only and does not constitute investment advice. Investing involves a risk of capital loss.