ISPMT
Description
Returns the interest payment during the specified period, based on a constant interest rate and regular payments.
Syntax
ISPMT(
rate
,
per
,
nper
,
pv
)
- 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.