Google Sheets reference

PMT in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Financialintermediate

=PMT(B1/12,B2*12,-B3)

Also in Excel

See the full PMT reference for Excel — including all worked examples, common errors, and FAQ.