Excel Function : ISPMT
Category
Financial
Description
Calculates the interest paid during a specific period of an investment
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ISPMT-function-fa58adb6-9d39-4ce0-8f43-75399cea56cc
Syntax and Description of the ISPMT Excel Function
The syntax for the ISPMT function in Microsoft Excel is: =ISPMT(rate, per, nper, pv) rate - The interest rate per period. per - The period for which you want to calculate the interest. nper - The total number of payment periods in the loan. pv - The present value of the loan.
About ISPMT Excel Function
ISPMT is an Excel function that calculates the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
