Mortgage Amortization Planner
NEW!

Mortgage Amortization Planner

Plan mortgage overpayments with real day-count interest. Compare cutting the term vs the instalment, before vs after the rate review, and export to Excel.

Loans & Mortgages

Scenarios

The loan
Interest rate

Examples

Overpayments

No overpayments yet. Add one to see what it saves you.

Cost of buying the home

Payments made before the mortgage

Nothing recorded yet โ€” deposit, contract instalments, extras.

What the home costs you every month

Instalments you have really paid

Nothing recorded. Add real instalments and the schedule carries on from them.

Results

First instalmentโ€”
Total interestโ€”
Paid offโ€”
APR (TAE)โ€”
Instalments savedโ€”
Interest savedโ€”
True cost of the homeโ€”
Paid upfrontโ€”
Running costsโ€”
Per month, all inโ€”

Side by side

ScenarioInstalment InterestInstalments APRTrue total cost

Before or after the rate review?

Interest accrues on the real days you owe the money, and the lender resets your instalment from the balance it sees on the review date. Pick an amount and a date, and see what one day either side is worth.

Full schedule

#DateDays RateOpening balanceInterest CapitalOverpaymentInstalment Closing balance

Excel and CSV

Export a workbook you can keep editing by hand, fill in the instalments you really paid, and load it straight back in.

Your own schedule works too โ€” the columns are matched by name.

Keywords

mortgage amortization plannermortgage overpayment calculatorreduce term or reduce payment mortgagemortgage amortization schedule excelearly repayment mortgage calculatormixed rate mortgage calculator euribortrue cost of buying a home calculatormortgage schedule import excel

Need something else?

How to use

1

Enter the loan: amount borrowed, signing date, term in months, the day of the month you pay, and how your lender counts interest days. Real days over the real length of the year is the Spanish default.

2

Set the rate. Fixed takes a single TIN. Mixed asks how many months stay fixed before the variable stretch starts. Variable asks for the reference index, your spread over it, and how often the rate is reviewed.

3

Add overpayments. Each one takes a date, an amount, and whether it cuts the term or the instalment. Set a repeat interval to model something like one extra instalment every year.

4

Fill in what buying the home actually costs โ€” tax, notary, land registry, agency, appraisal, arrangement fee, down payment โ€” plus insurance, property tax, service charges and maintenance. The true total cost appears alongside the interest.

5

Use the timing panel to test a lump sum one day before, on, and one day after a date, then export the whole thing to Excel, record the instalments you really paid, and load the file back in.

Features

Interest on Real Days, Not Flat Months

Each period is charged on the actual number of days between payment dates, divided by the actual length of that year โ€” 366 in a leap year. That is how Spanish lenders bill, and it is why a 31-day month costs more than a 30-day one and why the date of an overpayment changes the result.

Cut the Term or Cut the Instalment

Every overpayment carries its own effect. Reduce the term and the instalment stays put while the loan ends sooner; reduce the instalment and the horizon stays put while every later payment shrinks. Run both as separate scenarios and read the difference in interest side by side.

Fixed, Mixed and Variable Rates

Model a flat TIN, a fixed opening stretch followed by index plus spread, or a variable loan reviewed every six or twelve months. Each review recalculates the instalment over the balance and the term still outstanding, exactly like a lender does.

The True Cost of the Home

Tax, notary, registry, agency and appraisal fees, the arrangement fee, the down payment and any payments made before signing are added to the interest and to years of insurance, property tax, service charges and maintenance โ€” with optional inflation on the running costs.

Excel In and Out

Download a workbook with a summary, editable parameter sheets and a full schedule per scenario, keep filling in the instalments you really paid, and load it straight back. A schedule you built yourself works too: the columns are matched by name in English and Spanish.

Why Choose This Tool?

Everything Runs in Your Browser

Your loan balance, your salary-sized instalments and the ledger of what you have already paid never leave your device. There is no account, no upload and no server-side processing โ€” the schedule, the comparison and the Excel file are all built locally in JavaScript. That also means it keeps working with a bad connection and loads instantly.

It Bills Interest the Way a Lender Does

Most online calculators divide the annual rate by twelve and stop there. That is fine for a rough monthly figure, but it cannot tell you whether to overpay on the 19th or the 21st, because in that model every month is identical. This planner walks real dates, charges interest on the real days you owed the money, and recalculates the instalment on the review date from the balance the lender actually sees.

It Answers the Question You Are Actually Asking

