Question: how is pmt calculated in excel?
Answer: Summary. ... 
Get the periodic payment for a loan.
loan payment as a number.
=PMT (rate, nper, pv, [fv], [type])
rate - The interest rate for the loan. ... 
The PMT function can be used to figure out the future payments for a loan, assuming constant payments and a constant interest rate.