Formualizer Docs
ReferenceFunctionsFinancial Functions

ISPMT

ISPMT: Returns the interest paid on the outstanding principal for a specific period of an investment with even principal payments. Calculates interest paid in a per…

Summary

Unlike IPMT, ISPMT assumes the principal is repaid in equal installments so the interest portion decreases linearly over the life of the loan.

Remarks

  • rate is the interest rate per period.
  • per is 0-based period number (0 to nper - 1).
  • nper is the total number of payment periods; must be non-zero.
  • pv is the present value (principal).
  • Formula: pv * rate * (per / nper - 1).
  • The result is typically negative for a positive loan principal, representing interest paid.
  • Returns #NUM! when nper is zero.

Examples

Interest in the first period
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-479.1666666666667

FAQ

How is ISPMT different from IPMT?

ISPMT assumes equal principal repayment, so interest declines linearly instead of following an annuity schedule.

Runtime metadata

Category

Financial

Signature

ISPMT(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/tvm.rs

IRR

IRR: Calculates periodic internal rate of return for regularly spaced cash flows.

MIRR

MIRR: Calculates modified internal rate of return with separate finance and reinvest rates.

On this page

SummaryRemarksExamplesRelated functionsFAQHow is ISPMT different from IPMT?Runtime metadata