Functions
PMT
Periodic payment for a loan
Try it
When to use it
When should I use PMT instead of IPMT?
Use PMT for the full periodic payment; IPMT for just the interest portion.
Used in
finance · lending · real-estate
Syntax
PMT(rate, nper, pv)Examples
=PMT(0.05/12,30*12,100000) // => -536.8216230121399
=PMT(2,12,100) // => -200.00037633599277
=PMT(0.05/12,30*12,100000,0,1) // => -534.5941473979816