ISPMT ( rate , per, nper , pv )

Description: Computes the interest paid during a specific period of an investment.

Arguments:

Name	Type	Description
rate	number	The interest rate for the investment.
per	number	The period for which the interest is to be found, and shall be in the range 1–nper.
nper	number	The total number of payment periods for the investment.
pv	number	The present value the investment.

Arguments representing cash paid by investor shall be expressed as negative numbers; arguments representing cash received by the investor shall be expressed as positive numbers.

Return Type and Value: number – The interest paid during a specific period of an investment.

[Example:

ISPMT(0.1/12,1,3*12,8000000) results in -64814.81
ISPMT(0.1,1,3,8000000) results in -533333.33

end example]