IPmt returns a Number specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
PPmt returns a Number specifying the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.