PMT

Formulas / PMT
To calculate periodic loan payments.
=PMT(rate, nper, pv, fv, type)
  • rate - interest rate of the loan
  • nper - total number of loan payments
  • pv - present value or principal (current total worth of a series of future payments)
  • fv - future value (cash balance at the end of the last payment)
  • type - 0 to indicate payments are due immediately, 1 to indicate payments are due at the end of the period, 0 by default

Examples

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

    This PMT function can be used to calculate monthly loan payments with terms given by arguments from A2:A4.

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

    If you need to calculate monthly loan payments with terms given by arguments from A2:A4 but with payments due at the beginning of the period, you can use the above formula.


Summary

The PMT function is a Sourcetable function for calculating loan payments. It works by using constant payments and a constant interest rate to determine the payment amount.

  • The PMT function determines payments for a loan, assuming both constant payments and a constant interest rate.
  • Note that the PMT function doesn't include taxes, reserve payments, or fees.
  • Be careful with units when using PMT. Make sure to use consistent units!

Frequently Asked Questions

What is the PMT function?
The PMT function calculates payments for a loan.
What type of payments does the PMT function use?
The PMT function uses constant payments.
What type of interest rate does the PMT function use?
The PMT function uses a constant interest rate.
What does the PMT return?
The PMT returns a payment that include principal and interest but excludes taxes, fees, and reserve payments.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV