IPMT

FINANCE.IPMT

FINANCE.IPMT(rate, period, periods, value, future_value = 0, end_or_start = 0)

Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

• rate: Interest rate.
• period: Amortization period, in terms of number of periods. Must be at least 1, and at most the value of periods.
• periods: The number of payments to be made.
• value: Current value of the annuity.
• future_value: Future value remaining after payment has been made.
• end_or_beginning: Whether payments are due at the end (0) or the beginning (1) of each period.