The constant annuity formula applied to a capital of 130,000 euros over 300 months yields very different results depending on whether the nominal interest rate or the APR is used in the calculation. This confusion, common in public simulators, skews the estimate from the start and complicates the comparison between banking offers.
Nominal rate or APR: the variable that changes everything in the monthly payment calculation
The monthly payment of a fixed-rate amortizable loan is calculated using the formula M = C x r / (1 – (1 + r)^-N), where C represents the borrowed capital, r the monthly rate, and N the number of monthly payments. For a loan of 130,000 euros over 25 years, N equals 300.
Related reading : How to Find the Ideal Property for Your Next Investment
The monthly rate r corresponds to the annual nominal rate divided by 12. Using the APR in this field means counting insurance and ancillary fees twice, as the APR already includes them. Broker calculators often display a simple “rate” field without specifying its nature, which leads the borrower to instinctively enter the APR.
We recommend always entering the nominal interest rate in the formula, then separately adding the monthly cost of borrower insurance. This approach avoids double counting and allows for the comparison of the monthly payment for a 130,000 euro loan over 25 years between several institutions on a homogeneous basis.
Read also : How to Choose the Right Car Insurance for Peace of Mind
Impact of borrower insurance on the monthly payment of a 130,000 euro loan
Mortgage insurance is rarely included in calculation examples, even though it significantly alters the monthly charge. Two calculation methods coexist: premium on initial capital (the premium remains fixed each month) and premium on remaining capital (the premium decreases over time).
For a loan of 130,000 euros spread over 25 years, the difference between these two methods represents a significant cost gap over the total duration. Group contracts offered by the lending bank generally operate on initial capital. Delegated contracts, taken out with an external insurer, more often offer pricing on remaining capital.
Variables to check before comparing offers
- Is the announced insurance rate calculated on the initial capital or on the remaining capital? The monthly payment displayed at the beginning of the loan may seem identical, but the total cost diverges significantly.
- The insured amount (100% on one head, 50/50 on two co-borrowers) directly modifies the amount of the monthly premium.
- The covered guarantees (death, PTIA, ITT, IPP) influence the rate. A cheaper contract sometimes covers fewer risks, which poses a problem in case of a claim.
Insurance can represent up to one third of the total cost of the loan over a period of 25 years. Neglecting this item during simulation leads to underestimating the actual monthly payment by several dozen euros.
25-year term and debt ratio: the trap of apparent smoothing
Extending the term to 25 years mechanically reduces the monthly payment, which improves the displayed debt ratio. The limit commonly applied by banks is around 35% of net income. On paper, a loan of 130,000 euros over 25 years more easily falls below this threshold than a loan over 20 years.
However, the total cost of the loan increases substantially. Five additional years of repayment add several tens of thousands of euros in interest to the final price of the property. We observe that some borrowers choose the maximum term without comparing the impact on the overall cost.
Necessary salary and remaining income
The calculation of the minimum salary to borrow 130,000 euros over 25 years directly depends on the rate obtained. The formula is simple: total monthly payment (loan + insurance) divided by 0.35 gives the minimum net monthly income. This threshold does not take into account the remaining income, which the bank evaluates separately.
The remaining income corresponds to income reduced by all fixed charges (monthly payments, residual rents, pensions paid). Banking institutions apply minimum remaining income thresholds that vary according to the household composition. A file may be rejected despite a debt ratio below 35% if the remaining income is deemed insufficient.
Amortization schedule: reading the first lines is enough to understand the mechanism
On a classic amortizable loan, the first monthly payments are composed mainly of interest. The portion of capital repaid gradually increases. On a loan of 130,000 euros over 25 years, the crossover point (the moment when the capital repaid exceeds the interest in each installment) generally occurs after several years of repayment.
This structure has a direct consequence on early repayment. Repaying early during the first years of the loan generates a savings in interest that is much greater than an early repayment at the end of the loan, since the remaining capital is still high.
- Requesting the complete amortization schedule from the bank before signing allows you to visualize the capital/interest distribution month by month.
- Check that the early repayment penalties (IRA) do not exceed six months of interest or 3% of the remaining capital, according to the more favorable limit.
- Compare the total cost displayed at the end of the schedule between two competing offers, insurance included, to measure the real gap.
The amortization schedule remains the most reliable tool for assessing the real cost of a loan of 130,000 euros over 25 years. Online simulators provide a quick estimate, but only the contractual document issued by the bank commits it to the displayed amounts. Any simulation remains indicative as long as the loan offer is not issued.