The monthly payment is not the cost of the loan, and the nominal rate is not the APR. If you compare two offers by the payment, the cheaper one on paper can end up costing up to 1% more a year. Here you have the formula, a complete example and the figures that really matter.
Abrir la calculadora de préstamoThe payment formula
Most loans in Spain use the French system: a constant payment, and within each payment more and more principal and less interest. The formula is this:
Payment = principal × i ÷ (1 − (1 + i)−n)
Where i is the interest rate for each period (the annual nominal rate divided by 12) and n the total number of payments (years × 12). With a nominal rate of 3.50% over 25 years: i = 0.0029166 and n = 300.
If the nominal rate is 0, the formula breaks and the usual one applies: principal divided by the number of payments.
Worked example
€150,000 at 3.50% over 25 years, with a 1% arrangement fee and €600 of other initial costs.
| Item | Calculation | Result |
|---|---|---|
| Monthly payment | 150.000 × 0,0029166 ÷ (1 − 1,0029166−300) | 750,94 € |
| Total paid over 300 payments | 750,94 × 300 | 225.280,61 € |
| Interest | 225.280,61 − 150.000 | 75.280,61 € |
| Arrangement fee | 1% of 150,000 | 1.500,00 € |
| Other initial costs | — | 600,00 € |
| Total cost of the loan | 75.280,61 + 1.500 + 600 | 77.380,61 € |
| Net principal you receive | 150.000 − 1.500 − 600 | 147.900,00 € |
| Approximate APR | on the net principal | 3,69 % |
The interest is more than 50% of what was lent: for every euro you borrow, you pay back 1.50. And look at the APR: the 3.50% on the sign becomes a real 3.69% once what they deduct when you sign is counted.
What the term changes
Same amount, same rate. Only the number of years changes:
| Term | Payment | Total interest |
|---|---|---|
| 10 years | 1.483,29 € | 27.994,56 € |
| 15 years | 1.072,32 € | 43.018,29 € |
| 20 years | 869,94 € | 58.785,50 € |
| 25 years | 750,94 € | 75.280,61 € |
| 30 years | 673,57 € | 92.484,13 € |
| 40 years | 581,09 € | 128.921,49 € |
Going from 25 to 40 years lowers the payment by €170 a month, but costs €53,641 more in interest. It is one of the most expensive decisions you can take by looking only at the payment.
What the rate changes
| Nominal rate | Payment over 25 years | Interest |
|---|---|---|
| 2,00 % | 635,78 € | 40.734,45 € |
| 3,50 % | 750,94 € | 75.280,61 € |
| 5,00 % | 876,89 € | 113.065,52 € |
| 7,00 % | 1.060,17 € | 168.050,64 € |
Two points of nominal rate over 25 years are €115 a month and €37,785 in interest. That is why renegotiating the rate, or waiting for offers, is worth more than any other adjustment.
Nominal rate, APR and what you really pay
The nominal rate is the advertised rate: it does not include fees or costs. The APR is the effective annual cost and does include them, and it also takes into account that you pay month by month. It is the only figure that can be compared between offers, and it is the one the law requires to be shown in consumer credit advertising.
What to check before signing
- The APR, not the nominal rate. It is what compares like with like.
- The arrangement fee. 1% of 150,000 is €1,500 out of your pocket on day one.
- Completion costs. Notary, land registry and administration: by law, on mortgages the bank pays them, but it is worth reading the small print.
- Early repayment. How much they charge you if you pay the money back early, and from when you are allowed to do it.
- The variable rate. If it is variable, look at the spread and the reference index, not only at the first payment.
- Tied insurance. If they require you to take it out, add it to the APR: it can change the whole comparison.
Common mistakes
- Comparing by payment. The lowest payment is usually the longest term, which is also the most expensive.
- Ignoring the arrangement fee. With the same nominal rate, a 1% fee can cost you more than a tenth of a point on the rate.
- Not working out the total cost. Interest plus fees plus costs: the figure you actually pay out.
- Signing for 40 years because of the monthly cost. It adds risk and sends the interest soaring.
- Not reviewing the tie-ins. A loan with “advantages” tied to products can work out more expensive than one without them.
Frequently asked questions
What is the APR and how does it differ from the nominal rate?
The nominal rate is the loan's headline rate and does not include fees. The APR is the effective annual cost: it includes the arrangement fee and other costs, and it is the figure to use when comparing offers.
Why is the APR higher than the nominal rate?
Because the principal you receive is less than what you borrow (the fee and costs are deducted) and because you pay in monthly instalments, not once a year. In the example, a nominal rate of 3.50% with a 1% fee gives an APR of 3.69%.
How much more expensive is a longer term?
A lot. With €150,000 at 3.50%, going from 25 to 40 years lowers the payment from €750.94 to €581.09, but interest rises from €75,280.61 to €128,921.49: €53,641 more.
Does the calculator work for a mortgage?
Yes: the French system is the same. Bear in mind that a mortgage can have a variable rate, tied insurance and other products that the calculator does not include. For those, look at the bank's APR.
And for a personal or car loan?
As well. In consumer credit the term is shorter and the arrangement fee is usually 0, but the rate is considerably higher: the formula is the same.
What happens if I repay early?
You pay less interest because the principal falls sooner, but there may be an early repayment fee. The calculator does not include it: check it in the terms of the offer.
Can I compare two offers with the calculator?
Yes. Run each offer separately and compare the APR and the total cost, not the payment. If an offer has the same nominal rate but a higher fee, the APR gives it away.
Calculate yours
The calculator takes the amount, nominal rate, term, arrangement fee and other costs. It returns the payment, the interest, the total to repay, the total cost, the approximate APR and the net principal you receive. All in your browser, with no sign-up and no data sent.
Continue with these guides
- Rental yield calculator
- Self-employed contributions 2026: brackets and how to calculate them
- How to calculate VAT: adding and extracting
- Compound interest calculator
- Currency exchange calculator
The French amortisation system and the definition of the APR are those set out in the mortgage credit regulation (Law 5/2019) and in the Bank of Spain's public information. Interest calculated with the payment rounded to the nearest cent. Last reviewed: November 2026. Informational guide, not individual financial advice.