Loan calculator: monthly repayment online
Enter the amount borrowed, the rate and the term and see immediately your monthly repayment, the total cost and the yearly schedule. Nothing is stored.
Last updated: · Free · No account · No email
Result
Monthly repayment
€1,159.92
Number of months: 240
Total repaid
€278,381
Total interest cost
€78,381
- Share of interest in the total
- 28.2 %
Show the yearly repayment schedule
| Year | Paid | Interest | Principal | Outstanding balance |
|---|---|---|---|---|
| 1 | €13,919 | €6,888 | €7,031 | €192,969 |
| 2 | €13,919 | €6,638 | €7,281 | €185,688 |
| 3 | €13,919 | €6,379 | €7,540 | €178,148 |
| 4 | €13,919 | €6,111 | €7,808 | €170,339 |
| 5 | €13,919 | €5,833 | €8,086 | €162,253 |
| 6 | €13,919 | €5,545 | €8,374 | €153,879 |
| 7 | €13,919 | €5,248 | €8,671 | €145,208 |
| 8 | €13,919 | €4,939 | €8,980 | €136,228 |
| 9 | €13,919 | €4,620 | €9,299 | €126,929 |
| 10 | €13,919 | €4,289 | €9,630 | €117,299 |
| 11 | €13,919 | €3,946 | €9,973 | €107,326 |
| 12 | €13,919 | €3,592 | €10,327 | €96,999 |
| 13 | €13,919 | €3,224 | €10,695 | €86,304 |
| 14 | €13,919 | €2,844 | €11,075 | €75,230 |
| 15 | €13,919 | €2,450 | €11,469 | €63,761 |
| 16 | €13,919 | €2,042 | €11,877 | €51,884 |
| 17 | €13,919 | €1,620 | €12,299 | €39,585 |
| 18 | €13,919 | €1,182 | €12,737 | €26,848 |
| 19 | €13,919 | €729 | €13,190 | €13,659 |
| 20 | €13,919 | €260 | €13,659 | €0 |
How is this calculated?
- Monthly rate r = annual rate ÷ 12. Number of months n = term × 12.
- Monthly repayment = amount × r ÷ (1 − (1 + r)^−n). At 0 %: amount ÷ n.
- Each month: interest = outstanding balance × r; principal = repayment − interest; new balance = balance − principal.
- Total repaid = repayment × n. Total interest = total − amount borrowed.
Assumptions of this calculator
- Fixed rate and constant monthly repayment (annuity), the most common formula in Belgium.
- Arrangement fees, outstanding balance insurance and notary fees are not included; compare the APRC in the offers for that.
- Interest is charged monthly on the outstanding balance.
- Early repayments and reinvestment fees are left out.
Download the Excel version
Want to adjust the calculation yourself? Download the Excel version of this tool.
In short
A loan repayment is the fixed monthly amount with which you pay back capital and interest; in an annuity loan that amount stays the same, but the share of interest falls each month while the share of capital rises.
Sources & calculation method
This is how the calculation is built:
- The monthly rate is the nominal annual rate divided by twelve. The monthly payment follows from the annuity formula: capital × monthly rate ÷ (1 − (1 + monthly rate) to the power of minus the number of months). In Excel that is the PMT function.
- Each row of the repayment schedule calculates interest as outstanding balance × monthly rate. The capital share is the monthly payment minus that interest, and the new balance is the old balance minus the capital share. After the last month the balance is zero.
- The total repaid is the monthly payment × the number of months. The total interest cost is that total minus the capital borrowed, and equals the sum of the interest column.
- An extra repayment (extended version) is deducted from the balance in the month it is paid. The monthly payment stays the same, so the loan ends earlier; the file counts the interest and the months saved. Any early repayment indemnity is entered separately.
- The term comparison applies the same formula to three terms and puts monthly payment, total interest and total repaid side by side. The chart shows, year by year, the share of capital and interest in your payments.
Assumptions
- The file works with the nominal annual rate divided by twelve. Belgian lenders often use an actuarial annual rate, where the monthly rate is slightly lower; in the example that gives €1,154.28 instead of €1,159.92 per month. The difference is small, but it explains why your schedule may differ by a few euros from the bank’s.
- The rate stays fixed for the whole term. You simulate a variable rate by changing the rate and comparing the results; the file does not calculate revisions automatically.
- The first payment falls one month after the capital is drawn down and every payment is made at the end of the month.
- File fees, outstanding balance insurance and notary costs are not in the monthly payment. To compare offers with all their costs, use the loan comparison Excel.
Limitations
- The file is neither a credit offer nor financial advice; only the lender sets the final conditions.
- It only handles loans with fixed monthly capital repayment, not credit lines, bullet loans or loans with capital reconstitution.
- Tax benefits, such as a regional tax reduction for a home loan, are not calculated.
Sources
- FOD Economie – Kredietkosten (consumentenkrediet)
Used for: The difference between the borrowing rate and the APR, and which costs are and are not included in the APR.
Accessed: September 24, 2026
- FOD Economie – Vervroegde terugbetaling van een consumentenkrediet
Used for: The right to early repayment and the legal cap on the early repayment indemnity (1% or 0.5%) for consumer credit.
Accessed: September 24, 2026
- FOD Economie – Terugbetaling van een hypothecair krediet
Used for: How a loan with capital repayment works (interest on the outstanding balance) and the three-month-interest cap on the early repayment indemnity.
Accessed: September 24, 2026
- Wikifin (FSMA) – Hoe betaal je je lening of je krediet terug?
Used for: Independent explanation of repaying a loan in fixed monthly instalments.
Accessed: September 24, 2026
This page and the file were last updated on September 24, 2026. Legislation and rates may have changed since.
Frequently asked questions
How much can I borrow with my income?
The lender decides, based on your income, your fixed costs and your own contribution. Banks mainly look at the ratio between your monthly repayments and your net income; roughly one third is often quoted as a rule of thumb, but every bank sets its own limit. With this file you work backwards: pick a monthly payment you can carry comfortably, enter a rate and a term, and adjust the loan amount until you land on that payment. In the example, €1,160 per month at 3.5% over twenty years corresponds to €200,000.
What is the difference between the nominal rate and the APR?
The nominal or borrowing rate is the percentage the bank uses to calculate interest on your outstanding capital; that is the figure you enter in this file. The annual percentage rate (APR, called JKP or TAEG in Belgium) expresses the total cost of the credit as a yearly percentage, including file fees, administration fees and the cost of mandatory insurance. According to the FPS Economy all those costs sit in the APR, so you can compare loans regardless of amount and term. Always compare APR with APR, never one lender’s nominal rate with another’s APR.
How much interest will I pay in total on my loan?
Multiply your monthly payment by the number of months and subtract the capital borrowed. For €200,000 over twenty years at 3.5% that is 240 × €1,159.92 − €200,000 = €78,381. The same loan over fifteen years costs €57,358 in interest, over twenty-five years €100,374. The term therefore weighs more than many people think: borrowing five years longer costs almost €22,000 extra here, in exchange for a monthly payment that is €159 lower. Always work out the total interest, not just the monthly payment.
Is it worth repaying my loan early?
Usually yes, especially in the first years, because every extra euro comes straight off the capital and therefore no longer costs interest. In the example, €100 extra per month shortens the term by 26 months and saves €9,413 in interest. Do take the early repayment indemnity into account: for consumer credit it is legally capped at 1% of the capital repaid early (0.5% if less than a year remains), for a mortgage at three months of interest. Also compare the interest saved with what your savings would earn elsewhere.
Why do I mostly pay interest at the start and hardly any capital?
Because interest is calculated every month on the capital you still owe. In the first month of the example that is €200,000 × 3.5% ÷ 12 = €583.33 of interest; of the €1,159.92 payment, €576.59 is left for capital. Every month the balance drops a little, so the interest falls and the capital share rises. In the last month you pay just €3.37 of interest and €1,156.55 of capital. That is why an extra repayment has the most effect early on, and why refinancing near the end of the term is rarely worth it.
Osko Consult
Want more insight into your financial situation?
Osko Consult builds overviews, calculators and dashboards to order, also for small organisations and self-employed people. An Excel that does exactly what you need, instead of a template that almost fits.
Related tools
- Excel template
Loan comparison template in Excel
Put up to four loan offers side by side with amount, term, nominal rate, APR, monthly payment and all costs, and see at once which loan is cheapest over the whole term.
Individuals · Self-employed · SMEsFree - Excel templateOnline calculator
Car cost calculator in Excel
Work out what your car really costs per year, per month and per kilometre: depreciation, insurance, road tax, fuel or charging, maintenance and more.
Individuals · Self-employedFree - Excel template
Household budget template in Excel
Line up your income, fixed costs and variable spending month by month and see straight away how much is left to save, with a comparison between budget and actual.
IndividualsFree - Excel templateOnline calculator
Part-time work: what is left net? (Excel)
Compare your gross salary and an indicative net salary at 100, 90, 80, 60 and 50% and see the difference per month and per year, including the effect on holiday pay and the end-of-year bonus.
IndividualsFree