PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
rate:
The interest rate for each period.
number_of_periods:
The total number of payment periods in an investment or loan.
present_value:
The current value of the loan or investment, or the total amount that a series of future payments is worth now.
future_value:
(Optional) The desired value after the last payment has been made. If omitted, it defaults to 0.
end_or_beginning:
(Optional) A value that indicates when payments are due. Use 0 if payments are due at the end of the period and 1 if they are due at the beginning. If omitted, it defaults to 0.
The PMT function in Google Sheets is a financial tool used to calculate the periodic payment for a loan based on constant payments and a constant interest rate. This function is particularly useful for individuals or businesses looking to understand their loan obligations, whether for mortgages, car loans, or any other type of financing.
In simpler terms, the PMT function helps you determine how much you need to pay each period to repay a loan over a specified term at a given interest rate.
Imagine you are considering taking out a loan for a new car:
You want to find out how much your monthly payment will be.
To achieve this, you would use the PMT function as follows:
=PMT(5%/12, 5*12, -20000)In this formula:
5%/12 is the monthly interest rate (annual rate divided by 12 months).5*12 is the total number of payments (5 years multiplied by 12 months).-20000 is the loan amount (entered as a negative value because it represents an outgoing payment).When you apply the PMT formula, the output will show the monthly payment amount:
| Loan Amount | Annual Interest Rate | Loan Term | Monthly Payment |
|---|---|---|---|
| $20,000 | 5% | 5 years | $377.42 |
This means you would need to pay approximately $377.42 each month to repay the loan over 5 years.
The PMT function is beneficial because it provides a straightforward way to calculate loan payments without needing to manually compute interest and principal components. It helps in budgeting and financial planning by giving a clear picture of monthly obligations.
The PMT function is an essential tool for anyone dealing with loans, providing clarity and ease in managing financial commitments.
Happy budgeting!
You have a table with loan amounts in Column A and interest rates in Column B. Use the PMT formula to calculate monthly payments in Column C by entering the loan amount, interest rate, and loan term. This helps employees understand their financial commitments easily.
Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis.
Browse our complete library of Google Sheets formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.