Formulas > =PMT()
How to Use PMT() in Google Sheets
Description
How To Actually Use PMT() in Sheets
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
Try PMT yourself
Use the PMT function to calculate the monthly payment for a loan based on an interest rate in cell A1, the number of payments in cell A2, and the loan amount in cell A3. The result should be displayed in cell B1.
Hints (3)
-
Remember to convert the annual interest rate to a monthly rate.
-
The number of periods should reflect the total number of monthly payments.
-
Ensure the loan amount is entered as a negative value to get a positive payment result.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the PMT() formula:
Generate a PMT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PMT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PMT() formula