Apple iWork '09 - Manual (Page 99)

Chapter 6 Financial Functions 99
Function Description
“PV” (page 141) 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.
“RATE” (page 144) The RATE function returns the interest rate of an
investment, loan, 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.
“RECEIVED” (page 146) The RECEIVED function returns the maturity value
for a security that pays interest only at maturity.
“SLN” (page 147) The SLN function returns the amount of
depreciation of an asset for a single period using
the straight-line method.
“SYD” (page 148) The SYD function returns the amount of
depreciation of an asset for a specified period
using the sum-of-the-years-digits method.
“VDB” (page 149) The VDB function returns the amount of
depreciation of an asset over a chosen time
interval, based on a specified depreciation rate.
“YIELD” (page 150) The YIELD function returns the effective annual
interest rate for a security that pays regular
periodic interest.
“YIELDDISC” (page 152) The YIELDDISC function returns the effective
annual interest rate for a security that is sold at a
discount to redemption value and pays
no interest.
“YIELDMAT” (page 153) The YIELDMAT function returns the effective
annual interest rate for a security that pays
interest only at maturity.
ACCRINT
The ACCRINT function calculates the accrued interest added to the purchase price of a
security and paid to the seller when the security pays periodic interest.
ACCRINT(issue, first, settle, annual-rate, par, frequency, days-basis)
 issue: The date the security was originally issued. issue is a date/time value and
must be the earliest date given.
 first: The date of the first interest payment. first is a date/time value and must be
after issue.