Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: ISPMT function

ISPMT function: Description, Usage, Syntax, Examples and Explanation

What is ISPMT function in Excel? ISPMT function is one of the Financial functions in Microsoft Excel that calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. Syntax of ISPMT function ISPMT(rate, per, nper, pv) The ISPMT function syntax has the following arguments: Argument Description Rate Required. The interest rate for…