ReferenceFunctionsFinancial Functions
PV
PV: Calculates present value from periodic cash flows at a fixed rate.
Summary
Use this to discount a regular payment stream and optional terminal value back to time zero.
Remarks
rateis the discount rate per period.- Cash-flow sign convention: inflows are positive and outflows are negative.
type = 0assumes payments at period end;type != 0assumes period start.- When
rateis zero, present value is computed with simple arithmetic (no discounting). - 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
Related functions
FAQ
How does type change PV?
type=0 discounts end-of-period payments, while non-zero type treats payments as beginning-of-period (annuity due).
Runtime metadata
Category
Financial
Signature
PV(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5…: Number)Arity
min 3, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
arg4Number · Scalar · coercion NumberLenientText
arg5Number · Scalar · coercion NumberLenientText
Caps
PURE
Source