Returns the interest payment for a given period for a constant payment loan or the periodic savings for a future balance.
Category: | Financial |
specifies the interest rate per payment period.
specifies the payment period for which the interest payment is computed. period must be a positive integer value that is less than or equal to the value of number-of-periods.
specifies the number of payment periods. number-of-periods must be a positive integer value.
specifies the principal amount of the loan. Zero is assumed if a missing value is specified.
specifies the future amount. future-amount can be the outstanding balance of a loan after the specified number of payment periods, or the future balance of periodic savings. Zero is assumed if future-amount is omitted or if a missing value is specified.
specifies whether the payments occur at the beginning or end of a period. 0 represents the end-of-period payments, and 1 represents the beginning-of-period payments. 0 is assumed if type is omitted or if a missing value is specified.
InterestPaid1 = IPMT(0.1/12, 1, 36, 8000);