Loan payment

PMT.

  • Snippet
  • Maths and finance
  • 3 blanks to fill

Fill in the blanks

Your text

=PMT(Annual rate/12, Months, -Loan amount)

Orange words are blanks you have not filled yet.

About this template

PMT.

Pack
Maths and finance
Type
Snippet, a short message
Asks for
Annual rate, Months, Loan amount

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

Template source

The template as written, with its blanks in double braces, such as {{Name}}.

=PMT({{Annual rate}}/12, {{Months}}, -{{Loan amount}})

More spreadsheet formulas templates

See all 75 spreadsheet formulas templates