Formualizer Docs
ReferenceFunctionsFinancial Functions

NPV

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

Summary

The first cash-flow argument is discounted one period from the present, matching spreadsheet NPV behavior for periodic series.

Remarks

  • rate is the discount rate per period.
  • Cash-flow sign convention: investments/outflows are negative, returns/inflows are positive.
  • Non-numeric values are ignored; numeric values in arrays/ranges are consumed left-to-right.
  • Embedded error values inside provided cash-flow values are propagated as errors.
  • Returns argument coercion errors for invalid rate or direct scalar failures.

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

Is the first cash flow discounted at period 0 or period 1?

NPV discounts the first supplied cash flow one full period, matching spreadsheet NPV behavior.

Runtime metadata

Category

Financial

Signature

NPV(arg1: Number, arg2…: Any)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Any · Scalar

Caps

PURE

Source

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

NPER

NPER: Calculates the number of periods needed to satisfy a cash-flow target.

PMT

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

On this page

SummaryRemarksExamplesRelated functionsFAQIs the first cash flow discounted at period 0 or period 1?Runtime metadata