Question: what is the formula behind pmt in excel?
Answer: The Excel PMT function is a financial function that returns the periodic payment for a loan. You can use the NPER function to figure out payments for a loan, given the loan amount, number of periods, and interest rate. rate - The interest rate for the loan. nper - The total number of payments for the loan.