IPMT()
Syntax. IPMT(Rate,Per,Nper,Pv,Fv,Type)
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.
Arguments
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