Not 'what is my instalment' โ€” you already know that. The useful questions are whether cutting the term beats cutting the instalment, what one extra payment a year is worth over thirty years, whether a lump sum should land before or after the review, and which of two offers costs less once fees and required insurance are counted. Each of those has its own panel.

It Keeps Working After the First Month

A mortgage is not a one-off calculation. Record the instalments and overpayments that really happened and the schedule recomputes from them, so the projection stays honest as reality drifts from the plan. Export to Excel, keep the file with your paperwork, add the next few months by hand, and load it back whenever you want to re-run the analysis.

How Mortgage Interest Is Really Charged, and Why the Date of an Overpayment Matters

The instalment and the interest are two different calculations

A French-system mortgage โ€” the standard in Spain and most of continental Europe โ€” has a level instalment. It is fixed once, from the amount borrowed, the nominal annual rate (TIN) and the number of payments, using the annuity formula. Nothing about that formula knows what a calendar looks like: it divides the annual rate by twelve and assumes every period is identical.

The interest actually charged in each period is a separate calculation, and it does look at the calendar. The lender takes the outstanding balance, multiplies by the annual rate, and prorates it over the real number of days since the last payment, divided by the real length of that year. On a 250,000 โ‚ฌ balance at 2.85 %, a 30-day period inside a leap year costs 250000 ร— 0.0285 ร— 30 รท 366 = 584.02 โ‚ฌ, while the following 31-day period costs more even though the balance has gone down.

The instalment is what does not change; the split between interest and capital is what moves. Because the interest is deducted from a fixed instalment, everything the calendar does to the interest lands on the capital repaid. That is why two mortgages with the same headline numbers can end up hundreds of euros apart, and why a schedule built on 'rate divided by twelve' quietly disagrees with the one your bank sends you.

Cutting the term versus cutting the instalment

When you repay capital early, Spanish lenders let you choose what the money buys. Cut the term and your instalment stays exactly where it is, so the same monthly payment now covers less interest and more capital, and the loan simply ends earlier. Cut the instalment and the horizon stays where it is, but the payment is recalculated over the balance that remains and the payments still outstanding, so every month from then on is cheaper.

Cutting the term almost always saves more interest, and often by a wide margin, because it removes the most expensive periods โ€” the ones at the far end where you would still be paying interest on whatever balance was left. Cutting the instalment saves less in total but improves your monthly cash flow immediately, which matters if the household budget is tight or if you expect income to fall. Neither is universally right; the point of running both is to see the size of the trade-off before you commit.

Why one day either side of the rate review is not the same

Two separate mechanisms make timing matter, and they pull with different strengths.

The first is simply days of interest. Money you repay on the 5th stops accruing interest on the 5th; money you repay on the 20th accrues for fifteen more days. On a 20,000 โ‚ฌ overpayment at 3 %, that fortnight is worth roughly 25 โ‚ฌ โ€” small, but always in the same direction: earlier is never worse.

The second is the recalculation itself, and it is the bigger one. On a variable or mixed mortgage, the lender resets the instalment at each review from the balance it sees on that date. Land a lump sum before the review and the new instalment is computed on the reduced balance, so every payment for the rest of the loan is lower. Land it a day after and the instalment was already fixed on the higher balance; the overpayment still helps, but it is recalculated against a shorter remaining term, which changes the shape of the saving rather than simply increasing it. Depending on the rate direction and the mode you chose, the totals can come out surprisingly close โ€” which is exactly why the tool computes all three dates rather than repeating a rule of thumb.

What an early repayment is allowed to cost you

Spain's Ley 5/2019 caps the compensation a lender may charge for repaying early, and the cap depends on the type of rate. On a fixed-rate loan, or on the fixed stretch of a mixed one, the ceiling is 2 % of the capital repaid during the first ten years and 1.5 % afterwards. On a variable-rate loan the lender chooses one of two schemes when the contract is signed: 0.25 % during the first three years, or 0.15 % during the first five โ€” and nothing at all after that window closes. In every case the fee is also capped by the lender's actual financial loss, so it is frequently zero in practice. Check your deed for which scheme applies before assuming a number.

The instalment is not what the house costs

Interest is the largest single line, but it is not the only one. Buying costs tax โ€” ITP on a second-hand home, VAT plus stamp duty (AJD) on a new build โ€” along with notary, land registry, agency and appraisal fees, and sometimes an arrangement fee on the loan itself. Owning costs home insurance, usually life insurance if the lender required it, property tax (IBI), the service charge, and maintenance that averages out to a real number over thirty years even though it arrives in lumps. Adding all of it to the repayments is the only way to see what the home costs per month, all in โ€” a figure that is typically a third higher than the instalment alone.

