Apple iWork '09 - Manual (Page 349)

Chapter 13 Additional Examples and Topics 349
Function and its purpose Arguments used by the function
“PV” (page 141) is the function to use if you wish
to determine the present value (what it is worth
today) of a series of cash flows, considering the
other factors such as the interest rate. It solves for
the argument present-value. periodic-rate, num-periods, payment, future-value,
when-due
“RATE” (page 144) is the function to use if you
wish to determine the periodic interest rate for a
loan or annuity, based on the other factors such
as the number of periods in the loan or annuity. It
solves for the argument periodic-rate. num-periods, payment, present-value, future-value,
when-due, estimate
As illustrated by this table, these TVM functions each solve for, and return the value
of, one of the five primary arguments when the problem being solved involves
regular periodic cash flows and fixed interest rates. In addition, “IPMT” (page 123) and
“PPMT” (page 135) can solve for the interest and principal components of a particular
loan or annuity payment, and “CUMIPMT” (page 110) and “CUMPRINC” (page 112) can
solve for the interest and principal components of a consecutive series of loan or
annuity payments.
Related Topics
For related functions and additional information, see:
“Irregular Cash Flows and Time Intervals” on page 350
“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