ISPMT

ISPMT(arg1, arg2, arg3, arg4) → { number | string | boolean }

Returns the interest paid during a specific period of an investment.

Parameters:

Name Type Description
arg1 number

Interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

arg2 number

Period for which you want to find the interest.

arg3 number

Number of payment periods in an investment.

arg4 number

Lump sum amount that a series of future payments is right now.

Returns:

Type
number | string | boolean