The IPMT function in Excel calculates the interest payment for a given period of a loan or investment, based on constant periodic payments and a constant interest rate. In simple words: It tells you how much of your payment is just interest for a specific month or period.