Market
Published on 18 November 20267 min read
€300,000 Mortgage Over 25 Years: Monthly Payment
The Immolytics editorial team
The monthly payment on a mortgage of 300,000 euros over 25 years, our worked example here, depends mostly on the yearly interest rate. The higher the rate, the heavier the monthly burden. You can work it out yourself with a fixed-payment formula. This article explains the steps, shows what moves the result, and tells you how to test it with the mortgage simulator.
How is the monthly payment on a 300,000 euro mortgage over 25 years calculated?
You multiply the amount borrowed by the monthly rate, then divide the result by a factor that reflects the term. This is the constant-annuity formula. Most mortgages with fixed monthly payments use it.
Here are the steps, in order:
- Take the capital: in this example, the amount borrowed is the 300,000 euros used as our scenario.
- Convert the yearly rate into a monthly rate. Depending on the lender, you either divide the yearly rate by the number of months in a year, or you take the twelfth root. The gap is small, but it exists.
- Count the number of payments: the term in years, multiplied by the number of months in a year. Our example term is 25 years.
- Work out the factor: one minus the inverse of one plus the monthly rate, raised to the power of the number of payments.
- Divide the capital multiplied by the monthly rate by that factor.
The result is the monthly payment before insurance and before fees. In a spreadsheet, the periodic payment function (called PMT in English versions) does the work in one line. You enter the monthly rate, the number of payments and the capital.
These inputs change from one file to the next. That is why we do not publish a single monthly figure here: it would be wrong for most readers. Running the calculation with your own real rate takes a few seconds and stays reliable. To understand the different rate formulas, read our guide to mortgages in Belgium.
If you want a quick benchmark for a given town, the site also shows a monthly payment at the median price of each municipality. It is a useful starting point before you ask a lender for an offer.
Why the interest rate changes the monthly payment so much
The rate is the factor with the biggest weight on the monthly payment, because it sets the share of interest in each repayment. Over 25 years, even a small difference in rate repeats on every payment and ends up as a large sum.
The mechanism is simple. At the start of the loan, most of each payment goes to interest. The capital goes down slowly. Over time, the interest share falls and the capital share rises, while the payment itself stays the same. A higher rate weighs most in the early years, when the outstanding balance is at its highest.
The type of rate matters too. A fixed rate gives a stable payment for the whole term. A variable rate can push it up or down at each review. Each formula has its own review rules and caps, set in each contract. Our article on fixed or variable rates compares both approaches without pushing you towards any offer.
To measure the effect of the rate, test several cases in the simulator:
- a rate close to the ones in the offers you have received;
- a slightly higher rate, to check that your budget holds if the market moves;
- a slightly lower rate, to see what a renegotiation could bring.
This stress test is most useful with a variable rate. A budget that only works at the most favourable rate is a fragile budget.
Term: what a shorter or longer loan changes
A longer term lowers the monthly payment but raises the total cost of the loan, and the opposite is true for a shorter term. For a loan like our example, comparing 25 years with other terms is the best way to choose with full knowledge.
Here is how to read the trade-off:
| Choice of term | Effect on the monthly payment | Effect on the total cost |
|---|---|---|
| Shorter term | Heavier payment | Clearly lower total interest |
| 25-year term | Common compromise | Middle total interest |
| Longer term | Lighter payment | Higher total interest |
A long term is not bad in itself. It leaves room if your income is irregular or if children arrive. It can also be combined with early repayments when your situation improves, within the limits set by your contract. The conditions for early repayment vary between lenders, so read them before you sign.
Age matters as well. The closer a borrower gets to retirement, the shorter the term that is available. Retirees in Wallonia will find pointers on the page for retirees in Wallonia.
What income do you need to afford this monthly payment?
There is no official minimum salary for borrowing an amount like our example. Each lender sets its own rule on repayment capacity. The logic is the same everywhere: the monthly payment, added to your other credits, must be a reasonable share of your stable net income.
To estimate your capacity, proceed like this:
- add up the regular net income of the household, without uncertain bonuses;
- subtract fixed costs: other loans, maintenance payments, and any rent that will continue;
- keep a realistic living budget for food, energy, transport and surprises;
- compare what is left with the monthly payment calculated at a cautious rate.
The same method answers the question of people on a modest income who wonder how much they can borrow. Start from the monthly payment your budget can really carry, then look for the matching capital in the simulator, by reversing the calculation. The amount you can borrow is often lower than you hope, and that is normal.
Your own contribution counts too. The larger the share of the price the loan covers, the more careful the lender is. Our page on a mortgage without a down payment explains what this means. Households with children can look at the page for families, and those buying in Flanders at the page for families in Flanders, because some rules differ from one Region to another.
If you buy to let, the logic changes: the expected rent enters the analysis. The page for investors covers this approach.
What the monthly payment does not include
The payment given by the formula covers only capital and interest. It leaves out the rest of the cost of a purchase. Your real budget is therefore always higher than the simulator result.
Think about these items:
- the outstanding-balance insurance, often required by the lender, and the fire insurance on the property;
- file fees and valuation fees, where they apply;
- deed costs and the mortgage registration that secures the loan;
- registration duties and notary fees, whose rules vary by Region;
- works, energy bills and any co-ownership charges.
The amounts for these items depend on the property, the Region and the contract. Do not guess them: ask for them in writing. If the property needs energy works, look into the green loan and into regional grants, which depend on criteria that differ in each Region.
The price matters most of all. An overvalued property inflates the amount borrowed and so the monthly payment. Before you set your budget, check the value of the property with the online estimate, which relies on data from the municipality.
Finally, get help if you need it. An approved mortgage broker can compare offers. This page does not recommend any lender or broker, and it does not replace personal advice.
Frequently asked questions
How can I quickly calculate the monthly payment on this kind of loan?
The quickest way is to use a simulator, or the payment function of a spreadsheet, with your rate, the capital and the number of payments. You get the monthly payment before insurance in a few seconds. You can then compare several rates and several terms before you ask for an offer.
What salary do you need to borrow this amount in Belgium?
There is no minimum salary set by law, because each lender judges repayment capacity by its own criteria. It looks at your stable net income, your costs, your other credits and your own contribution. Work out first a monthly payment that fits your budget, then test it with several lenders.
Does the monthly payment change during the loan?
With a fixed rate, the monthly payment stays the same for the whole agreed term. With a variable rate, it can change at each review, according to the rules of the contract. Check how often reviews happen and whether there are caps before you sign.
Stay informed about the real estate market
Property prices by email, every 2 weeks.
You can unsubscribe in one click.