Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
IPMT(rate, period, number_of_periods, present_value,
The interest rate. For example: 2%.
The amortization period, in terms of number of periods. The period value must be equal or lower than the number of periods. For example: 1.
The number of payments to be made. For example: 360.
The current value of the annuity. For example: 400.
The future value remaining after the final payment has been made. For example: 0.
Whether the payments are due at the end (0) or beginning (1) of each period. For example: 0 or 1. The default type is 0.