VB & VBA in a Nutshell: The Language

PV Function

Named Arguments

Yes

Syntax

PV(rate, nper, pmt[, fv [, due]])

rate

Use: Required

Data Type: Double

The interest rate per period.

nper

Use: Required

Data Type: Integer

The number of payment periods in the annuity.

pmt

Use: Required

Data Type: Double

The payment made in each period.

fv

Use: Optional

Data Type: Variant

The future value of the loan or annuity.

type

Use: Optional

Data Type: Variant

Flag specifying whether payments are due at the start or the end of the period.

Return Value

A Double specifying the present value of an annuity.

Description

Calculates the present value of an annuity (either an investment or loan) based on a regular number of future payments of a fixed value and a fixed interest rate. The present value is the current value of a future stream of equal cash flows discounted at some fixed interest rate.

Rules at a Glance

• The time units used for the number of payment periods, the rate of interest, and the payment amount must be the same. In other words, if you state the payment period in months, you must also express the interest rate as a monthly rate and the amount paid per month.

• The rate per period is stated as a fraction of 100. For example, 10% is stated as .10. If you are calculating using monthly periods, you must also divide the rate per period by 12. Therefore, 10% per annum, for example, equates to a rate per period of .00833.

• The fv argument indicates the future value or cash balance after the last payment. The default is 0, since that ...