PPMT function - gets the principal part of each payment that goes toward the loan principal, i.e.This amount stays constant for the entire duration of the loan. PMT function - calculates the total amount of a periodic payment.To build a loan or mortgage amortization schedule in Excel, we will need to use the following functions: How to create a loan amortization schedule in Excel
