Excel functions / Financial

ISPMT function

The interest paid in a period of a loan that is repaid in equal amounts of principal, so the interest falls every period.

Syntax

=ISPMT(rate, per, nper, pv)

Arguments

When to use it

ISPMT gives the interest paid in one period of a loan that is repaid in equal amounts of principal each period, so that the payments shrink. PMT and IPMT are for the more common loan with equal payments. Periods count from 0.

Examples

  1. Interest in the second month of a three-year loan

    ABCDE
    1RateYearsLoan
    210%38000-64814.81

    In E2: =ISPMT(A2/12, 1, B2*12, C2*1000) → -64814.81

    Try this example

Common mistakes

ISPMT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try ISPMT in the playground

Related functions