Mortgage Amortization Schedule Calculator UAE
See how a UAE home loan is actually repaid: the split of every instalment between interest and principal, the balance year by year, what changes when the fixed rate ends and the loan reverts to EIBOR plus a margin, and what overpayments do to the schedule.
Run your numbers
Move a slider or type a figure, then press Build My Schedule. Your results appear below — free and instant.
Want this written up?
We will email you a personalised PDF with the full year-by-year schedule — interest, principal and balance for every year of the loan — plus your balance when the fixed rate ends and the effect of any overpayments, with your name on it.
What the Mortgage Amortization Schedule Calculator does
A payment calculator gives you one number. This one shows what happens to that number over the life of the loan: how much of each instalment is interest and how much actually reduces what you owe, what the balance is at the end of every year, and when the loan is finally cleared. It is the table a bank holds on its system for your account, built from the same inputs.
It is built for the way UAE home loans really work. Most are fixed for one to five years and then revert to a follow-on rate of EIBOR plus a margin, at which point the bank recalculates the instalment on whatever is still owed. A schedule that assumes the opening rate lasts 25 years is wrong from the day the fixed period ends, so this one re-prices the loan at that point and carries the new instalment through the remaining years. It also shows what an extra payment each month or a single lump sum does to the balance and to the total interest.
- A year-by-year schedule: what you pay, the interest, the principal, the cumulative interest and the balance
- The first six instalments one by one, so you can see the interest and principal split move
- Your instalment during the fixed period and after it, and the balance you owe when the rate changes
- Total interest and the total of all payments over the loan
- The year principal overtakes interest, and the year half the loan is repaid
- Interest and time saved by a monthly overpayment or a one-off lump sum
The key variables that move the schedule most — and how UAE banks treat them
A schedule has only a handful of moving parts. Each one changes the shape of the whole table, and a bank looks at each of them through its own rules.
- Loan tenor — the biggest driver of total interest. The same loan over 20 years instead of 25 carries a higher instalment and a much lower interest bill, because the balance comes down faster from the first month. The Central Bank caps home loan tenors at 25 years, and banks generally want the loan repaid by age 65 for a salaried expat or 70 for a UAE national or a self-employed borrower.
- Fixed rate — sets the instalment and the split between interest and principal for the first one to five years. In the early years most of each instalment is interest, so the opening rate decides how much of the loan you have actually repaid by the time the fixed period ends.
- Follow-on rate — the rate for every year after the fixed period unless you switch. It is a benchmark, usually 3-month EIBOR, plus the margin in your offer letter. On a 25-year loan with a three-year fixed rate it governs 22 of the 25 years, which is why it shapes the total interest far more than the headline rate does.
- Overpayments — banks treat any payment above the instalment as partial settlement. They can charge up to 1% of the amount prepaid, capped at AED 10,000, and many allow a portion of the balance each year without a fee. The allowance is bank policy, so read it in your offer letter rather than assuming it.
- When the money lands — an overpayment in year one works for the whole remaining tenor; the same amount in year fifteen has far less interest left to save. Timing matters almost as much as the amount.
How a UAE home loan schedule is actually calculated
A UAE home loan is a reducing-balance loan repaid in equal monthly instalments. Each month the bank charges one-twelfth of the annual rate on the balance outstanding, and whatever is left of the instalment reduces that balance. Next month the interest is charged on a slightly smaller figure, so a slightly larger share of the same instalment goes to principal. That is the whole mechanism; the schedule is just that step repeated for every month of the tenor.
Take an AED 1,600,000 loan at 3.99% over 25 years. The instalment is AED 8,436.56. In the first month the interest is AED 5,320.00 and only AED 3,116.56 comes off the loan. After three years of instalments you have paid AED 184,739 in interest and still owe AED 1,481,023.
When the fixed period ends the bank re-prices the loan: it takes the balance at that date and the months remaining, and works out a new instalment at the follow-on rate. At 5.89% the instalment on that example becomes AED 10,020.44, and total interest over the 25 years comes to AED 1,349,113 rather than the AED 930,967 a schedule that never re-prices would show. Islamic home finance follows the same arithmetic: the bank earns a profit rate rather than interest, and the instalments and balances are identical for the same rate and tenor.
- Monthly rate: i = r ÷ 12
- Instalment: P × i ÷ (1 − (1 + i)^−N), where P is the loan and N the number of months
- Each month: interest = balance × i; principal = instalment − interest; new balance = balance − principal
- At the end of the fixed period the instalment is recalculated on the remaining balance and the remaining months at the follow-on rate
- An overpayment comes straight off the balance. In this schedule an overpayment made during the fixed period also lowers the instalment the bank sets at re-pricing, and regular overpayments finish the loan early
What you get, and how banks use these numbers
A schedule is a planning tool rather than an approval tool, but several of its figures are the same ones a bank works from when you apply, switch or settle.
- Monthly instalment — the figure that goes into your debt burden ratio. Every monthly commitment, including 5% of each credit card limit, must stay within 50% of gross monthly income, and banks test it at a rate above the one you will pay.
- Instalment after the fixed period — the number to hold against your budget. It is the instalment you will pay for most of the loan unless you move to a new fixed rate.
- Balance at the end of the fixed period — what a new bank would take over in a buyout, and the figure your early settlement fee is worked out on: 1% of it, capped at AED 10,000.
- Balance in any given year — together with a current valuation it tells you your equity, which decides how much a bank could release against the property and whether a refinance fits within the loan-to-value cap.
- Total interest — no bank underwrites against it, but it is the clearest way to compare a shorter tenor, a bigger down payment or a habit of overpaying against the tighter monthly budget each one needs.
Using your results well
Build the schedule once with no overpayments so you have a baseline. Then change one thing at a time: a shorter tenor, a follow-on rate one point higher, an extra payment each month. Comparing the total interest and the balance at the end of the fixed period across those runs tells you which lever is worth pulling.
Be clear about what the later years are. Everything after the fixed period is calculated at the follow-on rate you entered, held constant. In practice that rate resets with EIBOR, and most borrowers move to a new fixed rate — with their own bank or another — when the first one ends, so the real schedule is rebuilt every few years. Treat the first fixed period as firm and the rest as the path you are on if nothing changes. The schedule also leaves out life and property insurance, which the bank usually collects alongside the instalment.
- Run the schedule with and without overpayments and compare the total interest
- Check your partial settlement allowance and fee before setting up a regular overpayment
- Note the balance at the end of the fixed period — it is the number every buyout quote starts from
- Re-run the schedule with the follow-on rate a point higher to see how exposed the later years are
- Use the report button for the full table to keep with your offer letter
Questions people ask about this calculator
Why is so much of my instalment interest in the early years?
Because interest is charged each month on the full balance outstanding, and at the start the balance is at its highest. On an AED 1,600,000 loan at 3.99% over 25 years, AED 5,320.00 of the first AED 8,436.56 instalment is interest. The share falls every month as the balance comes down.
What happens to my schedule when the fixed rate ends?
The bank recalculates the instalment on the balance you still owe and the months remaining, at the follow-on rate in your offer letter — normally 3-month EIBOR plus a fixed margin. If that rate is higher than your fixed rate the instalment rises and more of it goes to interest again. This calculator shows the new instalment and the balance at that point.
Can I overpay my mortgage in the UAE?
Yes. Banks treat an overpayment as partial settlement. They can charge up to 1% of the amount prepaid, capped at AED 10,000, and many allow a portion of the balance to be repaid each year without a fee. The allowance differs from bank to bank, so check your offer letter before you set up regular overpayments.
Is a flat rate the same as a reducing rate?
No. A flat rate is charged on the original loan for the whole tenor, so the true cost is roughly double what the number suggests. UAE home loans are quoted on a reducing-balance basis, where interest is charged only on what you still owe. This schedule uses the reducing-balance method.
Does Islamic home finance have an amortization schedule?
It has a payment schedule that works out the same way. Under Ijara or Murabaha the bank earns a profit rate rather than interest, and each instalment is split between profit (or rent) and the amount that reduces what you owe. For the same rate and tenor the monthly figures match a conventional loan.
Related calculators
Put a real rate behind these numbers
Every figure this calculator produces moves with the rate you type, so start from today's UAE mortgage rates rather than a headline from an advert. Pricing runs on three shelves — UAE nationals, resident expats and non-residents — and the shelf you sit on decides which rates are actually open to you. A fixed rate holds for one to five years and then reverts to EIBOR plus the bank's margin, so compare the follow-on rate as well as the first one.
Then look at the move you are making: buyout rates if your fixed period is ending and you could switch bank, refinancing or equity release if you are borrowing against a home you already own, Islamic home finance if you want a Sharia-compliant structure, and first-time buyer mortgages or a pre-approval on a purchase.
Want these numbers against real bank pricing?
Send us the file and a mortgage adviser comes back with what is actually available to you — not an advertised rate you may never qualify for.
