Variable-Rate Payment Calculator

Enter what you still owe, the time left, the index your loan follows and your lender's spread, then the index you expect after the next revision. See the new monthly payment, what the change adds up to over a year and to the end of the loan, and the payment for the index moving from 2 points lower to 4 points higher. Nothing to sign up for.

Your loan today
€

What you owe today, from your latest loan statement.

Time left on the loan

Years plus months, for example 22 years and 4 months.

%

The reference rate your loan follows, such as Euribor or a central bank rate, at the value your current payment uses. It can be negative.

%

The fixed margin your lender adds to the index, as set in your contract.

You pay 3% today: the index plus the spread.

At the next revision
%

The value you expect at the next reset date, or pick a change below.

Try a change in the index

The rate becomes 4%.

Your budget
€

After tax. Add it to see the payment as a share of your income, or leave it empty.

New monthly payment

€791.76

€80.44 more a month (+11.3%)

Payment today, at 3%

€711.32

Payment after the revision, at 4%

€791.76

Change a month
+€80.44
Over the next 12 payments
+€965.27
Change in interest to the end of the loan
+€24,131.53

The new payment would take 28.3% of your net income, against 25.4% today. Debt-to-income band: Healthy.

Bands from the debt-to-income calculator: under 30% healthy, 30% to 40% caution, above 40% high. They are a rule of thumb, not a lender's limit.

The new rate applies from your next payment to the end of the loan. Reset dates, caps and floors depend on your contract and are not included.

Your payment if the index moves

The same loan with the index from 2 points lower to 4 points higher than today and the spread unchanged, each rate applied from the next payment to the end of the loan.

Monthly payment for each change in the index
Change in the indexIndexRate you payMonthly paymentChange a monthChange in interest to the end
−2 points0%1%€565.31-€146.01-€43,802.59
−1 point1%2%€635.78-€75.54-€22,660.48
Today2%3%€711.32€0.00€0.00
+1 pointYour scenario3%4%€791.76+€80.44+€24,131.53
+2 points4%5%€876.89+€165.57+€49,670.43
+3 points5%6%€966.45+€255.13+€76,540.96
+4 points6%7%€1,060.17+€348.85+€104,655.53

How a rate revision changes your payment

On a variable-rate loan the rate you pay has two parts: a reference index and a spread. The index is a market or central bank rate, such as Euribor in much of the euro area, and other countries use their own. The spread is the lender's margin and is fixed in your contract.

At each reset date, often every 3, 6 or 12 months, the lender takes the latest value of the index, adds the spread and works out a new payment on the balance and the time left. With the same spread, a rise of 1 percentage point in the index raises the rate by up to 1 percentage point, depending on any cap or floor.

This calculator shows the payment before and after a change you choose, so you can see ahead of time what a rise or a fall would mean for your monthly budget.

Worked example

Say you still owe €150,000 with 25 years left. Your loan follows an index at 2% plus a spread of 1%, so you pay 3%: €711.32 a month, and €63,395.00 in interest to the end of the loan.

At the next revision the index rises to 3%, so your rate becomes 4%. The payment goes up to €791.76: €80.44 more a month (11.3%), €965.27 more over the next 12 payments and €24,131.53 more interest by the end of the loan, if the rate stays there.

A rise of 3 points instead, to a rate of 6%, would take the payment to €966.45, €255.13 more than today.

On a net income of €2,800 a month, the payment takes 25.4% of it today, 28.3% after the first rise and 34.5% after the larger one, which the debt-to-income bands rate as “Caution”.

How it is calculated

Each payment is the level payment that clears the balance over the months left, from the same fixed-rate engine as the mortgage calculator:

r = max(0, i + s) ÷ 12

M = P × r ÷ (1 − (1 + r)−n)

i is the index and s the spread, both as yearly rates. r is the monthly rate, M the monthly payment, P the balance still owed and n the number of payments left. When the index plus the spread is below 0%, the rate is taken as 0% and the payment is simply P divided by n.

  • The monthly change is the first payment at the new rate minus the first payment at today's rate, both on today's balance over the same months.
  • The yearly change compares the sum of the first 12 payments in each schedule, or all remaining payments if fewer are left. Payments are rounded individually, so the total can differ from the monthly change multiplied by the number of payments.
  • The change in interest is the interest of the new schedule minus today's, both to the end of the loan.
  • The share of income is the payment divided by the net income you enter, read against the debt-to-income calculator's bands: under 30% healthy, 30% to 40% caution and above 40% high. They are a rule of thumb, not a lender's limit.
  • The calculation runs in your browser. The figures you enter stay on your device and are not saved.

Assumptions

  • The new rate applies from your next payment to the end of the loan. In practice it is revised again at every reset date, so each result is one scenario, not a forecast.
  • The balance and the time left stay as they are, and the payment is what changes. Some lenders can keep the payment and change the term instead.
  • Today's payment is worked out from the index and spread you enter. Your statement can differ by a few cents, and insurance and account fees are left out.
  • You enter the index yourself: the calculator has no index data of its own. Take the current value from your contract, your lender or the body that publishes the index.

The calculator accepts balances from €100 to €100,000,000, up to 50 years left, an index from -5% to 20% and a spread up to 10%.

What your contract decides

How a real revision works depends on your contract and on the rules where you live. None of this is built into the calculator:

  • Reset dates: how often the rate is revised, which day's index value counts and when the new payment starts.
  • Caps and floors: some contracts limit how far the rate can rise or fall, or stop it going below a set level. The calculator only keeps the rate from going below 0%.
  • The index: Euribor, a central bank rate or a national reference rate, each with its own terms (for example 3, 6 or 12 months) and publication schedule.
  • Mixed-rate loans: a fixed period comes first and the variable rate after it. Enter the balance and the time left as they will be when the variable period starts.

Your lender's own figures are the ones that count. Use this calculator to plan ahead of a revision, then check its figures against your lender's.

This calculator is for illustrative purposes only and does not constitute financial, investment, or tax advice. Figures shown are estimates — consult a qualified financial advisor before making financial decisions.

Related content

Plan for a higher payment in your budget

Add the loan to WonderMoney, give the higher payment its place in your monthly budget and see what it leaves for the rest of your spending and saving.

Stress-test your monthly cash flow

Free and open source. Use it here or host your own.

Free and open source. Use it here or host your own.