Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

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.