PV

Calculates the Present Value.

Variants

PV(Numeric rate, Numeric nskip, Numeric amount)

Calculates the Present Value of a future payment.

Parameters

rate
The discount rate for one time period.
nskip
The number of time periods before the payment occurs.
amount
The amount of the payment.

Returns

Numeric

Examples

PV(Numeric rate, Numeric skip, Numeric amount, Numeric pay)

Calculates the Present Value of a series of future payments.

Parameters

rate
The discount rate for one time period.
skip
The number of time periods before the payment occurs.
amount
The amount of the payment.
pay
The number of payments in the series, spaced one time period apart.

Returns

Numeric

Examples