Formualizer Docs
ReferenceFunctionsFinancial Functions

CUMPRINC

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

Summary

Use this to measure principal reduction over a selected amortization window.

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 payment direction; with positive pv, cumulative principal is typically negative.
  • 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

Why is CUMPRINC often negative for loans?

With positive pv, payment cash outflows are negative in this convention, so cumulative principal is typically negative.

Runtime metadata

Category

Financial

Signature

CUMPRINC(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

CUMIPMT

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

DB

DB: Returns fixed-declining-balance depreciation for a specified period.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy is CUMPRINC often negative for loans?Runtime metadata