Formulas and Functions

Chapter 6 Financial Functions 141
Related Topics
For related functions and additional information, see:
“PRICE” on page 137
“PRICEDISC” on page 13 8
“YIELDMAT” on page 153
“Common Arguments Used in Financial Functions” on page 341
“Listing of Financial Functions” on page 96
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
PV
The PV function returns the present value of an investment or annuity based on a
series of regular periodic cash ows (payments of a constant amount and all cash
ows at constant intervals) and a xed interest rate.
PV(periodic-rate, num-periods, payment, future-value, when-due)
 periodic-rate: The interest rate per period. periodic-rate is a number value and is
either entered as a decimal (for example, 0.08) or with a percent sign (for example, 8%).
 num-periods: The number of periods. num-periods is a number value and must be
greater than or equal to 0.
 payment: The payment made or amount received each period. payment is a
number value. At each period, an amount received is a positive amount and an
amount invested is a negative amount. For example, it could be a monthly loan
payment (negative) or the periodic payment received on an annuity (positive).
 future-value: An optional argument specifying the value of the investment or
remaining cash value of the annuity (positive amount), or the remaining loan
balance (negative amount), after the nal payment. future-value is a number value.
At the end of the investment period, an amount received is a positive amount and
an amount invested is a negative amount. For example, It could be the balloon
payment due on a loan (negative) or the remaining value of an annuity contract
(positive).