IPMT
Description
Returns the interest payment during the specified period, based on a constant interest rate and regular payments.
Syntax
IPMT(
rate
,
per
,
nper
,
pv
, [
fv
], [
type
])
- rate: The interest rate for each period.
- per: The period to calculate the payment for.
- nper: The total number of periods for the loan or investment.
- pv: The present value.
- fv: The future value.
- type: The payment timing. 0 or Empty = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.