Use the following formulas to show the total payment, interest portion of the payment, and principal portion of the payment. Returns the payment per month reach a certain amount in the future, assuming constant payments and interest rate.Loan Payment Calculation. Construct a loan amortization schedule given the principal loan amount, periodic interest rate, and term (no. Of periodic payments) in Excel.