|
<< Click to Display Table of Contents >> ISPMT (interest payment) |
Syntax:
ISPMT(Rate, Per, NPer, PV)
Description:
This returns the interest paid in the specified period for an investment with equal installments.
The function expects the following arguments:
Rate is the interest rate (per payment period)
Per is the payment period to be considered
NPer is the total number of payment periods
PV is the present value (initial amount)
See also: