Formualizer Docs
ReferenceFunctionsFinancial Functions

CUMIPMT

CUMIPMT: Returns cumulative interest paid between two inclusive payment periods.

Summary

Use this to total the interest component over a slice of an amortization schedule.

Remarks

  • rate is the interest rate per payment period.
  • start_period and end_period are 1-based, inclusive integer periods.
  • type must be 0 (end-of-period) or 1 (beginning-of-period).
  • Sign convention follows this implementation's balance model; with positive pv, cumulative interest is typically positive.
  • Returns #NUM! for invalid domain values (non-positive rate, invalid ranges, invalid type, or non-positive pv).

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

Are start_period and end_period inclusive in CUMIPMT?

Yes. Both bounds are inclusive and interpreted as 1-based periods after truncation to integers.

Runtime metadata

Category

Financial

Signature

CUMIPMT(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5: Number, arg6: Number)

Arity

min 6, max 6

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

ACCRINTM

ACCRINTM: Returns accrued interest for a security that pays interest at maturity.

CUMPRINC

CUMPRINC: Returns cumulative principal paid between two inclusive payment periods.

On this page

SummaryRemarksExamplesRelated functionsFAQAre start_period and end_period inclusive in CUMIPMT?Runtime metadata