Definition. This function determines the part of an annuity that is used for the interest payment of a loan that is repaid according to the principle of annuity repayment.
Rate (required) The nominal interest of the loan.
Per (required) The appropriate number for the desired period.
Nper (required) The total number of periods in which the loan is repaid.
Pv (required) The loan amount.
Fv (optional) Evaluates loans that have not been fully repaid after the total number of periods. Such an effect may happen when mortgages are disbursed with a fixed interest period.
Type (optional) Specifies whether the payments become interest effective at the start of the periods (M = 1) or at the end of the periods ...