This Excel template calculates your mortgage. Just fill out the left side on top of the table and the rest will calculate automatically.
For everyone planning to buy a house or flat, this is a really important calculation.
Click here to go directly to the download.
Don’t be too optimistic with your financial income. What if you lose your job, what if you have to sell the house because you have to move to another place because of your work?
Do you have some extra-money for some unexpected repairs? Don’t forget, that you might need some money for an illness or operation. What about making holidays or paying the college for the children?
There are many aspects that should be respected – but to be honest – an own house is fantastic 🙂
So here is the Excel template for the mortgage calculation.
Screenshot and Function of the Mortgage Calculation with Excel
- Download and open the Excel file
- Put your data in the top left
- Loan amount
- Interest rate
- Number of years
- Number of payments per year
- Start date
- The rest will be calculated
- Down below you see all the future payments with interest paid and remaining balance
- The list is scrollable with a fixed top with all important data
Download the Excel Template with Mortgage Calculation
If you like my templates, I’m looking forward to a little donation 🙂
You can find other Excel Templates for Calculating your Mortgage here:
- Vertex24 presents some Excel templates for calculate your mortgage
- Excelfunctions.net has an Excel Mortgage Calculator, too
Or do it online without Excel on these sites:
