fx =PMT(0.05/12,360,250000)ABCLaptop$1,299$1,103.15Monitor$549$466.65Keyboard$179$152.15
💰 Financial

PMT Formula for Financial

Calculate loan payment amount. Copy-paste ready for Excel, Google Sheets, and Airtable.

=PMT(0.05/12,360,250000)
When you need this: When you need to calculate a mortgage payment: 5% annual rate, 30-year (360-month) loan, $250K principal.

How it works

  1. 1Specify the interest rate per period (0.05/12 = monthly 5% annual).
  2. 2Total periods (360 months = 30 years).
  3. 3Loan principal amount (250000).
  4. 4PMT returns the fixed monthly payment amount.

Variations

Car loan example
=PMT(0.06/12,60,25000)
PMT with future value
=PMT(0.05/12,360,250000,0)

Related Formulas

FV — Calculate future value of an investmentFinancialSUM — Add up a range of numbersMathAVERAGE — Calculate the average of a rangeStatisticalIF — Return different values based on a conditionLogic

Need a formula that's not here?

Generate custom formula →