beautypg.com

141 pv – Apple iWork '09 User Manual

Page 141

background image

Chapter 6

Financial Functions

141

Related Topics
For related functions and additional information, see:

“PRICE” on page 137

“PRICEDISC” on page 138

“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 flows (payments of a constant amount and all cash
flows at constant intervals) and a fixed 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 final 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).