Financial

PMT function

Periodic payment of a loan or annuity. PMT works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=PMT(rate, nper, pv, [fv], [type])
ArgumentUse
raterequired
nperrequired
pvrequired
fvoptional
typeoptional

Example

Monthly payment on a 20,000 loan at 5% over 36 months.

fx=ROUND(PMT(0.05/12, 36, -20000), 2)
ABCDEF
1OrderCustomerRegionStatusAmountDate
2#1001Acme LtdNorthPaid12002026-01-14
3#1002Blue FoxSouthOpen4502026-01-20
4#1003Acme LtdNorthPaid9802026-02-03
5#1004Cedar & CoEastOverdue23002026-02-11
6#1005Blue FoxSouthPaid6102026-03-02
7#1006Delta BVWestOpen17502026-03-09
8599.42

Result computed by the Sheets formula engine.

On live data

In Sheets, PMT sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

Try it in a free calculator

Credit card interest calculatorSee the interest on a credit card balance this month, how many months your payment takes to clear it, and the total interest, with the formulas behind each number..

More financial functions

ACCRINTAccrued interest of a periodic-interest bondACCRINTMAccrued interest paid at maturityAMORDEGRCFrench degressive depreciation of a periodAMORLINCFrench linear depreciation of a periodCOUPDAYBSDays from coupon period start to settlementCOUPDAYSDays in the coupon period of settlementCOUPDAYSNCDays from settlement to the next couponCOUPNCDNext coupon date after settlementCOUPNUMCoupons payable up to maturityCOUPPCDPrevious coupon date before settlementCUMIPMTInterest paid between two periodsCUMPRINCPrincipal paid between two periods

All 55 financial functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations