Skip to content
Excel

ISPMT function in Excel

Calculates the interest paid during a specific period of an investment

=ISPMT(rate, per, nper, pv)

ISPMT syntax and parameters

Four arguments, four required.

  • ratenumberRequired

    Required. The interest rate for the investment.

  • pernumberRequired

    Required. The period for which you want to find the interest, and must be between 1 and Nper.

  • npernumberRequired

    Required. The total number of payment periods for the investment.

  • pvnumberRequired

    Required. The present value of the investment. For a loan, Pv is the loan amount.

ISPMT examples

Formulas you'll actually reuse.

  1. Interest for period 1 on a loan with EQUAL principal payments (not an annuity):

    =ISPMT(5%/12, 1, 360, 250000)

    Result-1038.77

  2. Half-way through, the interest has halved with the balance:

    =ISPMT(5%/12, 180, 360, 250000)

    Result-520.83

ISPMT in Google Sheets

Same name — your formula ports as-is.

Try ISPMT in the playground

Edit the example — nothing to install.

Preloaded with the ISPMT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.