How to Calculate a Mortgage in Belgium - Full Formula & Calculator Guide

The Short Answer

Calculating a mortgage is straightforward with the right formula:

The Basic Formula:

MONTHLY PAYMENT = (Amount Borrowed × Rate%) / (1 - (1 + Rate%)^-Number of Months)

In Practice:

• You Borrow: €250,000
• Rate: 4% per year (0.333% per month)
• Term: 25 years = 300 months
• Monthly Payment: €1,305/month

This Article Covers:

• The Exact Formula
• How to Calculate It (Step by Step)
• Online Calculators
• What You Can Influence
• Practical Examples

1. The Mortgage Formula - Explained in Full

The Basic Formula (Annuity Loan)

This Is the Most Common Type of Mortgage in Belgium:

MONTHLY PAYMENT = P × [r(1+r)^n] / [(1+r)^n - 1]

Where:
- P = Principal (Amount Borrowed) = €250,000
- r = Monthly Rate = Annual Rate / 12
- n = Number of Months = Years × 12

It Sounds Complex, But Let Me Walk You Through It Step by Step!

Step 1: Gather Your Data

What You Need:

Step 2: Convert the Rate to Monthly

Annual Rate: 4.0%
Monthly Rate (r): 4.0% ÷ 12 = 0.333% = 0.00333

Step 3: Calculate the Number of Months

Term: 25 years
Number of Months (n): 25 × 12 = 300 months

Step 4: Apply the Formula

MONTHLY PAYMENT = 250,000 × [0.00333(1+0.00333)^300] / [(1+0.00333)^300 - 1]

MONTHLY PAYMENT = 250,000 × [0.00333 × 2.705] / [2.705 - 1]

MONTHLY PAYMENT = 250,000 × [0.00901] / [1.705]

MONTHLY PAYMENT = 250,000 × 0.00528

MONTHLY PAYMENT = €1,320/month

Result: €1,320 per month (rounded)

2. The Components of Your Monthly Payment

Your Monthly Payment Consists of Two Parts:

Part 1: INTEREST

This Is What You Pay the Bank for the Money You Borrowed.

First Month:

Interest = Outstanding Balance × Monthly Rate
Interest = €250,000 × 0.333% = €833

This Amount DECREASES Every Year (Because Your Debt Reduces)

Part 2: CAPITAL REPAYMENT

This Is the Portion of the Debt You Are Actually Paying Off.

First Month:

Capital Repayment = Monthly Payment - Interest
Capital Repayment = €1,320 - €833 = €487

This Amount INCREASES Every Year (Because Interest Falls)

Interest vs. Capital Repayment in the First Year:

Note: Interest Decreases and Capital Repayment Increases Every Month!

3. Practical Scenarios - Different Situations

Scenario 1: Property at €300,000, Own Contribution €45,000

Data:

• Property Price: €300,000
• Own Contribution (15%): €45,000
• Amount to Borrow: €255,000
• Rate: 3.8%
• Term: 25 years

Calculation:

Over 25 Years:

• Monthly Payment: €1,280
• Total Paid: €1,280 × 300 = €384,000
• Of Which Interest: €384,000 - €255,000 = €129,000

Scenario 2: Property at €250,000, Larger Own Contribution

Data:

• Property Price: €250,000
• Own Contribution (25%): €62,500
• Amount to Borrow: €187,500
• Rate: 3.5%
• Term: 25 years

Calculation:

Advantage: €441 LESS per month (compared to Scenario 1)!

Scenario 3: Longer Term (30 Years)

Data:

• Borrowed: €255,000
• Rate: 3.8%
• Term: 30 years (NOT 25!)

Calculation:

Advantage: €206 LESS per month (compared to 25 years)

Disadvantage: You Pay Much MORE Interest in Total!

Total Paid (30 years): €1,074 × 360 = €386,640
Total Interest: €386,640 - €255,000 = €131,640

(vs. €129,000 over 25 years = €2,640 MORE!)

4. What Can You Influence?

These Are the "Levers" You Can Pull:

1. INTEREST RATE (Biggest Impact)

How to Influence It:

