PV

This method specifies the present value of an annuity based on periodic fixed payments, to be paid in the future, and a fixed interest rate.

Syntax

financial.PV(rate, nper, pmt, [fv], [type])

Parameters

financial

Reference to a Financial control.

rate

Required. Variant that specifies the interest rate per period.

nper

Required. Variant that specifies the total number of payment periods in the annuity.

pmt

Required. Variant that specifies the payment to be made each period.

fv

Optional. Variant that specifies the future value or cash balance you want after you have made the final payment. If omitted, 0 is assumed.

type

Optional. Variant that specifies when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Return Value

Result of the PV calculation.

Remarks

The rate and nper parameters must be calculated using payment periods expressed in the same units. For example, if rate is calculated using months, nper also must be calculated using months.

For all parameters, cash paid out is represented by negative numbers; cash received is represented by positive numbers.