To calculate amortization you can use the Excel formula PMT. The PMT function calculates the monthly payment on a loan with the annual interest rate, number of payments, and principal balance for the loan.