Formulas > =PPMT()

How To Use PPMT() Function in Google Sheets


Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

Common Questions About the PPMT Formula:
  • What is the PPMT Formula?
  • What is the syntax for using the PPMT Formula?
  • What arguments does the PPMT Formula require?

How Can the PPMT Formula be Used Appropriately?
The PPMT Formula can be used to calculate the periodic payment for a loan or an annuity based on periodic, fixed payments and a fixed interest rate. It can also be used to calculate the amount of principal paid on a loan in a certain period.

How Can the PPMT Formula be Commonly Mistyped?
One of the most common mistakes is mistyping the parentheses and leaving them out or misspelling them when used in a formula. Another common mistake is missing a comma between arguments in the formula, also PMT and PPT.

What are Some Common Ways the PPMT Formula is Used Inappropriately?
Inappropriate use of the PPMT formula includes using it without all necessary input arguments, using the wrong interest rate, or using the wrong interest type (e.g. compound interest instead of simple).

What are Some Common Pitfalls When Using the PPMT Formula?
One common pitfall is using the wrong interest rate in the formula, which can lead to an incorrect result. Also, forgetting to include all the necessary arguments can result in an inaccurate answer.

What are Common Mistakes When Using the PPMT Formula?
Again, the most common mistakes include mistyping the parentheses, forgetting to include all necessary parameters, or forget to include the interest rate. Additionally, forgetting to adjust for compound interest can throw off the result.

What are Common Misconceptions People Might Have with the PPMT Formula?
Some common misconceptions that people have with the PPMT formula is that it can be used to calculate payments for any loan or annuity, and that the answer will be the same no matter the arguments used. However, it is important to remember that the PPMT formula requires the proper input arguments and interest rate for the formula to be used correctly.

How To Actually Use PPMT() in Sheets

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

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

Learn more about the PPMT() formula:

Google Sheets PPMT Function | Calculate Principal Component of Loan | Google Sheets Function

Use the Google Sheets PPMT function to calculate the principal part of a loan, for a specific month, if the same amount is repaid every month, for a fixed interest rate, for the entire tenure of the loan. For example, you can use PPMT to find out the principal amount remaining in the 11th month on a one-year loan.

Generate a PPMT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.