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.
What is amortization?
Amortization is an accounting method for spreading out a loan into a series of fixed payments. Part of each payment goes toward the loan principal, and part goes toward interest.