Mortgage Calculator
Advanced mortgage calculator with amortization schedule.
A mortgage is the biggest loan most people ever take, so understanding it matters. This free Mortgage Calculator works out your monthly repayment from the loan amount, interest rate and term, and shows how much goes to interest versus principal over the life of the loan — so you can compare options and plan with confidence.
How to use it: enter the loan amount, interest rate and term, and the calculator shows your monthly payment, total interest and an amortisation view. Change the inputs to compare rates, terms or deposit sizes before you commit.
Key features
- Calculate monthly repayment
- Interest vs principal over time
- Amortisation view
- Compare rates and terms
- Works in Excel and Google Sheets
This template is designed for professionals and teams working in Real Estate & Property who want to manage Buying & Selling tasks efficiently in Microsoft Excel — without the need for expensive specialist software.
The Mortgage Calculator is part of our Real Estate & Property collection — downloaded 5 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is it free?
Yes, free download with no sign-up.
What do I need to enter?
Loan amount, interest rate and term.
Does it show total interest?
Yes, plus an amortisation breakdown.
Is it editable?
Fully editable in Excel or Google Sheets.