Calculate total payment amount (PMT formula) With all the known components in place, let's get to the most interesting part - loan amortization formulas.Ģ. In the Period column, enter a series of numbers equal to the total number of payments (1- 24 in this example):
The next thing you do is to create an amortization table with the labels ( Period, Payment, Interest, Principal, Balance) in A7:E7. Set up the amortization tableįor starters, define the input cells where you will enter the known components of a loan: Now, let's go through the process step-by-step. This amount increases for subsequent payments.
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
