Formulas > =PPMT()
How to Use PPMT() in Google Sheets
Description
How To Actually Use PPMT() in Sheets
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Try PPMT yourself
In cells A1 to A4, enter the interest rate (0.05), the period (1), the total number of periods (10), and the present value (1000). Use the PPMT formula in cell B1 to calculate the principal payment for the first period.
Hints (3)
-
Make sure to reference the correct cells for each argument.
-
Remember that the interest rate should be in decimal form.
-
The present value is the total amount of the loan or investment.
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
More related tutorials
Transcript-matched member videos for PPMT(). Click through to watch.
Write Apps Script to Create a New Google Sheets Formula
Learn more about the PPMT() formula:
Generate a PPMT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PPMT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PPMT() formula