Excel mortgage amortization template
Download free this Excel template with a complete mortgage amortization table: principal, interest and payment per month.
Direct download, no sign-up or email required.
When should you use this calculator?
This template contains an example of €200,000 over 30 years at 3% rate (French system, standard in Spain). You'll see month by month how much principal is outstanding, how much interest you pay, how much principal and the total payment.
How it is calculated
You can change the initial principal, interest rate or number of months to adapt the table to your actual mortgage. Calculation formulas are automatic, so just update the input values at the beginning and the table regenerates itself.
Practical tips
This table is useful for understanding how each payment is split between interest and principal (at first you pay mostly interest, at the end mostly principal), and to simulate early payments (the outstanding principal recalculates and future interest decreases).
Other calculators you may find useful
If you found this calculator useful, you might also want to check out:
Frequently asked questions
Why do I pay more interest at the beginning than at the end?
Because interest is calculated on the outstanding principal. With the French system (fixed payment), at first almost everything goes to interest because principal is at its maximum; as you pay principal, the balance decreases and next payment's interest also decreases.
How do I simulate an early payment?
If you pay an extra amount in a month, change the outstanding principal in that row to a lower amount (what would remain after the extra payment) and the table recalculates automatically for the rest of the months.