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.