IPmt
This method specifies the interest payment for a specified period of an annuity based on periodic fixed payments and a fixed interest rate.
Syntax
financial.IPmt(rate, per, nper, pv, [fv], [type])
Parameters
- financial
- Reference to a Financial control.
- rate
- Required. Variant that specifies the interest rate per period.
- per
- Required. Variant that specifies the payment period in the range from 1 through nper.
- nper
- Required. Variant that specifies the total number of payment periods in the annuity.
- pv
- Required. Variant that specifies the present value, or value today, of a series of future payments or receipts.
- fv
- Optional. Variant that specifies the future value or cash balance after a final payment.
- type
- Optional. Variant that specifies when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.
Return Value
Result of the IPmt calculation.
Remarks
Calculate the rate and nper parameters using payment periods expressed in identical units. For all parameters, negative numbers represent cash paid out and positive numbers represent cash received.