The ISPMT function in Excel calculates the interest paid during a specific period of an investment or loan with even principal payments (not even total payments like with IPMT). In simple words:ISPMT gives you the interest portion for a given period assuming you pay back the principal evenly across the loan term.