deepcalc
DocsPMT

PMT

View as markdown/docs/functions/pmt.md Ask Claude about this pageOpens Claude with this page's address

Returns periodic payment for an annuity.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=PMT(0.05/12, 360, 100000)
Result -536.8216230121398

Syntax

PMT(rate, nper, pv, [fv], [type])
rate
number required
nper
number required
pv
number required
fv
number optional defaults to 0
type
number optional defaults to 0
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.