ReferenceFunctionsFinancial Functions

FV

FV: Calculates future value from a fixed periodic rate and payment stream.

Summary

Use this to project an ending balance after compounding a present value and periodic payments.

Remarks

rate is the interest rate per period.
Cash-flow sign convention: payments you make are negative; receipts are positive.
type = 0 models end-of-period payments; type != 0 models beginning-of-period payments.
When rate is zero, result is linear (-pv - pmt * nper).
Returns argument-related errors if coercion fails or an input is an error value.

Examples

Example

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

null

Example

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

null

FAQ

What happens when `rate` is zero in `FV`?

It falls back to linear accumulation: -pv - pmt * nper with no compounding.

Runtime metadata

Category

Financial

Signature

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

EFFECT

Converts a nominal annual rate into an effective annual rate.

IPMT

IPMT: Returns the interest-only component of a payment for a specific period.

On this page

Summary Remarks Examples Related functions FAQ What happens when rate is zero in FV?Runtime metadata