IPMT function
Summary
Returns the interest payment for an investment for a given period
Syntax
IPMT(rate, per, nper, pv, [fv], [type])
The IPMT function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Per Required. The period for which you want to find the interest and must be in the range 1 to nper.
• Nper Required. The total number of payment periods in an annuity.
• Pv Required. The present value, or the lump-sum amount that a series of future payments is worth right now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).
• Type Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.
0 | At the end of the period
1 | At the beginning of the period
• Rate Required. The interest rate per period.
• Per Required. The period for which you want to find the interest and must be in the range 1 to nper.
• Nper Required. The total number of payment periods in an annuity.
• Pv Required. The present value, or the lump-sum amount that a series of future payments is worth right now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).
• Type Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.
0 | At the end of the period
1 | At the beginning of the period
Example
=IPMT(A2/12, A3, A4*12, A5)
=IPMT(A2, 3, A4, A5)
=IPMT(A2, 3, A4, A5)