How to Calculate Mortgage Payments (with Examples . . .
To calculate what your mortgage payments will be, type the payment, or PMT, function into a spreadsheet. You will be prompted to input your monthly interest rate, the number of payments during the loan period, and the principal on your loan. Once you have typed in these numbers, hit enter to get your monthly payment.