Home › Functions › Financial › PMT
fx
PMT
Financial  ·  Since: Excel 2003  ·  9 languages

PMT , one of the financial functions , calculates the payment for a loan based on constant payments and a constant interest rate.

🌐 Translations

English PMT
Deutsch RMZ
Français VPM
Español PAGO
Italiano RATA
Português PGTO
Nederlands BET
Polski PMT
Русский ПЛТ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

PMT(rate,nper,pv,[fv],[type])

Arguments

rate (required) — The interest rate for the loan.
nper (required) — The total number of payments for the loan.
pv (required) — The present value, or the total amount that a series of future payments is worth now; also known as the principal.
fv (optional) — The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
type (optional) — The number 0 (zero) or 1 and indicates when payments are due.

▶ Examples

=PMT(A2/12,A3,A4)
=PMT(A2/12,A3,A4,,1)

Related functions

Copied to clipboard