FUNCTION CATALOGUE / FINANCIAL
PMT Excel function
Calculates a periodic loan payment.
Correct sentence to use
Calculate the payment for rate [rate], [periods] periods, and present value [amount].
Modify this query in PlainFormula →Example formula
=PMT(5%/12,60,10000)
Calculates a loan payment assuming constant payments and rate.
Syntax
PMT(rate, nper, pv, [fv], [type])
Argument signature: rate, nper, pv, [fv], [type]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.