Formualizer Docs
ReferenceFunctionsFinancial Functions

PPMT

PPMT: Returns the principal component of a payment for a specific period.

Summary

PPMT is computed as PMT - IPMT using the same rate, timing, and sign convention.

Remarks

  • rate is the interest rate per payment period.
  • per is 1-based and must satisfy 1 <= per <= nper.
  • Cash-flow sign convention: with a positive borrowed pv, principal components are usually negative.
  • type = 1 means beginning-of-period payments.
  • 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

How is PPMT computed?

PPMT is computed as PMT - IPMT for the same rate, per, nper, pv, fv, and type.

Runtime metadata

Category

Financial

Signature

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

PMT

PMT: Calculates the constant payment amount for a fixed-rate annuity or loan.

PRICE

Returns clean price per 100 face value for a coupon-paying security.

On this page

SummaryRemarksExamplesRelated functionsFAQHow is PPMT computed?Runtime metadata