The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. ... An Insert Function dialog box will open.

Enter "=PMT(A1/12,A2*12,A3)-A4-A5/12" in cell A6 to calculate your monthly payment. The result appears parenthesized and red, which indicates a negative value, or cost. Advertisement ...