Skip to content
Google Sheets

ISPMT function in Google Sheets

The ISPMT function calculates the interest paid during a particular period of an investment. .

=ISPMT(rate, period, number_of_periods, present_value)

ISPMT syntax and parameters

Four arguments, four required.

  • ratenumberRequired
  • periodnumberRequired
  • number_of_periodsnumberRequired
  • present_valuenumberRequired

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 Excel

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 Google Sheets gets this done.