Are you wondering exactly how each monthly mortgage payment is split between principal, interest, and insurance?
Do you want to know whether an early repayment or a refinancing can really reduce your total borrowing cost?
The mortgage amortization schedule is the detailed timetable that lists, month by month, your repayments and how they’re allocated.
In this article, the amortization schedule is explained simply: how to read it month by month, the different amortization methods, and the tools to generate one.
You’ll also find practical tips to optimize your monthly payments and prepare for a renegotiation or early repayment of your home loan.
Contact your local Optimhome real estate advisor for personalized support and precise answers tailored to your financial situation.
What Is a Mortgage Amortization Schedule?
The amortization schedule, also called the repayment timetable, is the document provided by the lender. It details, month by month, the repayment of the mortgage.
Each line typically shows the monthly payment, the principal repaid, the interest portion, and the remaining principal balance. Some banks also include the amount of the borrower’s insurance.
This document serves as a roadmap to track how your debt decreases. It helps you anticipate due dates and verify that bank debits are accurate.
You usually receive a provisional schedule with the loan offer. After the funds are disbursed, the bank must provide a final version.
In practice, the most widespread model for home loans is the fixed-rate amortizing loan with a constant monthly payment. The payment remains stable while the principal portion increases over time and the interest portion decreases.
Other methods exist. Straight-line amortization provides a constant principal portion each month: the total monthly payment gradually declines. Declining-balance amortization is rarer in mortgages and reduces the total payment more quickly at the beginning.
The choice of amortization type directly affects the monthly payment, the total borrowing cost, and your disposable income. Always keep your schedule and consult it regularly throughout the life of the loan.
The Key Role of the Amortization Schedule in Your French Property Project
The amortization schedule gives you clear visibility over your financing. It shows how the debt evolves over time.
With this timetable, you can anticipate your monthly payments and plan your budget. You can also estimate the impact of an additional lump-sum payment.
It’s used to calculate total repayments and the cost of interest and insurance. It’s a useful tool for comparing loan offers.
Presenting a precise schedule also makes discussions with banks easier. It strengthens the credibility of your file during a renegotiation.
The Main Amortization Types Explained Simply
Standard amortization (constant monthly payment): the most common model for mortgages. The payment remains the same. The interest portion decreases over time and the principal portion increases.
Straight-line amortization: the amount of principal repaid is the same at each installment. The total monthly payment decreases over time. This method reduces principal faster but requires higher payments at the start.
Declining-balance amortization: less common in real estate lending. The payment drops quickly at the beginning. It targets specific borrower profiles or certain specialized loans.
Each method influences the principal/interest split, the total cost, and flexibility in the event of early repayment. Choose according to your repayment capacity and financial horizon.
How to Read and Understand Your Amortization Schedule Month by Month
An amortization schedule contains standard columns: installment number, date, monthly payment, principal portion, interest portion, borrower’s insurance amount (if included), and remaining principal balance.
The logic is simple. Each month, interest is calculated on the remaining principal balance. As that balance falls, the interest portion goes down.
With a constant-payment loan, the amount paid each month doesn’t change. But the composition does: more interest at the beginning, more principal later.
If you make an early repayment early in the term, you reduce principal quickly. This then lowers future interest. Conversely, repaying late in the term may yield relatively smaller savings.
Watching the “remaining principal” column lets you track your exact progress. Regularly compare the schedule with your bank debits to detect any anomalies.
Simple example: for a €200,000 loan over 25 years at about 3.8%, the monthly payment excluding insurance is between €1,000 and €1,100. Figures vary based on the exact rate and insurance.
At the start, a large share of that monthly payment covers interest. Over time, the principal share increases and the balance flips.
A Practical Read of a Sample Line
Month 1 — monthly payment €1,050 — interest €650 — principal repaid €400 — remaining principal €199,600.
This line shows that, in the first month, €650 goes to interest. The principal decreases by €400.
If you compare with month 120, the interest portion will be much lower and the principal portion much higher.
Regularly reviewing these excerpts helps you verify debits and plan potential actions (early repayment, renegotiation).
What the Schedule Reveals About the Term and the Total Amount Repaid
The schedule lets you calculate total repayments over the loan term. It sums all monthly payments and details total interest paid.
Extending the term reduces the monthly payment. However, it increases total interest paid. Shortening the term does the opposite.
The schedule is therefore the ideal tool to compare several scenarios: 20 years versus 25 years, or different rates.
Always include borrower’s insurance in your calculations to get the “all-in” monthly cost. This can significantly change comparisons between offers.
Calculating and Building the Amortization Schedule: How It Works in France
Three main elements are enough to build an amortization schedule: the loan amount, the interest rate, and the loan term.
The nominal rate is used to calculate interest. Borrower’s insurance is often added and may be expressed as a rate or a fixed amount.
The repayment frequency — generally monthly — defines how many lines the schedule has. Each month, you calculate interest on the remaining principal, then determine the principal portion.
Without diving into formulas, keep this in mind: with a fixed-rate amortizing loan, the payment (excluding insurance) is calculated so the debt is fully repaid by the end of the chosen term.
Ancillary fees (application fees, guarantee fees) increase the overall cost, but they don’t always appear in the timetable, which focuses on the loan itself.
To quickly obtain a reliable timetable, borrowers use online simulators. These tools let you test several scenarios in a few clicks.
The Essentials Needed to Create an Amortization Schedule
To generate a reliable timetable, gather:
the total loan amount;
the amortization term in years or months;
the loan’s nominal interest rate;
the amount or rate of borrower’s insurance;
the repayment frequency (most often monthly);
any guarantee fees and any deferred-payment conditions.
If you have several loans (e.g., a main loan plus a zero-interest loan), each loan has its own schedule.
Using an Online Simulator: The Simple, Reliable Solution
Free simulators instantly generate an amortization schedule. They let you compare rates and terms and export results to PDF or CSV.
These tools also show the effect of early repayment, a rate renegotiation, or switching insurance providers. They help you decide whether an operation is worthwhile.
Before signing a loan offer, test several scenarios to check your repayment capacity and the total borrowing cost.
French Mortgage Repayment Methods: What You Need to Know
A mortgage can be repaid in several ways: fixed or variable monthly payments, possible deferral at the start, mandatory insurance, and options to adjust payments.
Each installment generally includes an interest portion, a principal portion, and possibly an insurance premium.
A fixed-rate loan provides predictability. The constant payment protects your monthly budget, even though the principal/interest split evolves.
A variable-rate loan exposes you to payment changes based on a benchmark index. It can be advantageous if rates fall, but it carries greater risk.
The bank may offer payment modulation: you can sometimes increase or decrease payments according to your contract.
Finally, renegotiation or refinancing can lower the rate and generate savings. Compare the potential gain with any penalties or costs before deciding.
Constant vs. Adjustable Payments: What’s the Difference?
With a constant payment, your debit remains stable. It’s reassuring for budgeting, with steady amortization.
With an adjustable payment (variable rate or modulation option), the amount can change. You need to monitor index movements and market conditions.
The choice depends on your risk tolerance and time horizon: for most households, the stability of a fixed rate is preferable.
Early Repayment and Renegotiation: Impact on the Schedule
An early repayment reduces the remaining principal. Future mortgage interest then declines, and the timetable is recalculated.
In the event of a renegotiation or refinancing, the bank must provide a new amortization schedule with the updated terms.
Always calculate the potential gain and compare it with early-repayment penalties or renegotiation costs before proceeding.
Practical Tips to Read and Use Your Amortization Schedule Effectively
Keep a copy of your schedule and, if possible, import it into a spreadsheet. This makes simulations easier.
Identify periods when the interest portion is highest. That’s often the most profitable time for an early repayment.
Check consistency between the timetable and your bank debits. If there’s a discrepancy, contact your bank with supporting documents.
Before renegotiating, simulate the rate decrease on the monthly payment and on total repayments to assess profitability.
Don’t forget borrower’s insurance. Delegating insurance (switching providers) can generate notable savings and should be included in your comparisons.
Levers to Reduce the Cost of Your Mortgage
To reduce cost, you can: extend the term, renegotiate the rate, consolidate loans, or delegate insurance. Each option has different effects.
Early repayment saves interest. Insurance delegation can lower your monthly payment if you find a cheaper policy.
Always compare the expected savings with the fees incurred before taking action.
Mistakes to Avoid When Reading the Schedule
Don’t confuse the principal portion with the interest portion. That mistake ruins any early-repayment simulation.
Don’t overlook insurance: it may be shown separately. Add it to get the real monthly cost.
Watch debit dates, any exceptional installments, and adjustments linked to deferred periods.
How Do You Get a Mortgage Amortization Schedule in France?
The lender must attach an amortization schedule to the loan offer. A final version follows disbursement.
You can download the timetable from your online client area. Otherwise, request it by post or email from customer service.
Free online simulators also generate a personalized schedule based on the amount, rate, term, and insurance.
If the loan terms change (renegotiation, refinancing), request a new schedule to verify the updated conditions.
Partner Banks and Online Platforms
Get your schedule via your bank, brokers, specialized platforms, or public sites offering simulators.
These tools make it easier to compare offers and estimate monthly payments across several scenarios.
What to Do if Loan Conditions Change?
Always request a new amortization schedule after any modification. Archive the document and compare it with debits.
This ensures transparency and avoids misunderstandings with the lender.
Get Support from an Optimhome Real Estate Advisor for Your Financing
Local advisors in the Optimhome network support buyers, owners, and sellers at every stage, including the financing setup.
They can direct you to a specialist broker who will negotiate suitable terms and analyze insurance offers to secure the most competitive interest rate.
An Optimhome advisor helps interpret your amortization schedule and estimate potential savings in case of a mortgage renegotiation.
Seeking professional help gives you experienced guidance and saves time to secure your financing.
Conclusion
The amortization schedule is the essential tool to track the split between principal, interest, and insurance.
It lets you anticipate monthly payments, remaining principal, and total repayments.
Understanding the principal/interest split helps you decide the right moment for early repayment or renegotiation.
Online simulators make it easy to run scenarios and compare offers.
Insurance delegation, renegotiation, or refinancing are concrete levers to lower borrowing costs.
Keeping and regularly checking your schedule prevents errors and ensures debits match the timetable.
For personalized support with your real-estate project and financing, contact your local Optimhome advisor.
FAQ
What’s the monthly payment for €200,000 over 25 years?
For a €200,000 loan over 25 years at around 3.8%, the payment excluding insurance is generally between €1,000 and €1,100, depending on the exact rate and insurance.
What’s the monthly payment for €140,000 over 25 years?
For a €140,000 loan over 25 years at a similar rate range, the payment excluding insurance is about €700 to €800, adjusted for the exact rate and insurance.
How do I amortize my mortgage?
A loan amortizes through monthly payments that cover interest and principal. The amortization schedule shows, month by month, the principal repaid and the remaining balance.
Where can I find a mortgage amortization schedule?
The bank provides it with the loan offer; it’s also available in your online client area or can be generated via free simulators.
How do I make an amortization schedule for a mortgage?
You can build one in a spreadsheet by entering the loan amount, term, and rate, or use an online simulator to get a reliable timetable.
How is a mortgage calculated?
A mortgage calculation rests on three key elements: loan amount, interest rate, and term. From these, a constant-annuity formula or simulator gives the monthly payment. This reveals the total cost, including interest and insurance.
How does mortgage amortization work?
Amortization splits each payment between interest and principal. Over time, the interest portion shrinks while the principal portion grows. A schedule lets you visualize this evolution month by month.
How do you calculate a mortgage monthly payment?
It depends on the loan principal, term, and interest rate. Use a simulator or a constant-annuity formula to obtain the amount excluding insurance. Include borrower’s insurance to know the total payment.
What’s the best mortgage rate today?
The best rate depends on your profile, loan term, and market conditions. In 2025, observed average rates vary roughly between 2.7% and 3% depending on term. A broker or an Optimhome advisor can help you find the most competitive rate for your case.
How is mortgage interest calculated?
Interest is calculated each month on the remaining principal. As principal drops, you pay less interest. The formula uses the nominal yearly rate divided by 12 (for monthly payments) multiplied by the remaining principal. Your schedule details this.
What is a mortgage repayment timetable?
It’s the amortization schedule provided by the bank, detailing, month by month, the split between principal, interest, and insurance. It lets you track your repayment and anticipate upcoming installments.
Can you create an amortization schedule in Excel?
Yes. Use financial formulas like PMT, IPMT, and PPMT to generate a custom timetable, visualize principal evolution, and adjust easily when loan terms change.
How is the APR (TAEG) of a mortgage calculated?
The APR includes all loan costs: nominal rate, mandatory insurance, application and guarantee fees. It enables objective comparison of offers. Calculations are complex, but simulators include these components to display the APR automatically.
What is a loan repayment schedule?
It’s another name for the amortization schedule. It shows each monthly payment, the interest portion, the principal repaid, and the remaining balance—essential for tracking your loan over time.
How do I run a 180-month loan simulation?
Use an online tool: enter the principal, interest rate, and 180-month term. The simulator computes the monthly payment and total cost, making it easy to compare durations.
What is a constant-annuity simulator for?
It computes a fixed monthly payment over the entire term, based on principal, rate, and term, and generates a full amortization schedule—the standard tool for fixed-rate amortizing loans.
Is there a simulator to increase a mortgage monthly payment?
Yes. Some tools simulate payment modulation, including increasing monthly payments to shorten the term and reduce total interest. Check your contract to see if your bank allows this option.
How do you calculate repayments with a deferred-payment loan?
With deferral, you initially repay interest only, or nothing at all (full deferral). The calculation includes a deferred phase followed by standard amortization. Specialized simulators can assess the impact on term and total cost.
What’s the point of an amortization schedule for tracking remaining principal?
It shows the remaining balance at every installment. It helps you track progress and estimate the impact of an early repayment—key for managing your loan and planning medium-term actions.
Author of the Publication
Fabrice DOBROWOLSKI, Network Development Director at Optimhome
“Benefit from my expert advice, based on many years of experience in the real estate sector, to ensure the success of your buying or selling project.”
