Calculate Monthly Mortgage Payments in Excel Spreadsheet programs, such as Microsoft Excel and Google Sheets, include a payment function that can calculate the principal and interest on a mortgage.

What changing rates mean for monthly payments To understand just how much a change in rates could impact your budget, it’s important to understand how mortgage payments work.