Calculate Mortgage Loan Amortization with an Excel Template
Last updated on May 5th, 2024
If you need to calculate the Mortgage Loan amortization then this Excel template spreadsheet can be very helpful.
The spreadsheet is very simple to use, you just need to open Excel and then create a new workbook. Look for available templates and search for mortgage in the search box. This will show you the free Mortgage Amortization Schedule that is the free Excel template we are using here. Open it and after download from Office.com you will need to fill the required fields.
The inputs are Loan principal amount, annual interest rate, loan period in years and base year of loan plus base month of loan. After you fill the inputs then the spreadsheet will be populated and the key figures will show up.
Using this spreadsheet you can easily calculate your mortgage loan amortization and know exactly how much amount of money you will need to pay every month.
Go to Download Mortgage Loan Amortization Template for Excel – Unfortunately, this link is no longer available in Office.com