This example uses the Pmt function to return the payment for a loan over a fixed period. Given are the interest percentage rate per period (APR / 12), the total number of payments (TotPmts), the present value or principal of the loan (PVal), the future value of the loan (FVal), and a number that indicates whether the payment is due at the beginning or end of the payment period (PayType).
Pmt([APR] / 12, [TotPmts], -[PVal], [FVal], [PayType])