Skip to content
Online calculatorIndividualsSelf-employed

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

Your figures

€
%

Use the nominal rate from your offer. The APRC is higher because it also includes fees.

The result updates automatically as you type. Nothing is stored or sent.

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
YearPaidInterestPrincipalOutstanding 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?
  1. Monthly rate r = annual rate ÷ 12. Number of months n = term × 12.
  2. Monthly repayment = amount × r ÷ (1 − (1 + r)^−n). At 0 %: amount ÷ n.
  3. Each month: interest = outstanding balance × r; principal = repayment − interest; new balance = balance − principal.
  4. 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.

Download the Excel version

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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

  1. 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

  2. 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

  3. 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

  4. 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.

  • 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