Formualizer Docs
ReferenceFunctionsFinancial Functions

IPMT

IPMT: Returns the interest-only component of a payment for a specific period.

Summary

Use this with PMT or PPMT to break a fixed payment into interest and principal pieces.

Remarks

  • rate is the interest rate per payment period.
  • per is 1-based and must satisfy 1 <= per <= nper.
  • Cash-flow sign convention: for a positive loan principal (pv), interest components are typically negative.
  • type = 1 yields zero interest in period 1 (annuity-due first payment).
  • Returns #NUM! when per is outside valid bounds.

Examples

Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null

FAQ

Why is IPMT period 1 equal to zero for type=1?

With beginning-of-period payments, the first payment occurs before interest accrues, so period-1 interest is zero.

Runtime metadata

Category

Financial

Signature

IPMT(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5: Number, arg6…: Number)

Arity

min 4, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

arg5

Number · Scalar · coercion NumberLenientText

arg6

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

FV

FV: Calculates future value from a fixed periodic rate and payment stream.

IRR

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhy is IPMT period 1 equal to zero for type=1?Runtime metadata