Formulas > =ISPMT()
How to Use ISPMT() in Google Sheets
Description
How To Actually Use ISPMT() in Sheets
ISPMT(rate, period, number_of_periods, present_value)
Try ISPMT yourself
In cells A1 to A4, enter the interest rate, the period number, the total number of periods, and the present value of an investment. Use the ISPMT formula in cell B1 to calculate the interest paid during the specified period.
Hints (3)
-
Make sure to enter the interest rate as a decimal.
-
The period number should be between 1 and the total number of periods.
-
Check that the present value is a negative number.
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 ISPMT(). Click through to watch.
Write Apps Script to Create a New Google Sheets Formula
Learn more about the ISPMT() formula:
Generate a ISPMT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ISPMT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ISPMT() formula