Question: what is ispmt in excel?
Answer: The Microsoft Excel ISPMT function returns the interest payment for an investment based on an interest rate and a constant payment schedule. This function was created for backwards compatibility with Lotus 1-2-3. The ISPMT function is a built-in function in Excel that is categorized as a Financial Function.