Learn How to UseMicrosoft Excel ISPMT Function

Microsoft Excel ISPMT Function

The main purpose of the Microsoft Excel ISPMT function is to get the interest paid for the specific period. That implies, with the help of ISPMT function you can able to calculate the interest paid during a given period of an investment where principal payments are equal. The given period is specified as a zero-based number instead of a 1-based number. So, with the help of ISPMT function, you can able to get the interest paid for the specific period.

Return Value of ISPMT Function

The return value will be the interest amount in a given period. 

Syntax of ISPMT Function

=ISPMT(rate, per, nper, pv)

Where the arguments:

• rate: This is the interest rate.
• per: This is a period starting with 0, not 1.
• nper: This is the number of periods.
• pv: This is the present value.

How to Use Microsoft Excel ISPMT Function?

So we know that Microsoft Excel ISPMT function you can able to get the interest paid for the specific period. That implies, with the help of the ISPMT function you can able to calculate the interest paid during a given period of an investment where principal payments are equal. The given period is specified as a zero-based number instead of a 1-based number. So, with the help of the ISPMT function, you can able to get the interest paid for the specific period.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel