# IPmt

The IPmt function returns the interest portion of a periodic, constant payment for an investment or loan with a constant interest rate.

To determine the total payment, or how much is allocated to principal, use the Pmt and PPmt functions.

IPmt is part of the set of financial functions that Sigma supports.

## Syntax

`IPmt(rate, period, nperiods, pv, [fv], [type])`

The IPmt function has the following arguments:

rate
Required.
The interest rate for the loan.
period
Required.
Current payment period.
The valid range is 1 through `nperiods`.
nperiods
Required.
The total number of payments for the loan.
pv
Required.
The present value, or total value of all loan payments; the amount borrowed.
fv
Optional.
The future value, or a cash balance you want after the last payment is made.
Defaults to 0 (zero).
type
Optional.
When payments are due:
0
End of period
1
Beginning of period
Default is 0.

## Notes

• Be consistent with the units for rate and nperiods arguments. If you make monthly payments on a two-year loan at an annual interest rate of 7%, use the rate calculation of 0.07/12 and nperiods calculation of 2*12. For annual payments on the same loan, use the rate of 0.07 and nperiods of 2.

## Examples

`IPmt(.07/12,1,2*12,10000)IPmt(.07/12,2*12,2*12,10000)`

The first monthly interest payment for a loan of \$10,000, with an annual interest rate of 7% is \$58.33. The last (24th) interest payment is \$2.60.

`IPmt(.07,1,2,10000)IPmt(.07,2,2,10000)`

The first year's interest payment for a two-year loan of \$10,000, with an annual interest rate of 7% is \$700.00. The last payment (second year) has the interest payment of \$361.84. The first yearly payment for a loan of \$100,000, with an annual interest rate of 10% over 30 years, compounded yearly, has the interest payment of \$10,000.00. The last payment (year 30) has the interest payment of \$964.36.