Home › Functions › Financial › =PMT()
Financial All versions ◉ 15 views

=PMT()

How to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=PMT(rate, nper, pv, [fv], [type])
Hover argument names in the table for details.
Output typeNumber
Popularity60 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =PMT() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download PMT.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
rate Number Required The interest rate for the loan.
nper Number Required The total number of payments for the loan.
pv Number Required The present value, or the total amount that a series of future payments is worth now; also known as the principal.
fv Number 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 Number Optional The number 0 (zero) or 1 and indicates when payments are due. 0 or omitted = At the end of the period; 1 = At the beginning of the period.

▣ Examples

پرداخت ماهانه برای وامی با شرایط مشخص‌شده به عنوان آرگومان در A2:A4. =PMT(A2/12,A3,A4)
پرداخت ماهانه برای وامی با شرایط مشخص‌شده به عنوان آرگومان در A2:A4، با این تفاوت که پرداخت‌ها در ابتدای دوره سررسید می‌شوند. =PMT(A2/12,A3,A4,,1)

✦ Tips

  • The payment returned by PMT includes principal and interest but no taxes, reserve payments, or fees sometimes associated with loans.
  • Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12 percent for rate and 4 for nper.
  • Tip To find the total amount paid over the duration of the loan, multiply the returned PMT value by nper.

⇄ Related Functions

=EDATE() Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. =ROUND() The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78. =FV() FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. =IPMT() Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. =NPER() Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. =PPMT() Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.