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.
The value you expect at the next reset date, or pick a change below.
Try a change in the index
The rate becomes 4%.
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.
| Change in the index | Index | Rate you pay | Monthly payment | Change a month | Change in interest to the end |
|---|---|---|---|---|---|
| −2 points | 0% | 1% | €565.31 | -€146.01 | -€43,802.59 |
| −1 point | 1% | 2% | €635.78 | -€75.54 | -€22,660.48 |
| Today | 2% | 3% | €711.32 | €0.00 | €0.00 |
| +1 pointYour scenario | 3% | 4% | €791.76 | +€80.44 | +€24,131.53 |
| +2 points | 4% | 5% | €876.89 | +€165.57 | +€49,670.43 |
| +3 points | 5% | 6% | €966.45 | +€255.13 | +€76,540.96 |
| +4 points | 6% | 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.
- Mortgage Calculator : the full year-by-year schedule of a loan at one rate.
- Debt-to-income ratio calculator : the share of your income that goes on all your credit payments.
- Early Repayment Calculator : what a lump-sum repayment saves, and how much it lowers the payment.
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
Mortgage Calculator
Work out the monthly payment on a fixed-rate home loan, the interest it costs and how the balance falls each year.
ViewCalculatorDebt-to-income ratio calculator
Add up your monthly loan payments and see what share of your take-home pay goes to debt.
ViewCalculatorEarly Repayment Calculator
See what a lump-sum repayment saves on a fixed-rate loan, whether you lower the payment or shorten the term.
ViewPlan 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.
Free and open source. Use it here or host your own.