SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / ISPMT
In This Topic
    ISPMT
    In This Topic

    This function calculates the interest paid during a specific period of an investment.

    Syntax

    ISPMT(rate,per,nper,pv)

    Remarks

    This function has these arguments:

    Argument Description
    rate Interest rate for the investment.
    per Number of the period for which to find the interest, between 1 and nper.
    nper Total number of payment periods for the investment.
    pv Present value of the investment.

    Remarks

    Be consistent with the units for rate and nper.

    The cash you pay out is represented by negative numbers and the cash you receive by positive numbers.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    ISPMT(B1,C4,C5,1)

    ISPMT(R1C2,R4C3,R6C3,R7C3)

    See Also