Skip to content

El Cerebro

Mortgage and housing

Review of a variable-rate mortgage

What payment is left after a review of a variable-rate mortgage, how much it changes with respect to the one you had, and what official Euríbor was published twelve months ago.

What it does

It starts from the outstanding capital and the term remaining for you, and applies the spread you have agreed. With that it calculates two payments: the one you would pay with the Euríbor at your last review and the one you would pay with the new one, on the same numbers. The difference is what the review changes for you, and it is stated per month and over twelve months.

The new Euríbor comes by default with the latest official value published by the Banco de España, with its month on the field label. You can change it to the one your review applies. The detail adds the official Euríbor value from twelve months ago, with its month, so that you can see what it is being compared against. All of that data is on the [Euríbor](/euribor) page.

With the default values —150.000 € outstanding, 240 months, a spread of 0,7 and an Euríbor going from 3,5 to 2,954— the previous payment was 924,86 € and the new one comes out at 881,86 €. That is 43,00 € less per month and 516,00 € less over twelve months.

Key concepts

  • Outstanding capital: what remains to be paid, not what was originally requested. If you have prepaid, it is lower, and that is why both payments also fall.
  • Remaining term: the months left, not the total years. It is the term remaining at the date of the review.
  • Spread: the points your lender adds to the Euríbor. It is in the contract and does not change at the review, so it goes into both payments equally.
  • Official Euríbor: the monthly reference rate published by the Banco de España. What gets reviewed is the Euríbor, and the spread is maintained.
  • A single review: the page calculates this review and not the ones that follow. Knowing what will happen in six months would require inventing an Euríbor that does not exist yet.

Frequently asked questions

Why is the new payment not the previous one plus the change in points?

Because the payment is not a proportional share of the capital. The monthly payment comes out of the French formula, with the monthly interest rate divided by twelve, and that is why moving the Euríbor three points does not move the payment in the same proportion as the rate. The account uses that formula, the same one the rest of the site's calculators use.

What happens if the new Euríbor falls below zero?

The spread is added and, if the combined rate comes out negative, the account is done at 0 % and the detail warns you of it. A payment with negative interest would return more capital than is outstanding, which is a loan that pays itself: it is not a real contract case, but a limit of the model, and that is why it is stated instead of producing a strange number.

And if my review also changes the spread?

This page does not contemplate that: the spread goes in as a single number in both payments. If your spread has also been changed, type the new one in the field and the previous payment will come out calculated with that same value. The difference between the two will still be the effect of the Euríbor, which is what you want to isolate.

Does it calculate the payment for the following months?

No. Only the new payment from the review onwards. The following reviews depend on Euríbors that have not yet been published, and a projection of that would be an invented figure shaped like data. The page does not do it.

Do my mortgage numbers come from here?

No. The five fields are calculated in the browser, they are not sent anywhere, they are not stored, and they can be copied into the address to return to the same account. There is no sign-up and no user account.

Is this official data or an estimate?

No. It is an account built on the numbers you type: the outstanding capital and the term are yours, and the spread and the two Euríbors are those of your contract. The only official data on the page is the value that appears by default, and it comes from the Banco de España. The decision about your mortgage is yours, and so is the enquiry to your lender.

Related calculators

A note to Cerebro

What would you improve?

A member of the team reads it. Tell us what brought you here and what was missing.

The tone of your visit
Between 10 and 2000 characters.0 / 2000

Only if you want an answer.