Frequently Asked Questions

Why does this tool give a different schedule than my bank's?

Most likely because of the day count. This planner charges interest on the real days between payment dates over the real length of the year (365 or 366), which is the common Spanish convention. Some lenders use real days over a flat 360, which makes interest slightly higher, and some use flat 30-day months. Switch the day-count setting to match your deed and the numbers should line up. Small residual differences usually come from rounding rules or from insurance premiums bundled into the instalment.

Should I cut the term or cut the instalment?

Cutting the term nearly always saves more interest, because it deletes the last and most expensive periods of the loan. Cutting the instalment saves less overall but lowers your monthly outgoing straight away. The right answer depends on whether you value total savings or monthly breathing room. Load the same overpayment as two scenarios โ€” one of each โ€” and the comparison table shows exactly what the choice costs in euros, so you are trading a known amount of interest for a known amount of monthly relief.

Is it really better to overpay just before the rate review?

Earlier is always at least slightly better on pure interest, because you stop owing the money sooner. The bigger effect is the recalculation: on a variable or mixed loan the lender sets your new instalment from the balance on the review date, so a lump sum that lands before it lowers every payment that follows. Whether that also lowers your total interest depends on the mode you chose and on which way the rate moved, which is why this tool runs the day before, the day itself and the day after, and reports the actual numbers instead of a rule of thumb.

What does the tool count as the true cost of the home?

Everything you pay upfront (tax, notary, land registry, agency, appraisal, the arrangement fee, the down payment and any instalments paid before signing), plus everything you pay the lender across the life of the loan (capital, interest and early-repayment fees), plus the running costs of owning the property (home and life insurance, IBI, service charge and maintenance) over the same period, optionally growing with inflation. It is deliberately the widest sensible figure, because the instalment on its own badly understates what a home costs.

How is the APR (TAE) calculated here?

As the internal rate of return of the real cash flow: you receive the principal less the arrangement fee and the appraisal, then you pay every instalment, every overpayment, every early-repayment fee and the lender-required insurance premiums on their real dates. The monthly rate that makes those flows net to zero is compounded to an annual figure. That is why the APR sits above the nominal rate even with no fees at all โ€” monthly compounding alone lifts 2.85 % to about 2.89 % โ€” and rises further once fees and insurance are included.

Can I load my own spreadsheet?

Yes. If you load a workbook this tool produced, everything comes back exactly, including scenarios, rate segments, overpayments and both ledgers. If you load a schedule you built yourself, the columns are matched by name in English and Spanish โ€” date, opening balance, interest, capital, overpayment, instalment โ€” and the tool reconstructs the amount borrowed, the start date, the term, the rate segments and the overpayments it can find. Anything it had to assume is listed explicitly so you can correct it.

What is the difference between this and a mortgage calculator?

A mortgage calculator answers 'what would my instalment be' before you sign. This planner is for after you have signed: it tracks a loan you already hold, records the instalments and overpayments that really happened, and answers questions about what to do next โ€” overpay now or later, cut the term or the instalment, keep this loan or move to that offer. If you only need a monthly figure, use the calculator; it is faster.

Does any of my data leave the browser?

No. The schedule, the comparison, the timing analysis and the Excel file are all built in your browser with JavaScript. Nothing is uploaded, nothing is stored on a server, and there is no account. When you load a workbook it is read from your disk into memory and parsed locally; when you export one it is assembled locally and handed to your browser's download. Close the tab and nothing remains.

Can I model one extra instalment a year?

Yes โ€” add an overpayment for the amount of one instalment, set the repeat interval to 12 months, and leave the number of times blank to keep it running for the life of the loan. On a typical 30-year loan that single habit takes several years off the term and saves a five-figure sum in interest. Change the mode to cut the instalment instead and you will see the same money buy a steadily falling monthly payment rather than an earlier finish.

What if my mortgage has a fixed period and then goes variable?

Choose the mixed rate type. You give the fixed TIN, how many months it lasts, the reference index you expect afterwards, your spread over it, and the review interval. The tool builds one rate segment per review for the whole variable stretch, and recalculates the instalment at each one from the balance and the term still outstanding. Since nobody knows the future index, treat the variable years as a scenario: duplicate it, change the index, and compare.

Related Articles

Learn more