6. Functions : Finance Library Functions : PV Function
 
Share this page                  
PV Function
The PV function calculates the present value of an annuity of a specified periodic payment, earning a given interest rate, over the total number of periods in its life. It uses the same formula as the FV (future value) function (see FV Function).
Note:  Paybegin is either 1 or 0, indicating that the payment is made at the beginning or end of the period.
This function has the following syntax:
PV(pmt = value, i = value, nper = value [, fv = value, paybegin])
Arguments
Data Type
Description
pmt
Float
Periodic payment
i
Float
Interest per period
nper
Float
Number of periods
fv
Float
Future value
Default: 0
paybegin
Integer
1 = beginning of period
0 = end of period
Default: 0
This function returns:
• Float—The present value of periodic payments (pmt) at the specified interest rate (i) or a lump sum deposit (pv) at same specified interest rate over a specified number of periods (nper)
• Null—On error