The IPMT Function in Excel determines the interest component of a loan payment, assuming a fixed interest rate throughout the borrowing period. How to Use IPMT Function in Excel? The Excel “IPMT” function calculates the periodic interest payments owed to a lender by a borrower on a loan, ...