• ✅ Better Credit Profile (Higher Rate Discount)
• ✅ Larger Own Contribution (Lower Risk = Lower Rate)
• ✅ Shorter Term (Possible Rate Discount)
• ✅ Fixed Rate (Safe, BUT Not Necessarily the Lowest)

Impact Example:

1% Rate Difference = €97-€202 per Month!

2. AMOUNT BORROWED (P)

How to Influence It:

• ✅ Larger Own Contribution (Less to Borrow)
• ✅ Look for a Cheaper Property
• ✅ Increase Your Income (Better Mortgage Pre-Approval)

Impact Example:

€50,000 LESS Borrowed = €256 LESS per Month!

3. TERM (n)

How to Influence It:

• ✅ Shorter Term = Less Total Interest
• ❌ But: Higher Monthly Payment
• ✅ Longer Term = Lower Monthly Payment
• ❌ But: Much MORE Total Interest

Impact Example:

Tip: 25 Years Is Often the Best Balance!

5. Online Mortgage Calculators - The Easy Way

You Do NOT Need to Calculate This by Hand!

Well-Known Belgian Calculators:

1. ING Mortgage Calculator

• Website: ing.be
• Type: Full Mortgage Calculator
• Features: Rate, Term, Own Contribution

2. Argenta Mortgage Calculator

• Website: argenta.be
• Type: Simple Version
• Features: Quick Calculation

3. Beobank Mortgage Calculator

• Website: beobank.be
• Type: Advanced Calculator
• Features: Monthly Payment, Rate, Costs

4. Hypotheek.be

• Website: hypotheek.be
• Type: Independent Calculator
• Features: Compare Multiple Scenarios

5. Financieel-Advies.be

• Website: financieel-advies.be
• Type: Educational
• Features: Formula Explanation

6. Practical Checklist - How to Calculate

Step by Step:

1. ☐ Determine the Amount to Borrow

• Property Price × (100% - Your Own Contribution %)

1. ☐ Choose Your Rate

• Ask the Bank for Their Conditions
• Or Use the Market Average (3.5-4.5%)

1. ☐ Choose the Term

• 20-30 Years (25 Is the Standard)

1. ☐ Apply the Formula

• Use an Online Calculator (Easier!)
• OR: Calculate by Hand (See Above)

1. ☐ Compare Scenarios

• Different Amount Borrowed?
• Different Rate?
• Different Term?

1. ☐ Check Affordability

• Monthly Payment × 3-4 = Maximum Amount Borrowable
• The Bank Gives Its Final Yes/No

7. Summary: How to Calculate a Mortgage

Key Points:

1. THE FORMULA:

   MONTHLY PAYMENT = P × [r(1+r)^n] / [(1+r)^n - 1]

• P = Amount Borrowed
• r = Monthly Rate (Annual ÷ 12)
• n = Number of Months

1. YOUR MONTHLY PAYMENT CONSISTS OF:

• Interest (Decreases Every Year)
• Capital Repayment (Increases Every Year)

1. YOU CAN INFLUENCE:

• ✅ Interest Rate (Not Entirely in Your Hands, But Shop Around!)
• ✅ Amount Borrowed (Put in More of Your Own Money!)
• ✅ Term (Balance Monthly Payment vs. Total Interest)

1. PRACTICAL EXAMPLES:

• €255,000 × 3.8% × 25 years = €1,280/month
• €187,500 × 3.5% × 25 years = €939/month
• Shorter Term = MUCH Less Total Interest

1. EASIEST OPTION:

• Use an Online Calculator (Bank or Independent)
• Compare Scenarios
• Consult a Mortgage Broker

1. AFFORDABILITY CHECK:

• Banks Say: Monthly Payment Should Not Exceed 1/3 to 1/4 of Your Income
• This Determines Your Maximum Budget

Golden Rule: The LESS You Borrow and the SHORTER the Term = the LESS Interest You Pay!

Next Step

Ready to Calculate Your Mortgage?

1. Determine Amount, Rate and Term
2. Use an Online Calculator
3. Compare Scenarios
4. Consult Your Bank or a Broker
5. Choose the Best Option

Good Luck with Your Mortgage!