answersLogoWhite

0

The PV function is a financial function. It is used to return the present value of an investment based on an interest rate and a constant payment schedule. The syntax is a follows:

PV( rate, number_payments, payment, [FV], [Type] )

Rate is the interest rate for the investment.

Number_payments is the number of payments for the annuity.

Payment is the amount of the payment made each period. If it is omitted, you have to enter a FV value.

FV is optional. It is the future value of the payments. If it is omitted, it is assumed to be 0.

Type is optional. It indicates when the payments are due. Type can be one of the following values:

0 for when payments are due at the end of the period, which is the default. 1 for when payments are due at the start of the period. If the Type parameter is left out, the PV function sets the Type value to 0.

User Avatar

Wiki User

12y ago

What else can I help you with?