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

The PMT function in Excel is a financial function used to calculate a loan's payment based on payments and interest rates. Learn How to use it.