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.

Use your Excel spreadsheet to verify that all of the monthly payments are accurately reflected once the software has loaded your information.