Formualizer Docs
ReferenceFunctionsFinancial Functions

PMT

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

Summary

Use this to solve for periodic payment size when rate, term, and present/future value targets are known.

Remarks

  • rate is the interest rate per payment period (for example, annual rate / 12 for monthly payments).
  • Cash-flow sign convention: cash paid out is negative and cash received is positive.
  • type = 0 means end-of-period payments; type != 0 means beginning-of-period payments.
  • Returns #NUM! when nper is zero.
  • Propagates argument conversion and underlying value errors.

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 PMT usually negative for a loan?

TVM sign convention treats cash you pay as negative; with positive pv, payment outputs are typically negative.

Runtime metadata

Category

Financial

Signature

PMT(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5…: Number)

Arity

min 3, 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

Caps

PURE

Source

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

NPV

NPV: Calculates net present value for equally spaced cash flows.

PPMT

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhy is PMT usually negative for a loan?Runtime metadata